Oh yeah...to check the retention period.

SELECT [retention]

FROM [msdb].[dbo].[cdc_jobs]

WHERE [database_id] = DB_ID()

AND [job_type] = 'cleanup'

Mvs2k11 (11/26/2012)

---

I would like to retain the data for change data capture log tables to 365 days.

Please let me know the calculation for the retention period for 365 days in...

finnyol (11/26/2012)

---

In the read i need to select the driver name and a driver that is qualified to drive a certain vehicle, the input is the load_id from the load...

amar_kaur16 (11/26/2012)

---

I have a dataset for students and they have either selected 'Math' or 'Science' or both.

So I have 2 rows, 1 for Math and 1 for Science if they...

I am guessing this is a test or an interview based on the OP posting 3 very vague general questions all at roughly the same time.

Not sure if you mean Windows service packs or sql server SP's. Either way there is checking within...

You could also have a computed column that is similar to what G2 suggested.

As a side note, you should try to avoid goto's in your code like in that trigger....

leesider (11/26/2012)

---

Sean Lange (11/26/2012)

---

You should look at datepart.

For example, 2012-04-03 is in the fifteenth week of the year so if that date appears then the week number 15 should...

nfs_john (11/26/2012)

---

Mr. Lange,

Sorry for the delay I was pulled off to another fire before coming back to this project. As for this question and answer I don't see where to...

I highly doubt you need a loop or cursor for this. This sounds like a simple insert from select type of scenario. If you want some help with coding you...

What you are trying to do here is called a cross tab query. You will likely need to use a dynamic version of this. There is a great article referenced...

You should look at datepart.

For example, 2012-04-03 is in the fifteenth week of the year so if that date appears then the week number 15 should appear along side...

Sony Francis @EY (11/26/2012)

---

I have table with 20k records. I want to delete 20k-1000 records from the table. i.e keep the top 1000 records and rest of them are need...

This sounds like a poorly thought out requirement. How will you know if the column should be NULL because the value is unknown or if the actual value is 'unknown'....

You do NOT need a cursor for this. It is not totally clear what you want here but ROW_NUMBER should be able to provide you what you need. If you...