How completely random that this question was asked twice on the same day!?!?!?!?

Here is the other thread. http://www.sqlservercentral.com/Forums/Topic1258889-391-1.aspx

Please realize that NOLOCK is by...

ColdCoffee (2/27/2012)

---

Sean Lange (2/27/2012)

---

ColdCoffee (2/27/2012)

---

CELKO (2/27/2012)

---

CREATE TABLE Customer_History

(customer_id CHAR(9) NOT NULL,

start_date DATE DEFAULT CURRENT_TIMESTAMP NOT NULL,

end_date DATETIME UNIQUE, --null means current

CHECK (start_date <=...

Quinn-793124 (2/27/2012)

---

I have to update a table based on data from another table. Both ways I tried are not working for me.

update VectorReplica.dbo.PARCELS set PARCEL_ID = new_pid from Ranieranneaxparcels

where VectorReplica.dbo.PARCELS.PARCEL_ID...

ColdCoffee (2/27/2012)

---

CELKO (2/27/2012)

---

CREATE TABLE Customer_History

(customer_id CHAR(9) NOT NULL,

start_date DATE DEFAULT CURRENT_TIMESTAMP NOT NULL,

end_date DATETIME UNIQUE, --null means current

CHECK (start_date <= end_date),

foobar_status CHAR(??)...

You will find that a lot more people are willing to volunteer their time and effort if you provide some sort of sample to work in a nice consumable format....

duplicate post. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1257891-147-1.aspx

Take a look at using MERGE. From you description it sounds like what you need.

http://technet.microsoft.com/en-us/library/bb510625.aspx

gpm.alwyn (2/27/2012)

---

Can you try this

CREATE TABLE #Temp(Word VARCHAR(100))

INSERT INTO #Temp VALUES('TR#ABC#10/12/2011')

INSERT INTO #Temp VALUES('TR#XYZ#12/12/2011')

INSERT INTO #Temp VALUES('TR#ABC#10/12/2011')

SELECT REPLACE(MyWords, LEFT(MyWords, CHARINDEX('#', MyWords)), '') AS Word FROM

(

SELECT REPLACE(Word, RIGHT(Word, CHARINDEX('#',...

/facepalm

Thanks guys don't know why I didn't think of for xml. :hehe:

Guess I need more coffee this morning.

Can you explain where this result comes from?

This was edited for clarity while I was posting. 😀

Btw, excellent job posting you ddl and sample data!!!

What you are describing is a...

OK let's try this again. The file with the tables is useful but sample data should be insert statements (preferably ones that you tested).

Last but not least, assuming you provide...

Do be careful or he will be forced to come after you with his pork chop launcher. :w00t:

Have a great weekend.

You are missing the from in your select statement. The subquery that you have named x is acting like your table.

SELECT

SUM([SLAMet])/COUNT([WO_NUM])*100 AS '%TotalMetSLA',

* FROM

(

...

) x

Pretty sparse on details here...there are several ways you could do this. Seems to me you going to be forced to use dynamic sql to create all your tables with...