I wouldn't call myself a musician, but I play Bass Guitar. Contemporary Christian and Christian Rock mainly.

Please don't put in duplicate posts as folks will waste their time looking at both.

Original post here: http://www.sqlservercentral.com/Forums/Topic548775-149-1.aspx

Jason,

If you post the entire stored procedure I'm sure we can give you some help. As you said it is probably something simple. My signature line used to...

No problem. Glad I could help.

antonio.collins (8/7/2008)

---

i use declare in all of my SSRS 2005 reports so it definitely can be used. have you defined any of the declared variables as report parameters?...

The Joins should work fine as long as you have proper indexes on them and in the design I have suggested they are all part of a clustered index. ...

It's actually quite simple. Go to report parameters and add a parameter called Toggled that will be a boolean and Hidden. Set the default to TRUE (the thing...

I'm not positive that I understand what you are asking, but I would do a design with 3 tables Ads, WebSites, and Ad_WebSites like this:

[font="Courier New"]CREATE TABLE Ads

   (

  ...

This is by design. When you save as PDF, it shows what's on the screen so when you directly go to PDF, etc. you need to have everything expanded...

As I said in my last post. Run a Trace against the server to make sure the application is actually doing the insert. If the insert was failing...

SQL Server does not do any ordering by default. If you have a clustered index on the table then usually the data will be returned in the order of...

If TodaysCount Cint((YesterdaysCount) * 1.05) Then

Success

Else

Failure

EndIf

If you want this EXACT set of sql statements to generate a report for you will need to encapsulate it in a stored procedure.

Parameters in SSRS are defined in the...

Actually Lynn has it right. You can't directly convert the lastlogon to bigint because it is larger than bigint, so you need to convert lastlogon to a larger decimal...

If you need to pass parameters into the temporary procedure you just add those parameters to @Params and add the parameter the @sql being called and to the parameters added...