Are those times in seconds or is it another figure?

If it's seconds and assuming that query won't run 100 times a second, then there's no real need to tune it...

This is a simple one...

select workstation, date_entered from inventory where part_number='ABC' and workstation>=5 order by workstation, date_entered;

if @@rowcount = 0

--make this call another sp to get the best execution...

More to the point... this is really an ETL task...

Download data, validate it first, then reinsert the valid data and warn about problems.

No real need to flush out the fks...

I think it may work better with a 0 in the range! >>>

SELECT 1 WHERE '111' NOT LIKE '%[^0-9]%'

Grinja (1/7/2010)

---

I maybe mistaken but I'm sure I read somewhere that TRUNCATE TABLE will be rejected if there is an FK pointing to the target table even if the FK...

IF Object_Id('tempdb..#temp') IS NOT NULL...

You can disable the constraints and then reenable them with the check option which will revalidate all the data.

I also only transfer new data based on a date in the...

Even if he can't add persisted columns... if I run a straight select and then a select with your computations it runs in the exact same time over 1M records...

In EM, right click on the procedure and git permissions (sorry I don't have EM here to confirmt he name of the option, but it's in there somewhere).

You can also...

Thanks a lot... I'll have to ask for a copy of the bills since I need to evaluate also if the licensing covers our actual and coming needs (changing ERP,...

How did you get out of this problem? I need to do the same thing with a new client... they have everything all the way up to 2008 installed.

TIA.

Ditto with Dave, I learn best by starting out trying to build something from a user then figuring out the best way to do it in SSRS once I have...

It turned out that adding with recompile whipped out parameter sniffing and bad query plans. Then adding SET ANSI_WARNINGS OFF... INSIDE the SP solved the warning.

Now the report is...

BTW, got any great performance / tuning / best practices article for reporting services?

Thanks for the info, I'll take all that into consideration when I rewrite tomorrow.

Also, I appreciate your running fine comments.

I agree that data has changed. However I tested that...