Recent content by arrowhouse

I am trying to replace a process that outputs to a text file using osql. The requirement that I have been given is that the text file must exactly match the format & content of the file that osql produces. An example osql command that is used to generate the file is osql -h-1 -w 1100 -s "^" /E...

Hi Geoff, Thanks for being so helpful. Yes I have something I can determine logically. So your suggestion works fine & simplifies the report. I hadn't discovered the conditional formating expression. Magic. Kind regards Liz

Thanks Geoff, I am going for the 2 matrix report only because I want to show one half of the values in the columns N4 and the others as N2. I couldn't find a way to to do that (perhaps I asked the wrong question) - so i thought maybe separate matrix, but alligned would work. It is a fairly...

I'm newbie to Reporting Server. I have 2 Matrix report items on my report, side by side horizontally. I know that these will always have the same number of rows & I want to make the rows across these two items line up. In the design window they do because they are snapped to the grid & you...

Lets see should I be getting that $2.99 a min.... I think what you are saying is that you were expecting one row back from your union for day 27 but you are getting two. But union just joins together 2 result sets (removing results that are duplicated between the 2 result sets unless you...

Sorry (should read more carefully). I get it - you are trying to select from the table name you have put into variable and SLQDenis is right.

In which case you declare becomes DECLARE cur3011 CURSOR LOCAL FAST_FORWARD FOR SELECT @cMonth but that means you just get one value and I'm not sure why you would be cursoring in that case.

How is your variable @cMonth declared? is it a table variable?

You have declared the input parameter as @quiz VARCHAR( 25 ) when creating the procedure as opposed to @xquiz. I think that is why when you use @xquiz you get a not declared error.

If you are using 2005 take a look at the rank function in books online. I've never used it myself but something like: RANK() OVER (PARTITION BY E.RecName, H.RecKey order by L.TimeStamp(desc)) as RANK looks like it might do the trick. depending on how you want to treat equally ranked ones you...

I have seen this done in the following manner: Save script(s) you have created as .sql file(s) in a particular directory. Then write a batch file to call each of the scripts sat in your selected directory for each of the servers/databases using osql. The output of each query was stored in a...

I do like SQLDenis' suggestion of using the rowcount rather than cursoring. And fredericofonseca has made a sensible suggestion of adding in the transactional control, which I think should help. I would prefer to use a higher rowcount, but you will probably need to experiment a bit to find the...

Digging back in to my memory when I was dealing with a database will such a big table, it is often the size of tempdb, the logfile expanding or lots of indexes on the table that can slow things down. Are there any indexes using the column that you are updating on dcd? If so I'd drop it &...

You need servername.databasename.owner.table you are missing out the owner bit. Have never tried the IP address so I'm not sure how sql will handle that. If it still doesn't work can you post the error? I presume the setting up of the linked/remote servers has already been done. If not you...

Can you just check your value of @code? If you are still using your exsits statement can you check that it is set to 101 as per your IF EXISTS statement? Have had a re-read of the statement I posted & can't see anything out, but its always easier to see issues with other peoples code...