I've noticed that if you run this query

SELECT lastwaittype, LEN(lastwaittype) FROM master.dbo.sysprocesses

the number of characters returned by the second column is one more than you would expect. This final character...

A calendar table may well be the way to go here, but you will still need a method of calculating dates from week numbers in order to populate the calendar...

If the TOP 1 and ORDER BY clauses were removed from my query and the >= 60 condition changed to > 60, it would be functionaly equivalent to your query....

The following should work on SQL 2000. It does use a triangular join within the derived table so there may be performance issues if the appts table has a large...

If the last event in the ticket_history table for a particular RNID records when the ticket is closed (RouteQ = 'CLOSED') and that is an end state for the ticket...

Try this query, which uses the ROW_NUMBER() function to sequentially number rows belonging to the same ticket (RNID) ordered by the time_stamp column. This table expression is then joined with...

The following query returns all the clients who visited in 2008 and the year that the client previously visited or NULL if their first visit was in 2008). If I...

Are appointments available 24 hours a day, 7 days a week?

If not, you will need to take account of the start and end of appointment availability on each day.

Also, if...

Double up the apostrophes (character stuffing)

execute pro_name ' giri''s '

Lookup ROW_NUMBER in SQL Server 2005 Books Online

Agree with you Dugi.

However, here is an improved version of the hex2int function that, from my testing, is almost twice as fast as yours. I think the main reasons for...

If [font="Courier New"]CAST(0x1604 AS int)[/font] returns what you want, this dynamic SQL will also return what you want.

I'm not that comfortable about the use of dynamic SQL here but the...

Apologies for my stupid mistake in the expression for Saturdays and Sundays.

The following is a corrected version. Note that [font="Courier New"]@days/5[/font] is replaced by [font="Courier New"](@days-1)/5[/font] in the expression for...

Here's a method of calculating the Nth working day in the future without using a CTE or tally table.

DECLARE @days int

SELECT @days = 10

DECLARE @inputDate datetime

SELECT @inputDate = '2008-12-23'

DECLARE @weekDay...

The following expression that uses integer division:

DATEDIFF(day, apptDateTime, @dt) / recurDays

will increment by one on the day of each recurring appointment (where @dt is a local...