How to insert into table based on previous results

Question

Post reply

How to insert into table based on previous results

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 1

That's it, but I've got a sneaky suspicion that the CAST has to be to VARCHAR, otherwise the zero prefix won't work.

SELECT ReviewDate, Hub, BankNumber, BranchNumber, AccountNumber =

RIGHT('00000000000000000' + CAST(CAST(AccountNumber AS BIGINT) + 1 AS VARCHAR(18)), 18)

FROM Ex_ItemsException

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

jbuttery Ten Centuries Points: 1226 More actions · Answer 2

Thanks, Chris. That syntax looks good to me.

The link on the bottom of your posts is incorrect. It should be http://www.sqlservercentral.com/articles/Best+Practices/61537/

I finally read it and apologize for my post, but didn't want to accidentally show any confidential information. Thanks again for your help.

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 3

Chris Morris (4/7/2009)
jbuttery (4/7/2009)
Thanks for the replies guys. I'll try suggestions. I can do a SELECT, but not sure how to manipulate data and then insert.
Post the select, Flo will show you how to do the rest 😉

Hi Chris!

Thanks for covering me! I've been in a conference call...

😀

Greets

Flo

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 4

jbuttery (4/7/2009)
Thanks, Chris. That syntax looks good to me.
The link on the bottom of your posts is incorrect. It should be http://www.sqlservercentral.com/articles/Best+Practices/61537/
I finally read it and apologize for my post, but didn't want to accidentally show any confidential information. Thanks again for your help.

It works, I checked it 😉

You're welcome, thanks for pointing out the error in my link, and good luck!

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 5

No worries Flo. I wondered where you'd got to - you were right on the ball, then disappeared:w00t:

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden