So you want a process which compares what is in a database table with what is contained in a flat file and which then modifies the flat file to reflect...

I don't understand. When you restore from a backup it includes all the data from the backup. SQL Server does not do incremental backups.

The one big downside though is passing a multi-valued parameter to the stored procedure. IIRC - don't use SSRS now - it has to be passed as a single...

Try this:

INSERT #partsfeature
(
    PartId
   ,FeatureName
   ,FeatureValue
   ,PartFeatureNumber
)
SELECT s.PartId
      ,s.FeatureName
    ...

OK. And what would NULL become if they did not...

OK, so your table contains (2421,'grail','51V',2) and you try to insert (3900,'grail','51V',NULL) and for some reason, this is an issue.

After, inserting (3900,'grail','51V',NULL), what would you like the NULL to be...

for the Part 3900

I have feature name grail and feature value 51V it exist on table before insert and take technology id 2

so when insert same feature name with...

Those are all good points in favor of using stored procedures.  Something else to consider though is who is in charge of creating reports?  What permissions do they have...

What's the best way to segregate the SSRS stored procedures from the rest, put them in their own schema, and then grant users execute on the schema? (and SSRS...

I've read this about five times now, yet still I do not understand what the problem is.

Can you try explaining it again, please?

In particular, this:

my issue Done For Part id...

Thanks for the replies. Thom, that caching behaviour you describe catches me out approximately once a month!

I'm glad that you both think along the same lines as me. I can...

• This reply was modified 3 years, 4 months ago by Phil Parkin.

In line 6 of DataTabNew, should NewRnge be 22?

SELECT CAST(Col AS DATETIME)

Why not configure the Foreach container like this?

The 'Traverse subfolders' option means that all folders underneath Employee will be looped. I'm assuming that you archive folders/files elsewhere...

Hello and welcome to the forum.

It would be very helpful if you could provide some test data for the Game and Team tables, along with your desired results based on...