Viewing 15 posts - 2,251 through 2,265 (of 3,221 total)
karthikeyan-444867
what kind of analysis that i have to do apart the below.
I would add:
a. Schemas - do they appear appropriate
b. Security - in particular does any user...
December 11, 2009 at 3:55 pm
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...
December 11, 2009 at 1:54 pm
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
...
December 11, 2009 at 1:27 pm
Read this article by Jeff Moden. About half way through the article I think you will find what you need.
December 11, 2009 at 11:00 am
CREATE TABLE #employee
(empno INT,empfname VARCHAR(20),emplname VARCHAR(20),managerempno INT)
INSERT INTO #employee
--empno. empfname emplname managerempno
SELECT 12345, 'Sumanta', ...
December 9, 2009 at 2:21 pm
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...
December 9, 2009 at 1:44 pm
GSquared
That's why my preferred method of development involves LOTS of user-interaction during the design and building
Expanding on GSauared's comment .. Sociology has studied small groups (generally a minimum of 3...
December 9, 2009 at 1:13 pm
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...
December 8, 2009 at 11:46 am
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...
December 8, 2009 at 11:09 am
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...
December 8, 2009 at 9:11 am
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...
December 7, 2009 at 7:02 am
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...
December 6, 2009 at 1:56 pm
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...
December 6, 2009 at 8:21 am
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...
December 4, 2009 at 4:42 pm
Elliott W
Try this one:
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.
December 4, 2009 at 3:54 pm
Viewing 15 posts - 2,251 through 2,265 (of 3,221 total)