cengland0 (7/27/2011)

---

There's a difference between a hard question and a tricky one that is attempting to have as many people...

Without knowing the actual values for your StartDate and EndDate, the following works:

DECLARE @StartDate DATETIME

DECLARE @EndDate DATETIME

SET @StartDate = '2011-07-26 11:50:33.420' --arbitrary value

SET @EndDATE = '2011-07-26 21:50:33.420' -- arbitrary...

Look at the ISNULL function ...

http://msdn.microsoft.com/en-us/library/ms184325.aspx

By the way many who might have answered your question with a tested procedure are hesitant to open attachments not knowing if there may...

Craig Farrell (7/25/2011)

---

bitbucket-25253 (7/25/2011)

---

So to forestall any complaints on another QOD I submitted, it includes creating a schema, a table, code inserting the data, and the settings for auto create...

Tom.Thomson (7/25/2011)

---

Ninja's_RGR'us (7/25/2011)

---

My question got corrected today and all points awarded back.

It's a little weird ±5 days after the fact and I still don't see the new wording as a...

Go here and calculate the probability of it happening

http://www.vpgenius.com/tools/combin.aspx

From Books On Line - emphasis added

nchar [ ( n ) ]

Fixed-length Unicode character data of n characters. n must be a value from 1 through 4,000. The storage...

You may want to use the MERGE statement, for example:

CREATE TABLE TBLANIMAL(animal vaINSERT INTO TBLANIMAL

SELECT 'Horse',0,'Giddyup' UNION ALL

SELECT 'Elephant',1,'Bigone' UNION ALL

SELECT 'Horse',0,'Giddyup' UNION ALL

SELECT 'Elephant',1,'Bigone' UNION ALL

SELECT 'Goat',0,'no...

Is this the result you are looking for:

;WITH cte

AS (SELECT Row_Number() OVER(PARTITION BY Sys_Item_Num ORDER BY Trans_date DESC) as rn,

Sys_SR_Num, Sys_Item_Type_Num, Sys_Item_Num, Trans_date, Rcpt_Qty, Sply_Date, Sply_Qty, Open_blnce,

Trans_Blnce_Qty, Trans_Open_Blnce FROM...

Is this what you are looking for?:

CREATE table #Products(item1 INT,item2 INT,total INT)

INSERT INTO #Products

SELECT 1135 , 1190 , 5 UNION ALL

SELECT 1190 , 1135 , 5 UNION ALL

SELECT 1120 ,...

You can remove (actually set to midnight) the value of GETDATE by:

SELECT DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0)

Tried it using 2008 and it works there as well..........thanks

The reference cited simply states that it is defined as DATETIME data type, but does not give its default value. Do you have another reference, for without a defalut...

reportmaster (7/20/2011)

---

Hi.

I have a lot districts with zip codes and sales figures. Then i join some addresses to each zip code.

Finally the user try to filter several districts, render and...

Think this might do it.

;WITH cte

AS (SELECT Row_Number() OVER(PARTITION BY EmployeeID ORDER BY ID DESC) AS rn,ID,EmployeeID,Salary

FROM @TestTable)

SELECT * FROM...