Lynn Pettis (6/5/2008)

---

That comes to this, do you have x years experience or 1 year experience x times over. I have seen both. I believe I am in...

jim.powers (6/5/2008)

---

bullcrap420 (6/5/2008)

SELECT a.EmployeeID

FROM HumanResources.EmployeePayHistory AS a

WHERE RateChangeDate <>

...

You're still running up against essentially the same problem.

SELECT isn't guaranteed to pull them in physical order, so while you will end up with 5000 rows, some may...

The problem you have is that the ROW_NUMBER() you keep hearing about is the row number applied over a specified order, OR a randomized order. Physical order has no...

Bull -

Can you give us some specifics on your table? I'm not sure I'm clear on whether you have a row number or not, and if you don't,...

Not sure I added anything to your initial question - but thanks for the feedback!

Ronnie (6/5/2008)

---

Hi,

The customer will not give me access to the sql server cluster, the reason being that it runs other applications to the one I support.

I get information in...

Thanks for the feedback folks... Some good comments. I will try to incorporate them next time.

I did have a bit of a hard time wording it. ...

I'm thinking all you need is to put parens around the @sql in the EXEC.

As in -

...

EXEC (@SQL)

....

Your sequence of events in your code is wrong. Let's recap:

-you create cursor and variables.

- you fetch data.

- you enter...

As far as I can recall - index reorgs are always fully logged, so switching your recovery model will have no impact on what is logged during a reorg. ...

yup!

The only thing I could think of is to literally create the SP's with different code if you're on different versions. So use your IF...THEN logic to create different...

If the two really are exclusive - I can't help but think that a UNION ALL query would be fastest.

Select s.serviceID, s.structureID, s.providerID,p.providerName

from

Service s

...

I agree with Steve. That is the most common use for transactions I know of. There should be about a zillion examples of that out there, including several in Books...