Regardless, it looks as if you want to create a list of employees and their managers.

A simple direct way would be like this:

Select E.EmployeeName, (select EmployeeName from employee where employeeID...

Is this what you mean when you want to know how to execute the script?

create procedure test

as

begin

declare @script varchar(1000)

set @script = 'select getDate() as MyDate'

exec(@script)

end

May...

if the login that is running the script has rights to both db1 and db2, you could simply qualify the script fully like:

create table [db2].dbo.[<table name>] as .... select *...

The Authentication prompt you are getting is from Reporting Services. If you created a local user account or maybe you are using a domain user account, it really doesn't matter....

Quick question about your configuration. You have a server running IIS, SSRS, and MSSQL. Is the SSRS Catalog running from the local MSSQL or from another Server? I have attached...

Have you run the SSRS Configuration Manager? What does it tell you?

OK, If the example you showed was the report, abe the word "NULL" is visible on the report. In this case, you can use a change it based on a...

Why don't you simply filter the NULL values from your dataset? I guess we need to know how your dataset is populated. SQL Query or a Stored Procedure?:cool:

That is an interesting problem. From a basic level, you could validate the XML structure of the rdl or rdlc files. I am not aware of any APIs or emulators...

Yes that is true, where a Tablespace is a collection of database objects. M Most Oracle Database DBAs will set up a default Tablespace "USERS" this tablespace is usually the...

I agree with Paul. The Schema will act a a pseudo database, much like you experience in MSSQL. One thing that concerns me is your comment about the user adding...

To my knowledge you can not encrypt a password in the Web.config file. The question I have is why do you feel you need to? If the file is protected...

John's code is dead on, I was just pointing out that the substring of the first 10 characters would never provide the desired result or anything close to it.

😎

We are starting to replace crystal with SSRS, at least for new products. SSRS is very powerful in that the reports are located on a central server and can be...

You need to substring twice. First 10 like you have plus everything past the 'e', meaning the -005.

Then convert both...