David Webb-200187 (1/9/2013)

---

As far as I know, there is no way to do a backward restore, even if the database was in a compatibility mode that matched the lower version....

Code snippet:

SELECT @PAY_FREQ = EC.EECPAYPERIOD

,@PAY_FREQ_DIVIDER = CASE EC.EECPAYPERIOD

...

How about these solutions?

declare @DOB date = '20080229',

@CurDate date = '20130228';

select

@DOB as DateOfBirth,

@CurDate as...

10e5x (1/9/2013)

---

oh no, really? Then i will have to...

Prefer my code, doesn't have any triangular joins involved which can kill a server as the amount of data increases.

Jeff Moden (1/9/2013)

---

fearghalreilly (1/9/2013)

---

In one of my tests I was asked this question

you are working as part of the database team for the zoro online company . a junior database...

I may be wrong (meaning I misunderstood the answers), but I would go with E (None of the above).

10e5x (1/9/2013)

---

tried your way but i still dont uds... Especially the co-relation between num and gap in order to derive Consecutive_D. Sorry to be so noob. If u dont mind,...

dwain.c (1/9/2013)

---

I was referring to this in my prior post:

I understand how...

dwain.c (1/9/2013)

---

Lynn Pettis (1/9/2013)

---

dwain.c (1/8/2013)

---

Am I the only one that finds these kinds of SQL puzzles fun?

http://www.sqlservercentral.com/Forums/Topic1403293-392-1.aspx

Come on! Surely some of you heavyweights can whip up a cool solution...

I'm not...

10e5x (1/9/2013)

---

I know this is an slightly old thread but i have some qns on

nigelrivett's solutions. I know there are better solutions offered, especially by Lynn, but i have...

Also consider looking at not-for-profit organizations in your area. You may be able to volunteer your time to help support their database systems and gain experience at the same...

Grant Fritchey (1/9/2013)

---

I'm still back to hard to say, but, in general, I would avoid holding open a query, on purpose, for 15 minutes under any circumstances. The fundamental concepts...

I must be dense or something as I can't figure out what it is you are trying to do based on your description of the problem.

I can't tell if your...