Sorry, got snippy with an OP.

50 lashes with a noodle please.

dateadd(month,4,@CurrentDate);

dateadd(month,14,@CurrentDate);

A quick look in Books Online would have answered this question a lot faster than posting it on the...

BrainDonor (11/16/2015)

---

djj (11/16/2015)

---

I will be the first to admit I am not the smartest person, but at least I try to ask questions by providing requested information with my try...

Jeff Moden (11/13/2015)

---

I'm curious... How did you...

Jeff Moden (11/13/2015)

---

Alright, nexus2vijay... Putting the teaching hat back on, let's work on the first problem...

Here's the problem as you listed it in the original post on this thread...

1. List...

Sean Lange (11/13/2015)

---

TomThomson (11/13/2015)

---

Jack Corbett (11/12/2015)

---

Sean Lange (11/12/2015)

---

Brandie Tarvin (11/12/2015)

---

Sean Lange (11/12/2015)

---

djj (11/12/2015)

---

Grant Fritchey (11/12/2015)

---

Still, could be fun. Build out a nested CTE inside a function, use the...

Is this...

Lacking expected results:

CREATE TABLE #shipping_data(

tracking_no VARCHAR(8000) NOT NULL

,order_no VARCHAR(8000) NOT NULL

);

INSERT INTO #shipping_data(tracking_no,order_no) VALUES ('1Z0310590353768186','1245807,1245812,1245803');

INSERT INTO #shipping_data(tracking_no,order_no) VALUES ('1Z0310590352682798','1256835,1359465');

INSERT INTO #shipping_data(tracking_no,order_no)...

One other thing, based on the sample data you provided, what is the expected results?

celticpiping (11/12/2015)

---

understood: I should have known to post table data.

I'll attempt to provide table data below.

Source table, and associated insert code:

...

CREATE TABLE #shipping_data(

tracking_no NVARCHAR(MAX) NOT NULL

...

celticpiping (11/11/2015)

---

Howdy again Lynn, things crashed around here so been ..bisy

Say, not sure if I've used up my newb-requests for this month, but

concerning the query we've put together, I was...

After reformatting your code, the subquery in the CASE is independent of the outer query. To demonstrate that, I renamed the aliases used in the subquery based on how...

jigging.tech (11/6/2015)

---

Thank you all for the replies.

The applications connect to a middle man home grown application that then sends the T-sql queries to production... so 85% of the queries all...

Sean Lange (11/6/2015)

---

Lynn Pettis (11/6/2015)

---

Here is a posting for a SQL Database Administrator. I've looked it over several times. Please tell me where it says anything about PostgreSQL...

Here is a posting for a SQL Database Administrator. I've looked it over several times. Please tell me where it says anything about PostgreSQL besides in the Skill,...