In wraped it in .bat and .cmd - result is the same as before. vbs is Visual Basic ? Let me try to wrap it to vbs too, but I really...

Number of databases in a server ?

select count(*) from master.sys.databases

if you want to exclude system databases:

where database_id > 4

If you are running accross multiple servers, make sure that you have...

If I understood you right, you can apply something like this query (I did NOT test it):

select

e.init,

e.pos,

sum(p.amount)

from events e join pays  p

on e.unit = p.unit

and e.pos = p.pos

and p.date >=...

Where register between 30000 and 32000

will work for you ?

You may try the following:

select max(data)

from

(

select data from tableA

union all

select data from tableB

)t

Yes, you're right. Now I got same numbers as yours. Sorry, when I tested them yesterday I apparently tested same query twice.

Partition as same thing as grouping, in my tests both queries showed same estimated cost

Generally, the skeleton for your trigger will look like this:

create trigger my_trigger

   on  my_master_table

   after update

as

declare

@id  int,

@val int

    select

        @id = id,

In your SSMS go to SQL Server agent / Jobs / Right-mouse click -> New job. In the New Job window put some meaningful name for the job.

Go to...

Create an update trigger on your table holding variable data. This trigger should update values in your final table.

1. Probably the author intended to post SQL puzzle. Maybe site administrators should create such kind of forum, SQL puzzles ?

2. Your code actually deletes all the rows except the...

Do you have a recent backup of your master database ? Try to restore it to another server first. Try to login there as sa, if it will work, restore...

select cardid, max(activedate)

from #cards

where activedate < '08/01/2007'

group by cardid

Did you try to login with DAC - Dedicated Admin Connection ?

You want to run a .exe or .dll on a web-server, and want to initiate this call from within SQL Server ? If that is correct, you can do it...