suneel-210238 (2/8/2010)

---

Hi,

We have a table where we store versions of data and mark with some version indicator. Typically we are having around 50 columns in this table.

We got a requiremnt...

You have to use dynamic SQL, an example is here: http://www.sqlservercentral.com/Forums/Topic769832-338-1.aspx

Other examples are scattered throughout SSC.

BrainDonor

Gail,

How do you find them?

Do you use divining rods? I admire your determination.

BrainDonor

Check the format for DATEADD in BOL - you aren't using it correctly.

BrainDonor

mbookout (2/4/2010)

---

Thanks! But how would I get either of those to compare with the next record? I know how to do it with two date fields within the same...

And DATEDIFF - two ways to solve the same problem.

BrainDonor

Duplicate post, responses to:

http://www.sqlservercentral.com/Forums/Topic859597-146-1.aspx

Roy Ernest (2/2/2010)

---

By seeing your last post on...

Indeed it will. However, you've had to split the values yourself - originally...

I've been waiting for weeks for this one to show their head over the parapet.

BrainDonor.

No.

I will however take as long as is required to help you to work out how to write it. That is how...

In which case you need to check the right-most character of the value first, and then if that is within range you can check the numeric part.

BrainDonor.

I can't say I've ever given any thought as to why MS names things the way it does (that way lies madness), but it probably generates some type of GUID...

Paul White (1/26/2010)

---

BrainDonor (1/26/2010)

---

Steve, could you give this call a nudge - it appears to be stuck....

http://www.sqlservercentral.com/Forums/FindPost853470.aspx

The same message three times in a row - he's determined someone will write...

Steve, could you give this call a nudge - it appears to be stuck....

http://www.sqlservercentral.com/Forums/FindPost853470.aspx

The same message three times in a row - he's determined someone will write it for him.