Search results for query: *

I'm trying to write a T-SQL function that can find the third Tuesday, or the fourth Saturday, or the second Wednesday of every month. I found a VBScript version of something similar at http://www.merlyn.demon.co.uk/vb-dates.htm#ILS. VBScript and T-SQL don't do dates exactly the same way. I'm...

I have a situation where I have three tables (InternalEvents, ExternalEvents, Classes) that each need access to a RoomReservations table. Each event or class may reserve multiple rooms, so each of those is on the one side of a one-to-zero-or-many relationship with RoomReservations. The...

Hi everyone. I am in the midst of moving our Intranet system from Windows NT to Windows 2000. (I know, I know.) I am a web programmer, not a network admin. Our old Windows NT Intranet was relying on a dll called NTUtils to get a list of groups. On the new system, I want to use the abilities...

All the stored procedures I've written return a recordset. Now I have need of an sp that returns both the recordset and a count of the number of rows in the recordset. It seems like it should be a peice of cake, but I've looked and looked and can't figure it out. Thanks!

I'm having a tough time with this one. I've spent days trying to figure it out. The stored procedure included below parses out and the procedure is created when I play it. But when I run it, I get this error message: Server: Msg 170, Level 15, State 1, Line 7 Line 7: Incorrect syntax near 't'...