OK now we have some data. However it is not consumable. It would help your cause greatly if you...

vigneshlagoons (10/9/2013)

---

Hi Sean,

I really appreciate it. I am new to this forum and new to SQL too and will do the one you tod me going forward. As of now...

Stefan Krzywicki (10/9/2013)

---

jcrawf02 (10/9/2013)

---

Stefan Krzywicki (10/8/2013)

---

SQLRNNR (10/8/2013)

---

Stefan Krzywicki (10/8/2013)

---

Well, time to polish the resume and start looking for work. Just given a 1 month notice.

They want to keep me on...

Eshika (10/9/2013)

---

Hi I am using Stuff with XML Path for concatenating the data in multiple columns like city, town etc by Zip code. ie., unique column is Zip and all...

As David suggested earlier, in order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT...

TRACIEJOHNSON30 (10/9/2013)

---

I need some assistance....I have the screen shot attached below. I would like the output to have column headers 'vessel' and each of the twelve months. I would like...

There is absolutely nothing in your code to try to prevent duplicates. A case expression does not do this, it will return whatever values the logic says to return.

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

Do be careful there.

You might want to look at what those...

SQLRNNR (10/8/2013)

---

Koen Verbeeck (10/8/2013)

---

Stefan Krzywicki (10/8/2013)

---

SQLRNNR (10/8/2013)

---

Stefan Krzywicki (10/8/2013)

---

Well, time to polish the resume and start looking for work. Just given a 1 month notice.

They want to keep me on...

I am not a huge proponent of always making sure everything is ANSI compliant and "cross language compatible". If you are changing databases it is massive undertaking.

In sql server I...

briancampbellmcad (10/8/2013)

---

I put in WHERE (tbl_pac2k.[Installation Start Date] > DATEADD(DAY, -7, [Installation Start Date])) AND (tbl_pac2k.[Installation Start Date] < DATEADD (DAY, 21, [Installation Start Date]))

into my embeddded query and it...

Stefan Krzywicki (10/8/2013)

---

Well, time to polish the resume and start looking for work. Just given a 1 month notice.

They want to keep me on a retainer for 5 hours a...

It...

astrid 69000 (10/8/2013)

---

I will prepare a litter of coffee and sit down for some light reading 😀

thanks to you too so much for your help.

I will let you know how...