Hi and welcome to the forums. It is generally preferred if you can post ddl and sample data in a consumable format. Since you are brand new around here I...

Patrick Dooley (11/7/2013)

---

Hello - I've got a lot of experience writing basic queries, but I've not come across the REVERSE(STUFF(REVERSE... functions, and I am encountering them fairly frequently in my...

spin (11/7/2013)

---

Hi

i have the following field in a progress db which contains analysis codes for a given account. I need to split the codes into their own columns.

here's an...

Excellent job posting ddl and sample data. I wish everyone posted everything like that to make it easy!!!

Something like this should work.

declare @EmployeeID int = 285;

with EmployeeTree as

(

select e.ManagerID, e.EmployeeID,...

By far the simplest approach here is to use the technique I described. I guess since everyone is completely ignoring it that either I have lost my mind or nobody...

The "simple" fix here is to use something like this:

where (@All <> 'Y' and CLIENT_IDENTIFIER_TYPE.Code between @Code and @CODE2)

or @All = 'Y'

However, this now is exactly the pattern that the...

Unless it is a totally different thing I would think in this thread is fine. You already have a couple people following this one anyway. 🙂

Oops. Forgot to post the link. 😉

http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/%5B/url%5D

Generically you can use ROW_NUMBER for this.

INSERT INTO SPEDDTL (spdd_f1, spdd_f2, spdd_f3, spdd_f4, spdd_f5, spdd_f6, spdd_f7)

( SELECT spd_f1, spd_f2, spd_f3, spd_f4, ROW_NUMBER() over (order by (select null)), spd_f6, spd_f7

FROM...

It...

You might want to take a look at this article from Lynn. It has lots of datetime routines. You are going to need to utilize a number of these once...

a20213 (11/5/2013)

---

i want May 6th because its the first tuesday of May, like today is the first tuesday of November, its the most "logical" day, just i have a feeling...

Tej_7342 (11/5/2013)

---

There are 2.2 billion records in the table and we want to only keep 2 weeks data, as of now we are lagging behind so we want to delete...

You could greatly simplify your code by using a foreach instead of a for loop. This way you don't have to try to control the row counter. Your entire Main...

Tej_7342 (11/5/2013)

---

Hey Guys,

i have to delete data from a table which is older than 2 weeks, how can i use a cursor to do it.

I will have to place the...