Search results for query: *

Is it possible to Group on a calculated ? I'm trying the following SELECT field1, field2 + field3 AS field4, SUM(field5) FROM Table1 GROUP BY field1, field4 but receive Server: Msg 207, Level 16, State 1, Line 1 Invalid column name 'field4' Initially I presumed that it couldn't group on...

Morning All, I want to create a temporary table while an original is still in use. Once created I want to replace the original with the temporary and continue business as usual. This process is also going to be a weekly occurance. The only bonus in this affair is the fact that all users will...

Hello, I'm using a c# component with Biztalk and so I need to register the component with COM+. I've registered successfully then changed the component including the addition of a prefix to the namespace ie was previously ReceiveDropShipRequest is now LegacyWarehouse.ReceiveDropShipRequest I...

Is there anyway of returning the key value of a row inserted to a table that has the key generated by SQL Server. I need to insert some data then immediatley retrieved that row.

Eventhough my servers regional date format is UK (dd/mm/yy) I'm experiencing seemingly arbitrary date formatting and conversion problems with my select and update queries both from vb/vbscript and query analyser as it appears to use US formats. Any ideas on what I'm not doing or need to do ? I...