Show us what you are trying to accomplish, show us all the code.

dwain.c (4/9/2012)

---

Jeff,

Thanks for the compliment even if it was a bit hesitant.

You can't blame me for wanting to have a bit of fun with this one as I'm still in...

CELKO (4/9/2012)

---

This is more of a temporal problem than a recursive problem.

A useful idiom is a report period calendar. It gives a name to a range of dates....

D-SQL (4/9/2012)

---

Hello Im still struggling with this. Any suggestions on he syntax. THis would be one column in the index to desc leaving the rest to asc.

We have to do...

Actually, the inner rollback rolls back all open transactions.

Please read and follow the instructions in this article:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Hopefully this helps you figure out what you need.

with ctePolicyStatus as (

select

row_number() over (partition by policyid order by lastupdated desc) as rownum,

policynbr,

...

Can't really tell from what you have posted.

Please read and follow the instructions in this article:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

taiwuit (4/9/2012)

---

J-F,

thanks for the info! Im very new to using SQL server, is this SSIS a feature in SQL 05 I can access or would I have to purchase...

Except I got the table name wrong. :w00t:

mymail.default (4/9/2012)

---

Thank you GSquared. I think you have nailed it. Here is how I have:

The stored proc I created is in a different schema:

create proc Schema1.Test

as

select CodeValue from...

Sean Lange (4/9/2012)

---

...as Sean goes over the bridge again he hears something faint...

Sean is pretty certain there is some heavy breathing sounds from under the bridge. Conjuring up the last...

Okay, your procedure creates the temporary tables, but it never populates them.

njdevils39 (4/9/2012)

---

Sean Lange (4/9/2012)

---

Wow here we have another last minute addition to the specs...sheesh.

The code Lutz posted about 20-30 posts ago was more than 99% of what you needed.

declare @emp_id...

DASD or SAN?