If you were deleting all data more than 6 months old as a single batch and the delete was still running when the system rebooted, the recovery is rolling back...

njdevils39 (5/4/2012)

---

R.P.Rozema (5/3/2012)

---

njdevils39 (5/2/2012)

---

So, in my post to go off from this code:

ALTER PROCEDURE [dbo].[WEB_HR_GetRateHistory]

(

@ORG_LEVEL_ID INT,

@EMP_ID INT

)

AS

BEGIN

DECLARE @x XML;

CREATE...

Jeff Moden (5/4/2012)

---

Ummmm... I've not run any of the code but, just by looking, shouldn't any ordering be done in descending order so that you get the "latest" row like...

capn.hector (5/4/2012)

---

i was attacking it the same way lynn was and my code is very similar. i may suggest making idLigne an INT instead of a VARCHAR as that...

Nope

I'm guessing something like this:

/*

My table ...

Does everything else work for this user when running the FedEx software?

Does the software properly update everything it is supposed to update?

w

vinu512 (5/4/2012)

---

I agree with you Cadavre. But my requirement here is such that I am not able to think set based. Following is the requirement:

I have to get the "Names"...

That too. Sorry, brain was stuck on tally table as I had just been working with one.

PaulB-TheOneAndOnly (5/3/2012)

---

Can't rollback TRUNCATE in the...

sivag (5/3/2012)

---

for example here i am using five table?

table1

cid categoryname

1 cricket

2 ...

Yes it is, you could cross join the data with a numbers or tally table.

adrian.facio (5/3/2012)

---

Well, i just did not tougth that "Widowed To Divorced" could be ok, i think i made my conclusion there, if you guys feel this change is ok, then...

First observation, I wouldn't try to put the identity column as the first column. Column position is actually meaningless to SQL Server.

Second, how big is your current table (number...