Search results for query: *

Can anyone suggest a tool that can uses SSRS that I can give to my user community that supports the creating of sub-reports from the user interface? Report Builder from report manager does not support the creating of subreports. I have a hadful of users that would like to create subreports...

I'm working on writting a script to kill spids over 1 hour old that are in a sleeping status. The problem is the LastBatch column from sp_who2 is a varchar datatype. How can I convert this without losing the time? Here is my script so far. DECLARE @strSQL varchar(255) PRINT 'Killing Users'...

I want to order a query in asc order but I want the nulls to be last. in Oracle I can use (nulls last). How can I do that in T-SQL? - Paul - If at first you don't succeed, find out if the loser gets anything.

I have put together a query with the help of fuzzyocelot that will report permissions that users have access to in Reporting Services. I thought some of you may find this useful. SELECT DISTINCT CASE c.[Type] WHEN 5 THEN 'DataSource' WHEN 6 THEN 'Models'...

Is there anyway to report on the permissions each group has within reporting services? I would like to have a weekly report that would show what folders, models, and reports each domain group has access to from within report manager. I need an easy view that will show me all the permissions...

Does anyone know how to change the default save location in Report Manager? By default when you save a report it will save it in the models folder. obviously that's not good. I know there is an option to change it if you are using share point but we are not. - Paul - If at first you don't...

Does anyone know of any issue that Dot net 3.0 could cause with RS. This is the error that I am getting. Clients using dot net 2.0 don't get this error. - Paul - If at first you don't succeed, find out if the loser gets anything.

I'm having a problem with a varchar record in my database. There is an invalid character that is causing replication to a sql server to fail. I need to update the records at the Oracle db to strip out the bad character. Here is what the data looks like.(but between the I and l and the word...

Has anyone ever used the tablediff utility to compare an Oracle publisher with a SQL Subscriber? I can't get it to connect to the Oracle instance. - Paul - If at first you don't succeed, find out if the loser gets anything.

I have created a new FAQ on how to monitor you databases for DDL events. faq183-6696 - Paul - If at first you don't succeed, find out if the loser gets anything.

End of Support for SQL Server 2000 Service Pack 3a Support for SQL Server 2000 Service Pack 3a (SP3a) will end on July 10, 2007. Microsoft will end technical support on this date, which also includes security updates for this Service Pack. Microsoft is ending support for this product as part of...

We have finally decided to move to Reporting Services, So I've installed it and started writing some basic reports. However, I've run into a security problem. In order for anyone to see my reports at the URL, I have to add them to the local administrators group on the RS server. I have...

This we from SQL Server magazine 2006 December edition. I thought you guys might have a good laugh. - Paul - If at first you don't succeed, find out if the loser gets anything.

Hey guys, I have the following TSQL. DECLARE @docXML XML SET @docXML = (SELECT '1' AS account_level ,'FirstComp' AS account_number ,'' AS parent_account_number ,'FirstComp Insurance' AS account_name ,'' AS policy_number ,CONVERT(Varchar(1),'W') AS...

I have a table named SI_REPORT_INFO with a column named REPORT_PATH. That path is the unc path to the report. Currently the database looks like this. \\NEEASP\e:\eas\server\STDRPTS9.0\RPTS\NAME.RTP \\NEEASP\e:\eas\server\STDRPTS9.0\RPTS\ANOTHERNAME.RTP...

If anyone is interested I have put together a FAQ on Errors and Severity levels. FAQ962-6652: A Guide to SQL Severity and Error levels. - Paul - If at first you don't succeed, find out if the loser gets anything.

If anyone is interested I have put together a FAQ on Errors and Severity levels. faq962-6652 - Paul - If at first you don't succeed, find out if the loser gets anything.

I will preface my questions here by saying this is the first time I have had to work with XML files. I have the following query which I have been asked to have spit out an XML report nightly. What is that best way to accomplish this? I ran the query out put to a file to see what would happen...

Without running it. What do you think this will return.. -- Prepare sample data DECLARE @Dates TABLE (StartingDate DATETIME, EndingDate DATETIME) INSERT @Dates SELECT '20010101', '20070204' UNION ALL SELECT '20071231', '20080101' UNION ALL SELECT '20070318', '20080101' --...

I would rather write this statement without using dynamic sql. Shouldn't this case statement in the where clause work. declare @sql varchar(200) ,@where varchar(200) ,@val char(3) select @val = 'med' select @sql = 'select top 1 * from policy_insuredClaims_IC' if @val =...