Viewing 15 posts - 9,601 through 9,615 (of 9,630 total)
Why use openquery at all? You could just do:
@result = nombre
user_id = @login
March 3, 2004 at 2:35 pm
'Col1' as col_name,
I.col1 as new_val,
D.col1 as old_val
inserted I Join
deleted D On
I.primary_key = D.primary_key And
I.col1 <> D.col1
'Col2' as col_name,
March 3, 2004 at 2:29 pm
I have not deployed any RS rpeorts yet, but if you are using stored procedures as the source for your data and/or properly written and optimized sql code you should...
March 3, 2004 at 2:07 pm
There is a free tool called SQLCheck from Idera (http://www.idera.com/Products/SQLcheck/) that shows some key perfomance stats. Of course, since it is free it does not save the stats. They...
March 3, 2004 at 2:05 pm
In this instance you should not need to provide any locking hints as SQL Server will use the lock with the smallest granularity (likely Rowlock) in this instance.
March 3, 2004 at 1:57 pm
There is a DTS task in SQL2000 to transfer jobs. The source can be a SQL 7 server and you can select the specific jobs you want to transfer.
March 3, 2004 at 1:52 pm
There is definitely an impact on performance. The issue is where the query is actually run. I believe OPENQUERY runs the query on the remote server so the overhead is...
March 3, 2004 at 1:43 pm
It's hard ot say what the problem without seeing the report. I have a Matrix Report that i sugly in Excel because it has drill down, but all the data...
March 3, 2004 at 1:20 pm
I have not experienced any issues exporting to Excel. A couple of questions:
March 3, 2004 at 11:50 am
I would guess MS will not add an export to Word for the following reasons:
March 3, 2004 at 11:27 am
I have not done a lot with RS, but a couple of issues I have found are that as you say does not print and that the parameters cannot be...
March 3, 2004 at 11:21 am
I am currently experimenting with the Development Environment, but have found a book would be helpful in order to shorten the learning curve for things like drill-down and then there...
March 2, 2004 at 9:38 am
It was a poorly wordrd question becasue SERVERPROPERY is only supported in SQL2K (version 8 ). Thus when I tried it on my...
March 1, 2004 at 7:56 am
THanks for your answer, I had tried all of that. The answer was, that when the install was copied ot a network location it was corrupted. When I installed from...
February 26, 2004 at 7:23 am
Having just started working with RS, I don't know how much help I can be, but have you tried saving after the change and then going to the preview pane?
February 25, 2004 at 3:09 pm