Search results for query: *

Good man James !! It does work, the error was more subtle than that. Cheers.

Fellas, Couldn't get the CASE WHEN to work within the GROUP BY clause. Performance hit wasn't too bad with Sunila's solution.

Cheers fellas, what can I say? As it happens the field in question is a CASE WHEN clause, I only used the field2 + field3 for easier explanation, which may present further problems if not least for making the query understandable. That said, Zhavics is a quality solution which is now in my PDA...

Fair one. Thanks.

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...

No problem, happy to help. Should you want any further advice I've set the email notification, so just post to this thread and I'll do what I can.

Marie, I'd be reluctant to give you any explicit design instructions just based on what you've said here. Although the details you've put down are clear and concise the reality is that people will draw their own conclusions and mental pictures and they will more than likely be of a different...

I had completely removed the package and any and all entries I found within the registry and still got no joy. Outside of rebuilding my machine I'm completely stumped. I'll let you know if I get a solution (other than working on someone else's machine!)

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...

Cheers Jim.

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...