Well at least I know that I haven't completely lost my mind. Do you know of a way for all those query...

Sorry! Meant to post this in the T-SQL forum!

That worked perfectly! I always forget about CTEs.

Thanks!!!!

Thank you so much! That worked perfectly!!!!

I'm afraid so. I can do a dir command and verify that...

Donalith (8/8/2012)

---

It may not be a length issue at all. Have you checked that the design of the report doesn't exceed your normal page width? A little wide can produce...

anthony.green (8/8/2012)

---

You can find the RSClientPrint........cab file in the SSRS installation location.

Something like C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin

Where you should find RSClientPrint-ia64.cab, RSClientPrint-x64.cab and RSClientPrint-x86.cab

Then you should be able to...

anthony.green (8/8/2012)

---

You can find the RSClientPrint........cab file in the SSRS installation location.

Something like C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin

Where you should find RSClientPrint-ia64.cab, RSClientPrint-x64.cab and RSClientPrint-x86.cab

Then you should be able to...

You sir are awesome!!!! Thank you so much! That's exactly what I've been looking for.

anthony.green (8/8/2012)

---

Could you not use something like group policy to install the client at logon time to the machine if its not already installed?

Do you not have any remote software...

I tried this:

SELECT *

INTO #tmpxml

FROM OPENROWSET(

BULK 'http://ww2.tdot.state.tn.us/tsw/GeoRSS/TDOTConstructionGeorss.xml',

SINGLE_BLOB) AS x

But that didn't seem to work.

Nevermind, I got it. Somebody else had the view open, so once they closed it out, everything worked fine.

Thanks,

Jordon

Thanks for the reply. I've tried scripting it and after 20 minutes of waiting, I stoped it. So, I created a new view and called it the same...

murali.jillellamudi 85871 (6/13/2011)

---

Hi Jordan ,

Even I am having the same issue , I am getting this error on SQL SERVER 2008 R2 . I have looked into the fix...

drew.allen (5/6/2011)

---

It's actually very simple, but if you have any records that are missing a comma, you will get an index out of range error message. You can fix...