:-)And i hope you understood why it failed..

If you didn't, have a look at the following link

http://www.sqlservercentral.com/blogs/never_say_never/archive/2010/1/28/in-and-not-in.aspx

Check if this the below code returns any NULL values

SELECT ID FROM @TempTable

If it does your first query will fail..

And posting some sample data along with your table structure will...

This will be a useful link for you..

http://www.sqlservercentral.com/articles/SQL+Server+2008/65539/

Glad i could help you out:-)

Look for the explanation of ROW_NUMBER in Books Online. You can also Google for some good examples on the same.

You can also play with the...

Just add the column Section in the PARTITION BY Clause as shown below

ROW_NUMBER() OVER ( PARTITION BY EmployeeID, Section ORDER BY T1.StartDate DESC ) Row

Glad that i could help you out:-)

This should help..

CREATE TABLE TestTable

(

page_idINT,

parent_idINT,

page_titleVARCHAR(50)

)

DECLARE@strSQL VARCHAR(MAX)

DECLARE@iPageID INT

SET@iPageID = 5

INSERT TestTable

SELECT 1, 0, 'Home' UNION ALL

SELECT 2, 1, 'Park' UNION ALL

SELECT 3, 1, 'Library' UNION ALL

SELECT 4, 3, 'Library2' UNION ALL

SELECT...

Not sure about the performance aspect. But this will help you avoid certain problems that are mentioned in the following link

http://www.sqlservercentral.com/blogs/never_say_never/archive/2010/1/28/in-and-not-in.aspx

Then, you can't replace your above statements with a single statement.

But i can give you a better way of doing the update without using the #C and which will not...

What is the purpose of creating the temporary table #C? Are you using it anywhere else other than your second statement?

I didn't test but this should work..

; WITH cteTableDetails AS

(

SELECT ROW_NUMBER() OVER ( PARTITION BY EmployeeID ORDER BY T1.StartDate DESC ) Row, T1.*

FROM Table1...

smknox (3/12/2010)

---

IF NOT EXISTS(SELECT ID FROM Table1 WHERE ID=2)

Insert Into Table2 ...

Insert Into Table3 ...

Insert Into Table4 ...

From here I want to continue with updates to tables based on a...

SELECTCOUNT(*)

FROM(

SELECT DATENAME( MONTH, DATEADD( DAY, N - 1, @sdtStartDate ) ) Col1, COUNT(*) Col2

FROM dbo.Tally

WHERE ...

Try this one..

DECLARE@tblTable TABLE

(

DateFromSMALLDATETIME,

DateToSMALLDATETIME

)

INSERT@tblTable

SELECT'04 January 2010', '03 February 2010' UNION ALL

SELECT'06 January 2010', '05 February 2010' UNION ALL

SELECT'26 January 2010', '25 February 2010' UNION ALL

SELECT'01 February 2010', '03 March 2010'...

What would be the expected result if you have data similar to this???

DECLARE@tblTable TABLE

(

Day1 INT,

Day2 INT,

Day3 INT,

Day4 INT,

...