i don't think you can write expression to hide or gray out the parameter.

CHECK THIS

SELECT CONVERT(DECIMAL(17,2),9)

congrats...!!

Thanks for share your experience with us.

you can use multi-select parameter in report but it will return you comma seperated value and you have to change the logic to handle the comma seperated value in the...

allow null value from the report parameter and add logic in the SP or TSQL like ......... WHERE (@DBNAME IS NULL OR DBNAME = @DBNAME)

this way if you passed the...

Try to find out SQLInjection and check how it work. It will help you to design the database to secure it's data from these injection.

1st option is the correct answer. there is a typo mistake in the option given for the question. I think it;s ok if you look properly the answer then you...

check this for automation

http://www.ruby-lang.org/en/

your question may lead confusion as you are usign third party tool to write the query. your TSQL include code inside the TSQL statement.

check the below code i make it generic based on appointment limit it will set the flag 'Y'

select ROW_NUMBER() OVER(ORDER BY doctor,apptcreatedate) AS ROW_ID,*

INTO #tempdr

from #temp1

DECLARE @Dr VARCHAR(10),

@Dr1...

execute this before executing the open rowset query.

EXEC sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

EXEC sp_configure 'Ad Hoc Distributed Queries', 1;

GO

RECONFIGURE;

GO

How can you consider MDX as TSQL. MDX and TSQL is totally different.

don't cry too much this is not your Board exam. Regarding the point moderator will check for the point.:-D. I can't modified the answer of this question and motive of...

check the chart padding space.

shared datasource is good option or you can define one internal parameter in the report and pass the server information to that parameter through your application.

in this way when you...