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!

Search results for query: *

  • Users: dhulbert
  • Content: Threads
  • Order by date
  1. dhulbert

    SSRS Parameters, 1 Select multiple values

    I'm trying ot get SSRS to populate a number of parameters from a single drop down select box I currently have a single drop down list generated from a query that allows a user to select a specific report and it popultes the parameter @Report_ID. I want this select to populate a number of...
  2. dhulbert

    Multi Page Graph

    We have a standard bar chart whcih sits on a single A$ Landscape sheet of paper when it is printed. Problem is the end user can select a large number of items which run along the x-axis, this obviously causes problems whrh you come to display/print it. Is there a way to say when the user...
  3. dhulbert

    Index or Partition

    I have a few tables of over 50 Million rows which obviously take a while to query. From a performance point of view will a query run faster on a table that it partitioned of indexed. For instance Financial year is a regular report variable would I be better with an index on FinYear or a table...
  4. dhulbert

    Check Multiple Columns for Multiple values

    I need to check 20 columns in th esame table for any 1 of 15 differnet codes. I can obviously do it with a very messy nested casae statement but can anyone think of a neater/more efficient version? Cheers I love deadlines. I like the whooshing sound they make as they fly by Douglas Adams...
  5. dhulbert

    Look Up Tables

    I currently have a large number of lookups, some are being done within scripts as case statements and some using lookup tables. I'm thinking about changeing them all to use a lookup table to make the maintenance easier etc but just a quick question. Is it better to use a seperate table for...
  6. dhulbert

    Order By Questin

    If I have a number of records returned from a query, and the resut set has an order by clause, what happens when 2 or more rows meet the same criteria for example ColA Colb ColC A 1 Z B 1 Y C 2 X C 2 W If I Order By ColA, ColB then which way round would the 2 C rows...
  7. dhulbert

    SSRS 2000 Drill Through Reports

    I have a large number of reports (30+) each of which need to have a dril throuhg to the same report. 1 Can I drill through to a report not in the same directory as the existing report? 2 If not how can I copy a report to multiple folders on a Reporting Serivces portal or do I have to publish the...
  8. dhulbert

    Split and Re-name PDF File

    I have a PDF file with some 200+ pages. Each page is a form with a users e-mail address on it. I can split the pdf into 200_ individual pages using extract pages but I want to rename each file using the e-mail address form withing the PDF, any ideas on how I can do this I'm happy enough using...
  9. dhulbert

    Splitting a list to use in a join

    I have 2 tables 1 contains a field for job priority, the other contans a list of valid priorities. All I need to do is use the list in table 2 as part of the select from table1 Table1 priority contains a b c c d e Table2 prioritylist contains a,b,d select * from table1 where priority in...
  10. dhulbert

    SSRS 2000 Parameters

    I have a paremeter called contractid set up with a fixed value of R00031A this gets used in a dataset using WHERE contract id in (@Contractid) I now need to pass 2 values so R00031A, R00031B to the same dataset so the equivalent of Where contractid in ('R00031A', 'R00031B') everytime I try...
  11. dhulbert

    Syntax Probelem

    I'm sure this should work, just can't get the syntax right. I want to join 2 tables and depending on a flag in 1 of the tables vary the data that gets selected in the result, so if the select flag is set to 1 then only select where the appointment flag is 1 when the select flag is set to 0...
  12. dhulbert

    Insert data via a case statement

    I'm trying to insert a line of data into a table dependant on the result of a case statement. So look at the table 'Data_Table' if there is a row where the date = 'Run Date' then do nothing Else insert a row of data with 'Run Date', 'Header' and 'Colour' Any help would be appreciated. I...
  13. dhulbert

    Strange Join Type

    I'm looking at a script writen bu someone who isn't around anymore and I have a found something in it I haven't come across before. In the sample script below the subselect c is joined in a way I've never used. I'm looking for some advice/opinion as to what sort of join it defaults to when...
  14. dhulbert

    Auditing users

    I have just found a random backup file on my server created around 1 hour ago and I have no idea who has been runing backup jobs. Is there anyway to se who has recently run a backup. It wasn't run through the SQL agent as I've checked the history in there and no times match up so it must have...
  15. dhulbert

    Directory Limits

    Possibly a silly question but.... Is there a limit on the size of a directory tree, either in the total disk space within th etree ot th enumber of items in a single directory? I love deadlines. I like the whooshing sound they make as they fly by Douglas Adams (1952-2001)
  16. dhulbert

    Combine Rows as a single column

    I have data in a table as shown below. I want ot combine all of the activity codes into a single column possible comma seperated So Session Activity 1 a1 1 a2 1 b1 2 a2 2 b1 Becomes Session Activity 1 a1, a2, b1 2 a2, b1 I had a look at Pivot but...
  17. dhulbert

    Delete old back up files from SQL command

    My backup routine creates a new backup file each day and adds all the incremental backups to that file. Then next day new file etc, It's all very tidy and easy to administer but I want to delete the old files automatically from the same SQL script. How do I delete files on a disk where they are...
  18. dhulbert

    Access 2003 - 2010 control problems

    I have a databse created in access 2003 which has a numebr of forms that contain calendar controls, when you click on the control the error message "Run time Error 2683 there is no object in this control" is reported If I debug the code behind the control is Private Sub cmdCalFrom_Click()...
  19. dhulbert

    Backup issues

    BACKUP DATABASE [LIVE] TO DISK = N'E:\Backup\Live_Backups\Live_Backup.bak' WITH NOFORMAT, NOINIT, NAME = N'LIVE-Full Backup', SKIP, NOREWIND, RETAINDAYS = 3, NOUNLOAD, STATS = 10 I'm running the command above to create my nightly full backup, but rather than keeping the last 3 backups...
  20. dhulbert

    Replication to a Reporting Server

    I'm trying to set up a second server as a reporting server to keep the load (and the users) off my Live Production system. I know I can restore the nightly backup to the report box but I want something a little more regular than that so I can keep the reporting box as up to date as possible...

Part and Inventory Search

Back
Top