Well 2/29 is not valid in either 2010 or 2011. Looks like Kingston fired blindly and got a direct hit!!!

Your error is happening because you have some value in one of those columns that is being converted (either implicitly or explicitly) to a bigint and the source column contains...

And the 28,000+ queries isn't exactly going to be fast. :w00t: Add to that the implicit conversion on every single column...might was well take a nap.

If we could just the...

Lynn Pettis (4/24/2012)

---

SQLRNNR (4/24/2012)

---

Lynn Pettis (4/24/2012)

---

I didn't know JR was killed? I thought...

What does your split function look like? Can you post that with some ddl and a couple rows of sample data?

wutang (4/24/2012)

---

Thank you so much for taking time and looking at my problem. This will help my problem.

I am just happy that people take time to respond...

Agreed. This should be pretty simple but 28k+ rows is WAY too much. I let your insert for more than 5 minutes on my box and it was still going....

rogle 43122 (4/24/2012)

---

WOW!

That was fast, thanks! Good to know I included all the info needed, have to confess I wasn't sure about the larity of my request workding.

I am now...

Adi Cohn-120898 (4/24/2012)

---

One more way, that uses the same logic as Sean, but uses a CTE instead of derived table.

with MyTests as(

select L.Name, TestDate, PfReal, row_number() over (partition...

Because they are third party vendors and as such have less than...

Wow first post and you posted everything to make this easy for us!!! Excellent!!!

Something like this should work

select * from

(

select l.Name, l.ActiveStatus, t.*, ROW_NUMBER() OVER (partition by l.LocID order...

Lynn Pettis (4/24/2012)

---

The Dixie Flatline (4/24/2012)

---

I'm getting a smile this morning just from hearing about a train wreck in the distance. They are much more fun when...

sdownen05 (4/24/2012)

---

Sean, I like your suggestion for my situation. I like the other one, but the original AuditTable is part of a proprietary ERP system, and if I try to...

adrian.facio (4/24/2012)

---

Hi, what do you think about this one?

-- A tally table is needed.

CREATE TABLE Numbers (Number INT)

INSERT INTO numbers

SELECT TOP 1000 row_number() OVER (

ORDER BY column_id

)

FROM sys.columns;

-- Number...

+1