Here's 1 exemple. I needed to keep the date updated / added and by whom on that table. On top of that I needed a deleted flag and...

Yes... it cannot really be otherwise.

You can obvioulsy add more fields when you need to, but the 2 most important fields are the 2 pks.

Have you tried with a single variable? I think I remember reading about that requirement on the post I sent you.

SET @Path = 'c:\whatever.txt;d:\report.html;\\Shared\this.zip'

This thread might help you out :

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=118851

Thanks a million to all who've helped on this problem.

I've had a very happy conclusion yesterday. After being told but the erp cie that it was impossible to add...

Here's the article I used to get started... I used the other one when I got stuck. I'm using vs2008 on sql 2008 64 bit and c# 3.5 so...

This might help you get started.

http://www.gotreportviewer.com/

TAMMYAUDETTE (4/12/2010)

---

Yes, this would be simply for downloading reports, invoices etc.

But integrating the two? The two what? Sorry, I'm a little lost.

Given that this isnt a transactional or...

Well yes and no.

You lose windows authentication...

DBCC TimeWarp would be so usefull for this one :-D.

Paul White NZ (4/10/2010)

---

While revisiting the Numbers table solution, I discovered that the following code creates a table from 20 names in 6 seconds on my old laptop:

USE tempdb;

GO

IF ...

I don't see why you would put that last one ine there (ID (FK Uniqueidentifier, but just a normal field)).

The 2 tables linked together need an id. Then the...

Paul White NZ (4/9/2010)

---

Been busy on another thread - writing a SQLCLR routine to return the phase of the moon for a given date...

Ultimately, query optimisation is an art more than anything else...

We can't answer that without seeing the query, table defs and .sqlplan.

Please send those over and we'll be able to point you in the right direction.

One point to have in...