I have this project now to work on , have you manged to do it?

on the same website , someone has commented you can embed ajax codes to do it,

see at : https://msdn.microsoft.com/en-us/library/ff519562(v=sql.105).aspx

Alternative method to display HTML fields in reports

does it help...

Is there anything can be done at least modify the HTML data using SQL or an Expression from SSRS side so that the TEXT FORMAT for The highlighted phrase to...

Experts thank you all for responding quick and valuable inputs, it an eye opener.

we found a trigger which calls a procedure that uses a transaction , that caused the blocking.

Isolation...

that I know , please understand my question first:)

Servername\instanceName

if you look at the database server after you connect to GEBPC, you see GEBPC,

not GEBPC\GEBPC.

then I thought this is a...

I am connected to GEBPC

but @@servername shows

GEBPC\GEBPC

when I connect first time , I use GEBPC only for the windows authentication.

This works fine , thanks

If you get more than one ID, then you can just immediately return and let the queuing process take care of everything.

would you elaborate this more,

how can we immediatly return...

create table #abcx

(

deptname varchar(10),

doctorid int,

patient_name varchar(20)

)

insert into #abcx values ('ICU-1',10,'ABC')

insert into #abcx values ('ICU-2',10,'H.')

insert into #abcx values ('ICU-2',10,'ASLAM')

insert into #abcx values ('ICU-3',10,'HEENA')

insert into #abcx values ('KPM',10,'SURESH')

insert into #abcx values ('CCU',10,'MUKESH')

insert...

calling object if it has a temp table or another table variable must have the same exact structure to your table valued function that you are calling. also make sure...

a2.NumericValue check distinct values for this column,

you might have anything other than numeric values.

or add , and a2.NumericValue like '%[0-9]%'

like below.

Select top 1 a2.numericvalue

from dbo.ctc_mde_valueaudit a2

where a2.UTagId...

Jack , Would you direct me to a resource I can refer to or yourself may write a bit of code sample to that I can expand?

SQL Server Reporting Services security is managed on two levels: the SSRS site and on items within the site. At each level, the tasks that users can perform are managed...