just thinking ahead - you may have to use OPTION (MAXDOP,1) in there somewhere - it may get a bit confused with the union on the same table.

not sure whether...

Select Col1, Col2, Sum(Col3)

From

(

Select Col1, Col2, Col3 from T1

UNION

Select Col1, Col2, Datediff(HH, Col5, Col6) as COL3 From T1

)

group by Col1, Col2

i think that should do it

the only way i can see to do this is by seperating your stored procedures off into a seperate database.

you can then drant DDL to your developers for the...

what exactly do you want to do with COM, what languages are you looking to develop in???

also consider that .NET is now the logical replacement for COM

have a look at NetIQ's products

they will check out index sizes, database sizes, statistics, fragmentation etc over a perfiod of time and give you some nice trend graphs.

they have...

so what you're asking really is -- is there a way to detect whether it's BST or not from the current date? and then apply a date modifier if it...

can you post an example of the data - sureley you just need to use dateadd(hh,1,[date]) and dateadd(hh,-1,[date]) to go backwards and forwards one hour ???

have you tried diabling TCP/IP and using another protocol to test ?

first of all you're going to have to identify all of the duplicate surnames in your primary table and also all of the equivalents in your import table.

if you set...

there are several tools to do this - although i've found that the best way to do this is to us a bit of VB and use an ADO connection...

a - time for a joke about servers running FLAT out...

sorry

i'd recommend using query analyser to look at your insert execution plans, then use a product like NETiq to find out what SQL is being run on your server. that...

is there a primary key on the table? if so is it clustered???

have you looked at the data load options in your dts package ??? are you using the fast...

well some idiot specified this system to the police force. and now we're left picking up the peices. - they've spent so much on the system (because some network techie...

with client network you can create an alias for TCP/IP, but only for a port number - you can't specify the IP it listens on....

both cards have different addresses.