I would add:

a. Schemas - do they appear appropriate

b. Security - in particular does any user...

Alvin Ramard (12/11/2009)

--------------------------------------------------------------------------------

GSquared (12/11/2009)

--------------------------------------------------------------------------------

select cast(Number as varchar(10)) + ' bottles of beer on the wall

' + cast(Number as varchar(10)) + ' bottles of beer

take one down, pass it around'

from dbo.Numbers

where...

SET NOCOUNT ON

DECLARE @Rem INT

SET @Rem = 56

DECLARE @Down INT

SET @Down = 1

DECLARE @Verse VARCHAR(Max)

SET @Verse = ' '

WHILE @Rem > 0

BEGIN

...

Read this article by Jeff Moden. About half way through the article I think you will find what you need.

http://www.sqlservercentral.com/articles/T-SQL/63003/

CREATE TABLE #employee

(empno INT,empfname VARCHAR(20),emplname VARCHAR(20),managerempno INT)

INSERT INTO #employee

--empno. empfname emplname managerempno

SELECT 12345, 'Sumanta', ...

You may want to look at a solution posted by Lowell

http://www.sqlservercentral.com/Forums/Topic830694-8-2.aspx

Agreed the problem is NOT identical to yours but is similiar in nature and may give you an idea...

Expanding on GSauared's comment .. Sociology has studied small groups (generally a minimum of 3...

Lowell

This is posted in a SQL 2000 forum, is it true that CTE,

or Common Table Expression was introduced in SQL 2005 and before that i.e., in SQL...

slimchance99

I need to be able to return clients with no entry on either shift, and I also need to identify which shift (day = 1, evening = 2) was missed.

I...

Using a sub set of your data this appears to work and is set based.

Sub set utilized client_id of 9824 and 14595 with last date of 20090927:21:21:00.000

SELECT Client_id,MONTH(log_time),DAY(log_time),YEAR(log_time) FROM zLogEntries

GROUP...

To gain an understanding of how Excel stores dates read this blog entry by Brian Jones. It contains an excellent discussion of how and why date information is actuall...

Of the two suggestions, the one I would prefer is:

Participate in an indexed view.

As long at the view exists, it will block the truncate command. The view does not have...

A backdoor method to prevent any user from using the the TRUNCATE TABLE command would be to create an INDEXED VIEW on this table, as a table contained in an...

When you create a procedure using sp_xxxx

SQL Server interprets the sp_ such that it looks for the procedure in the master database. In this manner for example if I...

The above link refers to SQL Server 2008 Books Online (October 2009)

and the user has posted his/her question to a SQL 2005 forum.