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, 6 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...

I suspect that you'll need to upgrade your VS version to match or exceed the SQL Server version (ie, 2019 or 2022).

thanks Phil! I appreciate the quick response, please understand if I'm asking on a forum it's because I have tried to resolve it first and then subsequently trolled through...

SELECT ...
FROM ...
WHERE DATEADD(WEEK, 4, appl_CreatedDate) <= appl_ConversionDate;

You've stated a requirement without asking a question.