Just tested it on some 400.000 rows and it runs about 1 minute. On 1 million rows it took 2:15.

That's not too good, but since I didn't try to optimize...

Hi,

this is quite an interesting problem. I never had to do anything with such calculations, but I was interested how I would solve it and here is what I...

Hi Richard,

I will not describe how to parse a list of values into a table - that has been topic of many posts and you can find it easily. If...

"OP" is the person who started the thread by posting a question - "Original Poster" or something like that.

About the strange names for tables... Often someone wants to store certain...

Florian Reischl (4/15/2009)

Do you know how it would be possible to add a CRLF to the end of the rows? If I use either CHAR(13)+CHAR(10) or a direct CRLF within...

Mayank's code is missing one more thing, and that is the word "ADD" in front of the column name... but you can easily correct that.

Well, since almost the same can be viewed in BOL easily, and I have a printout at hand, I probably won't need it - but I'm sure other people will...

Is the row inserted into history table immediately when a new price is set, or only after the price loses validity? In other words, is the current price in the...

anvarabn (4/6/2009)

---

When i will enter the same base and local currency based on the new entry's from date it will calculate to date for the previous entry.

example

first entry

fromdate...

xgcmcbain (4/6/2009)

---

it just seems stupid to me that i have to write some vb or c# script to loop every record and insert one record at a time. i...

xgcmcbain (4/5/2009)

---

I rather not have to import the text file into a temp table, and then to a insert statment with a left outer join on itself and saying where...

Just a sidenote... we are sending lots of mail checks to users, and we have found it best to separate the logic of the check and the action of sending...

Most often such question (or even request to do it) arises when there are some problems with date of certain action - especially if something needs to be entered into...

Hello,

maybe it would be best to post both triggers and explain why delete trigger...

Well, you could do that if you really wish, but in my experience the jobs can have very different durations, based on the amount of processed data, fragmentation of indexes...