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

    What Data_Type should I use.

    I can group by just fine on a bit column running SP4. You can not index a bit field however. In all honesty, creating a index on a bit field makes a whole lot of no sense because the index will be ignored anyway when the server does the execution plan. A bit field will always result in a...
  2. Evadman

    Performance issues with Function

    I am totaly missing something. This piece: COALESCE(@Output, '') will ALWAYS return an empty string, no exceptions. You are declaring @Output right above it, and nothing is being done to @output before it gets to the COALESCE function, so it will ALWAYS be null. Therefore, the sql statement...
  3. Evadman

    Cursor question

    Use the Dateadd function, and change the update to update -1 second. Declare @Temp Table(EmpId Integer, Project VarChar(10), PunchIn SmallDateTime, Punchout SmallDateTime) Insert Into @Temp Values(1,'A','09:00:00','10:30:00') Insert Into @Temp Values(1,'B','10:32:00',NULL) Insert Into @Temp...
  4. Evadman

    Cursor question

    Modified your code. Declare @Temp Table(EmpId Integer, Project VarChar(10), PunchIn SmallDateTime, Punchout SmallDateTime) Insert Into @Temp Values(1,'A','09:00:00','10:30:00') Insert Into @Temp Values(1,'B','10:32:00',NULL) Insert Into @Temp Values(1,'C','11:35:00','13:00:00') Insert Into...

Part and Inventory Search

Back
Top