Recent content by Daytona00432

Once again you are the master! BTW - do you have any recommendations as far as textbooks or online resources? many of the links in the FAQ are invalid.

I'm afraid you will need to spell it out for me. Exactly how do I accomplish this? Do I create the query inside of SSRS or inside of my database?

I am new to SSRS and would like to know how to limit the values I am passing to a stored procedure. I am passing an Integer paramater and want the value to fall between 2 and 48. The integer determines how many rows are returned by my query and is not a field that exists in the table.

Ignore my last post. I found out that I needed to do all this as a stored procedure and not as a View. You are a life saver!

Looks like I partied a little too soon. I am seeing records that have changes in number of directories and/or number of files. Starting back from scratch I see I am also getting an error related to the INTO clause. Specifically, it is telling me that the INTO clause cannot be used in a VIEW...

Hello, RiverGuy, You were right! I am now seeing everything as I want but with one caveat. Can I prevent the view from showing me records that do not return at least 4 results? I am seeing some newer shares that have not existed long enough to have been scanned 4 times. And thank you for...

I'm getting a syntax error near the word ORDER. Here is my query: SELECT dbo.Hosts.ComputerName, dbo.CreationTime.ShareName, dbo.CreationTime.Date, dbo.CreationTime.NumberofDirectories, dbo.CreationTime.NumberofFiles, dbo.CreationTime.TotalScannedMBytes...

Yes. Every week a record is created for every share that exists.

I am trying to create a view into a table that contains weekly updates of scan of server file shares. I want to find those shares that are inactive and haven't changed in the last, say 4, updates. The fields are HostName, ShareName, Date, NumberofDirectories, NunmberOfFiles, TotalbytesScanned...