Lynn Pettis (8/17/2012)

---

Since you are using dynamic sql, this could also work:

CREATE FUNCTION TEST_123(@PARAM nvarchar(50))

RETURNS TABLE AS

RETURN(

SELECT

ID

...

haiao2000 (8/4/2012)

---

Hello Experts,

I am trying to come up with a better solution for our intranet web application (running on SQL Server). this process currently works as follow:

-a back end loader...

demonfox (8/7/2012)

---

rVadim (8/7/2012)[hrThen another way is to implement this as a "File Management" solution.

1. Don't discard files after loading, instead save them to a predefined archive location.

2. Create a table...

rVadim (8/7/2012)

---

Then another way is to implement this as a "File Management"...

Yes feed means files. I think location is probably be configurable. I would predict each client config differently.

Got you. Thanks!

SQLKnowItAll (8/6/2012)

---

We handle this a bit differently, and it depends on your space allowance... We take a backup every night of said database, and then restore it to databaseName_dayOfWeek. ...

well, if there are several versions , then anyhow the data has to kept somewhere; for different version you may have to add an attribute,a column, to identify the data...

MyDoggieJessie,

I agree. what SSIS and BCP stand for?

Thanks!

Demonfox,

Thank you for your suggestion, I think that is an excellent approach. I don't anticipate we keep every version of the data as it is very expensive to do...