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

Hi there,

Are you using a matrix?

Yes

Are the columns in the table only fields from the query with groupings.

There are 2 calculatd fields once in ssrs year(date) and month(date).

In the dataset...

Ok Thanks, I was hoping to get something more usefull, but apparently not.

I just did this test. I updated the sp to return the top 1% of the data....

29 ms, seconds, minutes?