You mentioned using c# in an earlier post, are you doing this from a c# app. If so this should be pretty simple with some dynamic sql in your c#...

Yeah i don't understand what you mean about loop through the tables. Are you saying that the table name is indicated in the file name? Most likely you will have...

I don't understand. Your data is saved in files and you want to look at each file?

This whole trigger is going to cause you problems at some point even if you work out the current issue. The problem is that you are making the (incorrect) assumption...

Take a look at average and grouping.

This is...

Great! Glad we could help.

I think your logic for not exists is not quite what you are looking for.

select *

into ##Icd9sOnlyInVal

from ##ValitdationData where not exists

(SELECT * FROM ##temp3...

LOL or a right join would do it too. 😛

kevin.l.williams (3/24/2011)

---

rmechaber (3/24/2011)

---

Sean Lange (3/24/2011)

---

rmechaber (3/24/2011)

---

As others have pointed out, the "correct" answer is wrong. Powershell is NOT an option in 2005. I got it right for the...

Your join logic above still won't get what you want. I can toss some pseudocode at it but without actual dll and some sample data i can't test it. check...

rmechaber (3/24/2011)

---

As others have pointed out, the "correct" answer is wrong. Powershell is NOT an option in 2005. I got it right for the wrong reason: I guessed...

Probably just a date column that would have all 4 dates from the where clause in your cte. Then instead of putting your condition in the where you would do...

So digging through this it looks like you want to return a record for 1/25 in the result but there is no record for that date in the source data?...

Sean Lange (3/22/2011)

---

Man I have to say that you come up with the most bizarre requirements ever. You really should consider using proper datatypes to hold your data. You are...

Man I have to say that you come up with the most bizarre requirements ever. You really should consider using proper datatypes to hold your data. You are using nchar(10)...