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!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- Evadman
- Post #14
- Forum: Microsoft SQL Server: Programming
-
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...- Evadman
- Post #7
- Forum: Microsoft SQL Server: Programming
-
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...- Evadman
- Post #6
- Forum: Microsoft SQL Server: Programming
-
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...- Evadman
- Post #3
- Forum: Microsoft SQL Server: Programming
