vnguyen (10/21/2008)

---

Thanks for the reply but I couldn't run it in 2005 either... I tried the new one you sent and it works like a charm...

Anyways to answer the last...

Have a look at this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3457121&SiteID=1

And by the way msvcr80.dll is the MS C runtime library, nothing to do with .NET

See the examples here:

http://msdn.microsoft.com/en-us/library/ms190307.aspx

By the way, Gila Monster is female !!!

Or alternatively this:

select IsLeapYear = case when day(dateadd(day,-1,dateadd(month,2,dateadd(year,@year-1900,0)))) = 29 then 1 else 0 end

Which basically calculates the day before March 1st.

I think this is what you need however without further info I cannot be sure:

SELECT

*

FROM

...

Try running this against your ReportServer database:

SELECT

c.path,

r.rolename,

u.username

FROM

catalog c

JOIN

policyuserrole p on p.policyid = c.policyid

JOIN

users u on p.userid =...

The correct way to format a date is:

i. Ensure your report language is correct, when a new report is created the language is set to English(United States) change it to...

I think in the original script the trailing comma was trimmed off after.

Doesn't need to use a cursor, it can be replaced by:

SELECT @InsertQuery = @InsertQuery + column_name + ',' from ##Temp_Generate

Hope Jeff M doesn't see this 😉

I don't think this has anything to do with RTRIM, you just need to change the way the results are displayed in Query Analyser. Go to the Tools menu, select...

Sarah,

Yes there is a way to get the RDL from a deployed report, as follows:

      - Select the report in Report Manager

      - Open the properties tab

      - Click...

Looking at the sp_MSfor... procedures there seems to be a limit on the number of placholders ('?'s) you can use in the command string of 9. It looks like you...

You may have mistyped the line where you are setting the sendusing parameter. I don't think you should have the .asp at the end of the http://schemas.microsoft.com/....../sendusing.asp...

According to these, EU (including the UK) summertime begins on 25th March

http://wwp.greenwichmeantime.com/info/bst.htm

http://wwp.britishsummertime.co.uk/