It is never a good idea to store date and time data in string format.

i need to...

Sorry I don't understand the question.

This was covered in depth in another thread recently.

Just about every available method is discussed, including using Tally tables, a custom CLR aggregate, and a very fast way to find...

Well that all sounds very much like a problem that can be solved and optimised with tweaked 'running totals' code or a custom aggregate.

You don't need to post the exact...

Exactly -...

On the flip side of this particular coin, what is worse: DBA by committee or a single DBA that posts the sort of questions we see on here regularly? ...

Jeff Moden (5/29/2010)

---

I wonder what the interview process was and how full of hooie the resume was that allowed someone to have a job that required someone to do the...

Excellent find! I voted it up. There's a partial...

Gah! ...

-- Shift information

CREATE TABLE dbo.Shift

(

shift_id INTEGER NOT NULL

...

It seems to me that the confusion has arisen through a misreading of the INSERT syntax, which does allow for a WITH common_table_expression (see http://msdn.microsoft.com/en-us/library/ms174335.aspx).

The second point is that a...

Itzik Ben-Gan ran a great series of articles on the maximum concurrent sessions problem a few months back.

Anyone with a subscription can view the final article at http://www.sqlmag.com/article/tsql3/calculating-concurrent-sessions-part-3.aspx

The fastest T-SQL...

This version is more efficient:

SELECT This.ClientCode,

This.FlowDate,

This.TempletID,

...

To answer...

Jeffrey Williams-493691 (5/28/2010)

---

To check for a temp table, you can do the following:

IF object_id('tempdb..#DeleteUserID') IS NULL

BEGIN

-- your code here

...