Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)

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

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

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

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

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