ksrikanth77 (9/25/2015)

---

Hi All,

I have a stored proc I want to convert it to either a Normal Query using A while loop or a set based operation/recursive cte as I...

Please don't cross post. It just fragments the answers and makes it hard to follow.

Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1722856-119-1.aspx

Please don't cross post. It just fragments the answers and makes it hard to follow.

Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1722856-119-1.aspx

Welsh Corgi (9/24/2015)

---

It has been a while since I have written a Trigger.

I need an INSERT UPDATE Trigger that will update the DateModified Column to GetDate().

I recall it being very...

spam reported

sgmunson (9/23/2015)

---

Gazareth (9/16/2015)

---

Don't envy you this task, sounds like changing a database collation but less fun!

I'd be fighting hard to change columns to built in datatypes rather than new/modified user...

eric-470517 (9/23/2015)

---

It is a package software so I am sure the vendor has not updated the data types in quite some time. So I am working with what i...

Hi and welcome to the forums. This would be an excellent place to start. http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/%5B/url%5D

I have to ask, why do you have an image column with RTF values? The image...

Paul Munter (9/22/2015)

---

Hi All,

I'm looking for some advice with comparing times in the same field. I have two tables, one table has times of sessions (multiple rows) and the other...

I thought Lynn was hippo tax exempt?? When did this change and does the Sultan know??

sharonsql2013 (9/22/2015)

---

Hi I am trying to split the annual cost into monthly numbers based on the contract Period.

Since the contract period varies from company to company not sure how to...

sqlizcool (9/22/2015)

---

Thank you for teaching me how to fish, I really appreciate the tip. I was able to use join to grab the data. I am 100% more efficient than...

sqlizcool (9/22/2015)

---

Hi Guys,

I am a sysadmin being asked to collect data from sql DBs on our app servers. Each app server has a group of customers that use a specific...

I sort...

Lynn Pettis (9/22/2015)

---

Sean Lange (9/22/2015)

---

Agreed. I have a feeling yours might win out because iirc the unpivot...