I just hit reply to post almost the exact same code. 😉

If you want to read about how this works or explore a dynamic version of a similar thing you...

msmvijayakumar (1/31/2014)

---

Thanks to all

Hi for my requirement i have to capture the Changed column Name and the Old Value alone. so to completed my task i used Cusor, Dynamic Quey...

Alan.B (1/30/2014)

---

Well done! Just a...

Ryan George (1/31/2014)

---

Lempster (1/31/2014)

---

GilaMonster (1/31/2014)

---

Ryan George (1/31/2014)

---

Good idea. Maybe take your own advice? Would you tell someone that you've never met and that you asked for free...

damcguire (1/31/2014)

---

actual data in the field is Number of Bene's

among other things, this is the SQL I most recently tried

Delete from rcd_def_dtl

where rcd_prop_desc like '%''%'

errors returned

Msg 102, Level 15, State...

Revenant (1/30/2014)

---

Sean Lange (1/30/2014)

---

Can somebody help me out? We have a third part vendor helping us code some piece of one of our applications. Not my choice, I would much...

Excellent job posting ddl and sample data. I have tried to read the explanation of what you are trying to do and it is just making my head spin. Can...

This discussion has moved to a new thread...http://www.sqlservercentral.com/Forums/Topic1536570-391-1.aspx

Can somebody help me out? We have a third part vendor helping us code some piece of one of our applications. Not my choice, I would much prefer to keep...

Not sure we need to go so far as full table definitions and sample data. I suspect this is far simpler. OP, please post the update/delete statement and we can...

Can you post the code you are trying to run?

That is one of the analytical functions introduced in 2012. Since you posted in a 2012 forum it...

mbrady5 (1/30/2014)

---

Hello,

I am working on a project where I need to retrieve the contents of an MS Access table using SSIS that is on a remote server.

Info.

To access the Access...

saurav.rukd (1/30/2014)

---

I have a software company. I have made a desktop software in visual studio that uses SQL SERVER DATABASE at back-end.

I want to sell my software. So i have...

vitex2003 (1/30/2014)

---

SELECT RangeType,StartDate,EndDate,Comment

FROM dbo.TestTable

WHERE convert(char(10),EndDate,102) >= cast('01 Oct 2013' as datetime)

AND convert(char(10),StartDate,102) <= cast('01 Nov 2013' as...