Something like this maybe?

CREATE TABLE #Sales

(

ClientID int,

SaleDate date

);

INSERT INTO #Sales (ClientID, SaleDate)VALUES (1, '20120131');

INSERT INTO #Sales (ClientID, SaleDate)VALUES (2, '20120131');

INSERT INTO #Sales (ClientID, SaleDate)VALUES (3, '20120131');

INSERT INTO #Sales (ClientID, SaleDate)VALUES...

Stefan Krzywicki (8/2/2012)

---

Lynn Pettis (8/2/2012)

---

Stefan Krzywicki (8/2/2012)

---

SQLRNNR (8/2/2012)

---

Steve Jones - SSC Editor (8/2/2012)

---

Just a quick reminder here to everyone. This is a public forum, so the things you post are...

Stefan Krzywicki (8/2/2012)

---

SQLRNNR (8/2/2012)

---

Steve Jones - SSC Editor (8/2/2012)

---

Just a quick reminder here to everyone. This is a public forum, so the things you post are tied to you and...

SQLRNNR (8/2/2012)

---

Steve Jones - SSC Editor (8/2/2012)

---

Just a quick reminder here to everyone. This is a public forum, so the things you post are tied to you and available for...

L' Eomot Inversé (8/2/2012)

---

Don't believe what you read on the internet.

Single oar sculling happens...

gsd1 (8/2/2012)

---

My requirement is as the following

My xml file from web service:

<Rows><row><lastUpdateDate>2009-10-07T15:19:23.000-04:00</lastUpdateDate></row></Rows>

I am pulling data into the temp table like the following:

...

Also, this code ran quickly because the data itself is not very wide. You would need to test this is a test environment using your actaul table to determine...

Reading what opc.three posted I need to agreeregarding the clustered index. I ran the code above once with the primary key being a nonclustered index, and it ran for...

As soon as you add the column with the IDENTITY property, it will be populated by SQL Server. Even using SET IDENTITY_INSERT you will not be able to change...

I Binged your question:

http://www.graftonrowing.asn.au/oldgrcsite/about/row_scul.htm

GSquared (8/2/2012)

---

Do you mean the part where I said this:

It's been a while since I used Erwin, but, last time I used it, it was a serious PITA. Visio works...

Lynn Pettis (8/2/2012)

---

Rob Schripsema (8/2/2012)

---

Lynn Pettis (7/20/2009)

---

Or

WHERE

...

and [CORE_CO-PERSON].[D-O-B] <= datediff(yy, -16, getdate()) -- where DOB is less than or equal to todays...

Rob Schripsema (8/2/2012)

---

Lynn Pettis (7/20/2009)

---

Or

WHERE

...

and [CORE_CO-PERSON].[D-O-B] <= datediff(yy, -16, getdate()) -- where DOB is less than or equal to todays date 16...

Unfortunately it is hard to help you when we can't see what you see. If you would post the DDL (CREATE TABLE statement) for the table or tables involved,...

CELKO (8/1/2012)

---

have a suggestion Mr. Celko, and it may save you a lot of typing in the future. Look at all your (imho, not so useful) posts...