funcion USE

Tengo un Query de esta forma, pero son como 10 bases, las tablas y
campos son los mismos siempre, como puedo usar la funcion USE para
solo copiar y pegar los SELECT?

Gracias,

select
coalesce(s1.account, s4.account) as Account,
coalesce(s1.balance_001, 0) as Balance_001,
coalesce(s4.balance_004, 0) as Balance_004
from (
SELECT
SBO_001.dbo.JDT1.Account,
sum(SBO_001.dbo.JDT1.SYSDeb - SBO_001.dbo.JDT1.SYSCred) AS
Balance_001
FROM SBO_001.dbo.JDT1
GROUP BY SBO_001.dbo.JDT1.Account
) s1
full outer join (
SELECT
SBO_004.dbo.JDT1.Account,
sum(SBO_004.dbo.JDT1.SYSDeb - SBO_004.dbo.JDT1.SYSCred) AS
Balance_004
FROM SBO_004.dbo.JDT1
GROUP BY SBO_004.dbo.JDT1.Account
) s4
on s1.account = s4.account

igual puedes adaptar un poquito el código algo así..

sp_msforeachdb 'use ?; select db_name(),count(*) from
information_Schema.tables'

Saludos Cordiales
Miguel Egea
Solid Quality Mentoshttp://www.portalsql.com

"Gabrielg" escribió en el mensaje de
noticias:



> Tengo un Query de esta forma, pero son como 10 bases, las tablas y
> campos son los mismos siempre, como puedo usar la funcion USE para
> solo copiar y pegar los SELECT?

> Gracias,

> select
>  coalesce(s1.account, s4.account) as Account,
>  coalesce(s1.balance_001, 0) as Balance_001,
>  coalesce(s4.balance_004, 0) as Balance_004
> from (
>   SELECT
>   SBO_001.dbo.JDT1.Account,
>   sum(SBO_001.dbo.JDT1.SYSDeb - SBO_001.dbo.JDT1.SYSCred) AS
> Balance_001
>   FROM SBO_001.dbo.JDT1
>   GROUP BY SBO_001.dbo.JDT1.Account
> ) s1
> full outer join (
>   SELECT
>   SBO_004.dbo.JDT1.Account,
>   sum(SBO_004.dbo.JDT1.SYSDeb - SBO_004.dbo.JDT1.SYSCred) AS
> Balance_004
>   FROM SBO_004.dbo.JDT1
>   GROUP BY SBO_004.dbo.JDT1.Account
> ) s4
> on s1.account = s4.account- Hide quoted text -

- Show quoted text -

On Feb 16, 5:56 am, "Miguel Egea" wrote:
Mostrar la cita

igual puedes adaptar un poquito el código algo así..

sp_msforeachdb 'use ?; select db_name(),count(*) from
information_Schema.tables'

Saludos Cordiales
Miguel Egea
Solid Quality Mentoshttp://www.portalsql.com

"Gabrielg" escribió en el mensaje de
noticias:



> Tengo un Query de esta forma, pero son como 10 bases, las tablas y
> campos son los mismos siempre, como puedo usar la funcion USE para
> solo copiar y pegar los SELECT?

> Gracias,

> select
> coalesce(s1.account, s4.account) as Account,
> coalesce(s1.balance_001, 0) as Balance_001,
> coalesce(s4.balance_004, 0) as Balance_004
> from (
> SELECT
> SBO_001.dbo.JDT1.Account,
> sum(SBO_001.dbo.JDT1.SYSDeb - SBO_001.dbo.JDT1.SYSCred) AS
> Balance_001
> FROM SBO_001.dbo.JDT1
> GROUP BY SBO_001.dbo.JDT1.Account
> ) s1
> full outer join (
> SELECT
> SBO_004.dbo.JDT1.Account,
> sum(SBO_004.dbo.JDT1.SYSDeb - SBO_004.dbo.JDT1.SYSCred) AS
> Balance_004
> FROM SBO_004.dbo.JDT1
> GROUP BY SBO_004.dbo.JDT1.Account
> ) s4
> on s1.account = s4.account- Hide quoted text -

- Show quoted text -

No quiero todas las databases del Servidor.
Simplemente saber donde colocar el USE, dado que cuando lo uso despues
de la funcion from (..tengo error

Gracias