kaushal_shah26 (8/1/2012)

---

capn.hector (8/1/2012)

---

i have a couple of things in mind but i think the OP is looking for an UPDATE statement. the question i have is that i cant...

i have a couple of things in mind but i think the OP is looking for an UPDATE statement. the question i have is that i cant see why...

gordon.davis (8/1/2012)

---

Hi,

Could you Please help me to get Output like below.

SNLabel StartDate EndDate

...

Here is the basic format to get the first and last day of the previous 3 months.

SELECT DATEADD (MM, DATEDIFF (mm, 0, GETDATE()) - 1 - N, 0), DATEADD (MM,...

I would look at http://www.sommarskog.se/dyn-search-2008.html as it describes exactly what you want to do. it also offers several ways to accomplish the task which are safe from sql injection...

Tequila

well now in the morning im even more embarrassed at the mistake i made.

on another note my head hurts, where is my aspirin.

Kathmandu

well no more tequila and coding late at night. just made an *** of my self.

dwain.c (7/26/2012)

---

capn.hector (7/26/2012)

---

------Almost pure moden splitter modified slightly to take a NVARCHAR(MAX)

and have a cteTally big enough and eliminate the OR when calculating the start of the string-----

------Aaron version...

Ok so here is the response im planning with code. i cant account for the major difference in time. as i state i make only minor changes to...

Jeff Moden (7/26/2012)

---

dwain.c (7/26/2012)

---

Good idea. I was utterly dumbstruck by his performance ranking of the...

Jeff Moden (7/26/2012)

---

I know I enjoyed it. Gave me a chance to try out my new 4 band porkchop...

have you configured the windows firewall to allow SQL Server traffic? I have had that issue my self.

http://msdn.microsoft.com/en-us/library/ms175043.aspx

SQLKnowItAll (7/26/2012)

---

The ultimate goal is to allow a customer to rollback any changes. Whether it is a minute ago or a day ago. We don't want to manually...