I can't really answer that question. We do use SSRS, but I'm not currently involved with it myself beyond using a few reports which we get to using the...

For edification:

where

[column_name] not like '%10BUC%' and

[column_name] not like '%UNCLGAD%'

is equivalent to

where

not ([column_name] like '%10BUC%' or [column_name] like '%UNCLGAD%')

Drop HyperBac another email and see if they'll send you an older version of the program to check out.

You do not need SharePoint to take advantage of SSRS. SSRS integrates with SharePoint allowing you to manage security from one place, SharePoint, if you so desire.

What version are you running? If you posted it, I can't seem to find it.

William Plourde (7/24/2009)

---

I have coded two sql select stmts that I though would be equivalent but have learned through observation that they are not, the issue now is that I...

Say good night Gracie.

I'm still running 3.0.11.0.

.,.,., why not let Jeff post the url? Others, like myself, may just benefit ... oh, you want to keep us in the dark, like mushrooms! 😛

george sibbald (7/24/2009)

---

total processor % jumps up about 25% to 50% average, speread evenely across the cpus (4)

Do the...

Still using a simple table, but probably meets your requirements. Each run of the query took approximately 8 seconds.

declare @PageNum int,

@RowsPerPage...

michael vessey (7/24/2009)

---

that's not really do-able for me

as i said, this might be a huge query with maybe 15 tables

so your example of

with PagedData as (

select

...

This is really weird. Is there anything else running on the servers? Anti-Virus software, etc?

Gift Peddie (7/24/2009)

---

dont think I quite understand, Code is simply data if you could recover all your data then why are you not able to recover all your code?...

Something like this?

declare @PageNum int,

@RowsPerPage int;

set @PageNum = 1;

Set @RowsPerPage = 10;

set statistics io on;

set statistics time on;

with PagedData as (

select

...