Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Cairnsey

    Column AS within GROUP BY clause

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

    Column AS within GROUP BY clause

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

    Column AS within GROUP BY clause

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

    Column AS within GROUP BY clause

    Fair one. Thanks.
  5. Cairnsey

    Column AS within GROUP BY clause

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

    Replacing a live table while in use.

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

    need help with determining classes

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

    need help with determining classes

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

    tlb already registered

    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!)
  10. Cairnsey

    tlb already registered

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

    Key value of inserted row

    Cheers Jim.
  12. Cairnsey

    Key value of inserted row

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

    Regional Date Formats

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

Part and Inventory Search

Back
Top