Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Daytona00432

  1. Daytona00432

    Limiting values in a parameter

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

    Limiting values in a parameter

    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?
  3. Daytona00432

    Limiting values in a parameter

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

    Find All Record unchanged in last 4 updates

    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!
  5. Daytona00432

    Find All Record unchanged in last 4 updates

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

    Find All Record unchanged in last 4 updates

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

    Find All Record unchanged in last 4 updates

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

    Find All Record unchanged in last 4 updates

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

    Find All Record unchanged in last 4 updates

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

Part and Inventory Search

Back
Top