My bad, I used an empty string instead of the space in the first part. This should do it.

SELECT CASE WHEN CharIndex(Full_Drug_Name,' ') > 0 THEN Left(Full_Drug_Name,CharIndex(Full_Drug_Name,' ') -1) ELSE Full_Drug_Name...

This should do the trick.

SELECT CASE WHEN CharIndex(Full_Drug_Name,'') > 0 THEN Left(Full_Drug_Name,CharIndex(Full_Drug_Name,' ') -1) ELSE Full_Drug_Name END

Is there a reason you have the semi-colon after SET NOCOUNT ON? If not, remove that and give it a shot. If that doesn't work, tell us how many recordsets...

Before going down any other paths, or changing anything about your environment, change your url in the solution properties from http://localhost/reports to http://localhost/reportserver . You deploy to the...

"But anyway, try to avoid "SELECT ... INTO..."

This thing locks system tables (if you insert into local static tables) or whole tempdb (if you insert into #Table) or whole...

Can we get some more detail?

Are you trying to call the report through a report viewer, from a custom interface via SOAP calls, using the url, etc?

Have you tried running...

There are many ways of accomplishing it, but the easiest is probably to have a parameter for Pending, InReview, and Cleared, passing 0 for not checked or 1 for checked....

I'm not Ken, but since we both used the same method, I'll see if I can explain it to you from a high level. First, WHERE doesn't allow things like:...

That proc uses sysindexes to get its data. Have you updated statistics and then looked at the results?

Try it with xp_cmdshell and see what output you get. You should be able to parse it from there, but I can't test it at this time. You'll also want...

Not tested, and I was tempted to put a different case statement around the NEWREQDATE in your existing logic, but without knowing your reqs, it might or might...

Have you tried shelling out to nslookup and attempting to use that?

While I don't know enough about your data, you might be more concerned about performance issues than you need to be. A view spanning 20 databases really isn't that bad...

Depending on your particular needs, I'd probably recommend either a DTS package or bcp. Both can accomplish what you want.

1. Yes, although I'd recommend you use a stored procedure to join them all together, instead of having RS do that work. We have single reports that talk not only...