Well, if you fixed it, show it. It may help others with a...

Also need the error you get when using the DISTINCT. Better yet, post your query using it as well.

knikolov4521 (1/4/2015)

---

Thank you! But I do not want to for example IT_PROG to be displayed 5 times. Please take a look at the attached picture. I tried to use DISTINCT,...

Eirikur Eiriksson (1/4/2015)

---

Jeff Moden (1/4/2015)

---

Eirikur Eiriksson (1/4/2015)

---

Jeff Moden (1/4/2015)

---

Eirikur Eiriksson (1/4/2015)

---

The MERGE does produce an optimal plan for the operation, single scan of both the source table and the first...

... Mark one off, 55 days on the calendar to go. 55 days on the calendar to go, 55 days to go, ...

Jeff Moden (1/3/2015)

---

It's only the 3rd of the year and I believe we already have a candidate for the year's most vague question.

http://www.sqlservercentral.com/Forums/Topic1648047-2799-1.aspx

Anyone have even a clue as...

shashianireddy (1/3/2015)

---

i have excel file like below

sno name fname ...

??

Not sure what you are looking for with so little information.

... Mark one off, 56 days on the calendar to go. 56 days on the calendar to go, 56 days to go, ...

One other thing I would look at are your data types. It looks like all your string types are NVARCHAR(max). Do you really need the strings to be...

For those looking for this new thread, here it is: http://www.sqlservercentral.com/Forums/Topic1647953-3077-1.aspx

o324712 (1/2/2015)

---

This is in the code and the sample I am using to develop the custom split, Set @pString='CS12_PrbTmp_L_DegF_1M'.

I for got to mention I do have a PK column for...

spaghettidba (1/1/2015)

---

Happy New Year everybody!

And there's a very special thank you message for every single one of you on my blog here! 🙂

Thank you for involving me in the most...

... Mark one off, 57 days on the calendar to go. 57 days on the calendar to go, 57 days to go, ...

Like this:

/*

Country Address2 Resulting Column

Australia Sydney Australia Sydney

USA Washington USA Washington

United Kingdom London United Kingdom London

*/

create table dbo.Addresses (

Address2 varchar(128),

...