This should get you started:

DROP TABLE #TABLE1

CREATE TABLE #TABLE1 (ID INT, EmployeeName VARCHAR(20)) -- see SELECT TOP 20 in CROSS APPLY

INSERT INTO #TABLE1 (ID, EmployeeName)

SELECT 1, 'Ritesh' UNION ALL

SELECT 2,...

DECLARE @Fathers TABLE (FatherId VARCHAR(10), age INT)

INSERT INTO @Fathers

SELECT 'Father1', 12

UNION ALL SELECT 'Father1', 17

UNION ALL SELECT 'Father2', 22

UNION...

dbowlin (6/7/2010)

---

Ah Yes. There is really nothing like 100 proof over the counter cold products.

Nyquil, When only a good buzz will get you through that miserable...

Here's a little comparison between "quirky update"...

exomycorrhiza

Perspective

Game! With chips! Where's me bow?

Richard Gardner-291039 (6/3/2010)

---

I personally find the following entirely helpful when faced with stupid questions (although I'm possibly guilty of it myself at times)

http://lmgtfy.com/?q=SQL+Server+2005+Delete+Query+Syntax

Stupid Question #345: Why can't I get the...

Would you like fries with that, sir?

Tomato

Pow R Toc H

C-rations

That works Mark, nice one. So does this:

;WITH OrderedData AS (

SELECT Seq = ROW_NUMBER() OVER (ORDER BY [Name], [DateTime], Price),

[Name], Price, [DateTime]

FROM #Temp

),

Calculator AS (

SELECT fr.Seq, fr.[Name], fr.Price,...

So what you are really trying to do...

This should be reasonably quick, and it's simple to understand and use, too:

DROP TABLE #Temp

CREATE TABLE #Temp (id INT, [Name] VARCHAR(40), Price Money, [DateTime] DATETIME)

INSERT INTO #Temp (id, [Name], Price,...