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...

I think the issue is that we are all thinking of a week being Sunday - Saturday and SQL Server in returning Week is considering a week being the first...

Here's what I'd do next (assumes you have primary key on the source table):

[font="Courier New"]CREATE TABLE logins

   (

   pk datatype,

   lastlogon bigint

   )

INSERT INTO logins

   SELECT TOP 50%

      ...