Thanks, will this allow them to read SP definitions?

select

case when charindex(':','Test123',2) = 0 then 'Test OutPut'

else

right('Test OutPut',charindex(':','Test:123',2)-1)

end

I want people in the field to be able to email a mail generic account with a client's ID number as the subject. Then have SQL generate a dataset and...

Do you know what could write to a table?

Thanks, these are some really great pointers...and yes, we have internal IT folks saying "NO!", but business requirements are going to trump that so we just want to supply the...

We have a few applications that will now allow external clients access to update their information.

Catalog table on the ReportServer db. You'll have to go based off of report name or ID to match up. I'm unsure if GUIDS transfer over.

A table needs data...I'd simply create a dummy dataset that returns some blank records.

There's only 1 true way to know! There are so many factors regarding "speed" that I would suggest trying something this large in your own test environment.

We replicate a table that has roughly 13 million records. However, we do transactional replication to 2 different subscribers. Works like a charm and doesn't take overly long. Of course...

Maybe post a couple rows of sample data w/ expected results.

When you're using Native deployment method you can go into properties and choose Report Definition "EDIT". That let's you save the RDL. I would think there is something similar within...

I have done things like this...probably not the best....also i'd suggest indexing that INT you've created...

IF @projectID = 0

set @projectID = NULL

select *

from tblProject

where projectID = IsNull(@projectID,...

I don't agree with the checking for 0. I've seen that regardless of that check, the report will analyze all values and still throw an error if you even check...

we have a table that holds login information and then the user's staffID which links them all over our data. So we send in something like DC0123 and find that...