min.li,

without writing a whole pile of SQL here's a few tips

1. union

union can be used to compile datesets

e.g.

select *

from TableA TA

inner join TableB TB

...

peter (4/28/2009)

---

Here is what I came up with....I would not neccecarily consider this full set based code, but I did eliminate the cursor and it scales far better then the...

min.li (4/28/2009)

---

Hi,

Thanks for all reply. I am working on SQL server 2005. However, Samuel's solution does not work on my SQL server, which returns following error message:

Msg 4104, Level 16,...

Good point... the solution I posted is 2005/2008 specific. Probably could...

min.li (4/28/2009)

---

Hello,

I recently had to use curosr to do a function in my work. Although I knew I should try to avoid cursor, but could not find a way. I...

Steve Jones - Editor (4/27/2009)

---

For the email solution, we run a .NET app here to send the mail, offloading the load of XP_sendmail from SQL Server. We grab a bunch...

OK it...

atoth (4/27/2009)

---

I still find I need Cursors when Sending out batches of Email notifications from the Server.

I would love to replace this with set based handling but I can imagine...

jwheeler (4/27/2009)

---

Then surely the manager hasn't done their job by employing the wrong tool for the task?

If you have database development to be done you either employ a...

Not really and it's something I've seen a few times...

When someone has a background in...

Nice article, with some practicle advice on manually editing the report XML

Your last comment though:

As a final word, I would also like to add that .NET knowledge is required if...

It loads all fields from all files, just give it an initial directory path and it will find all the csv files in that directory and it's subfolders and load...

could you give sample data and an example of how you would like the output to look.

Your second wording wasn't any better :ermm:

I've done generic CSV file uploads using SSIS and am in the process of about writing an article on it (along with some related file stuff in SSIS)

PM me if...

Adam Aspin (2/26/2009)

---

Thanks to both of you for this one - this is a very good idea that I have not covered it in this way in the following articles...