Grant Fritchey (2/23/2009)

---

Kit G (2/23/2009)

---

But then, most of the time, movies made from book suck. Unless we are talking about Phillip K Dick stories, then it is the other...

[font="Verdana"]Oh yeah. I think we've all run into that one. 😀

Try forcing yourself to use sp_executesql rather than exec (). Gives you better options for parameters.

[/font]

[font="Verdana"]Heh. It might be helpful to read something about SQL Server if you are trying to learn SQL Server. Reading about Java's not likely to be of much...

[font="Verdana"]Can't use dynamic SQL inside a UDF.[/font]

[font="Verdana"]Firefly/Serenity. sigh

Favourite books would be Dune (written same year as I was born) and maaaybe Lord of the Rings (I've read it at least once a year since I...

[font="Verdana"]Have you googled the error message? What did you find?[/font]

[font="Verdana"]Could you give us some hint as to what's not working? That way I will have a better idea of what to look for.[/font]

[font="Verdana"]The issue with using a linked server for this approach is that you create a dependency between your systems. I.e. if you customer management system goes down, then your...

[font="Verdana"]Floats have issues with representing certain numbers. There are some numbers (for example, 0.3) that they cannot represent other than inexactly. Also, conversions between different numeric types and...

[font="Verdana"]I wouldn't try mixing your code with mine. Just use mine.

As a hint, you could take the entire select statement and make it another derived table...

I think you have...

[font="Verdana"]The clues are there... what have you tried?[/font]

[font="Verdana"]Unpivot and then use sum() might be abother option. Probably more effort than it's worth though.[/font]

[font="Verdana"]I've posted the code changes above. :)[/font]

[font="Verdana"]One word of warning:

The error could lie with the driver -- a memory leak, or running out of space while building temporary files, etc. So moving the file around...

[font="Verdana"]I ran out of time in my case. I focussed on showing the cumulitive data errors as a result of business code in triggers failing, rather than the performance...