Which one did you use or was it a combination? It would be great if you would share what...

So do you only want to show columns for days? What happens when you have more than...

Dhananjay - did the example and explanation Lynn posted help you understand? The problem with datediff is calculates differences on a boundary. The results is how many of those boundaries...

Jeff Moden (3/14/2013)

---

Alan.B (3/7/2013)

---

Cursors, loops and dSQL fall under the last choice column but this is one of those cases...

For tables you would do this:

EXEC sp_MSforeachtable'SELECT TOP 1...

Lynn Pettis (3/14/2013)

---

Sean Lange (3/14/2013)

---

I haven't seen all the other threads but from what you posted I can't figure out why you are using DATEDIFF at all. It doesn't meet...

seshagirikudaravalli (3/14/2013)

---

I have one current table and one history table. current table has three additional columns. Is it possible to join these two tables using union statement. I can not...

Yes if there is no natural key you should add something like an identity column and make that your primary key.

I haven't seen all the other threads but from what you posted I can't figure out why you are using DATEDIFF at all. It doesn't meet your requirements and it...

duplicate post. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1431270-392-1.aspx

Gotcha. Change the user you login to SSMS with your captured data...

kevaburg (3/14/2013)

---

Oooooops! It would appear I am talking out of holes normally reserved for other purposes!

That is exactly the procedure I saw but I didn't read it...

Bobby Glover (3/14/2013)

---

I'm trying to use CDC for auditing certain tables, the problem I find is it doesn't capture the user.

I have tried using Default Constraints SUSNAME_USER and adding an...

Alan.B (3/14/2013)

---

That is not a stored proc that comes from SQL Server. If you can run this:

exec sp_MSforeachview 'select top 1...

Definitely need to provide more details. I would highly recommend that you use aliases in your queries. Your table names are very long and not terribly user friendly. I took...

rifayeem (3/14/2013)

---

in my webpage,if i select the month january,,it will call the query and retrive as 6days in the month of january,the remaining 3days will be retrived in the month...