mayur birari (3/13/2012)

---

Thanks for the reply.

But I cannot do that because A is a physical table in the database and all I'm doing is a clean up stuff. I cannot...

I love it!!!

I always thought that SSIS (or any other 3-rd party ETL tool) gives "Application group" much more...

Try:

1. Use SELECT INTO to insert records you want to stay into new table using INNER JOIN, IN or EXIST

2. Drop the old table

3. Rename new one to old name

Lynn Pettis (3/13/2012)

---

Eugene Elutin (3/13/2012)

---

Can someone explain why everyone suggesting huge concatenation logic when date in YYYYMMDD format can be produced as a simple convert with option 112 for ISO?...

what the following sentence from this article does mean than? :

It may be possible to...

Can someone explain why everyone suggesting huge concatenation logic when date in YYYYMMDD format can be produced as a simple convert with option 112 for ISO?

HowardW (3/13/2012)

---

Eugene Elutin (3/13/2012)

---

Where have you read this from?

It does not make query to run any faster! It just...

That is different story, if I understand you right, then:

UPDATE S

SET AmtAuth = A.AmtAuth

FROM ##TempTm S

JOIN ##TempTm A -- we join to the record of type A

ON A.ReferenceNumber = S.ReferenceNumber...

Lynn Pettis (3/13/2012)

---

You really should consider passing the datetime in using the ISO standard format. SQL will properly...

Could you please edit your post. It's impossible to read...

texpic (3/13/2012)

---

Guess I didn't indicate the result I needed. Need the 0 in AuthAmount when Source = S to be updated to 100. It does not update.

Why did...

Your data sets cannot be inserted to the tables created by provided DDL's. After I've spend time to make it run, I found that your data sample is absolute useless...

UPDATE A

SET AmtAuth = B.AmtAuth

FROM ##TempTm A

JOIN ##TempTm B

ON A.ReferenceNumber = B.ReferenceNumber

AND A.CardNumber = B.CardNumber

And if you want convert DateTime to string and format it as YYYYMM, you can simply do this:

select LEFT(CONVERT(VARCHAR,GETDATE(),112),6)

- 112 - is code for ISO format

Edited: I can see that...

Your question is quite obscure or incorrect (whatever you like)!

"Date...