I thank you 😉

Not the first time I've won a prize for the shortest one....:cool:

ali.m.habib (10/10/2013)

---

I want to select top 1 value either null or value from this query

select top 1 column5 from table2 where table2.column1ID = 5

if the whole value of this...

What version of Reporting Services are you on? If it is 2012, you can use WITH RESULTSETS, if not, you might be able to use a dummy statement in the...

Well, there will be a transaction already in play when the trigger fires, which the trigger becomes part of/inherits (whatever your preferred language choice).

A trigger does not start a new...

When an error occurs in the trigger, the transaction is aborted so cannot be rolled back to the savepoint.

The trouble with this method is that the trigger is committing a...

Are you using a temporary table in the stored procedure?

What is not refreshing?

Is it the output column names OR the parameter names?

What is your "detail line" contained in ?

Is it a table?

Do you just have one row in the dataset?

Is it like this?

Select Parameter 1 ,then display:

Foo Foo ...

update t1

set ShouldBe=minrin

from @t1 t1

join (

select type,code,lot, min(RIN) minrin

from @t1

group by type,code,lot

) g

on g.type = t1.Type

and g.lot = t1.Lot

and g.code = t1.code

where t1.rin<>g.minrin

You are very welcome 🙂

I see your problem now - it is the tags in the XML ...

try this instead:

DECLARE @PDFFileName VARCHAR(8000) =

(

SELECT ( SELECT PDF_FileName + '.pdf< br/...

It's hard to help because we can't see the whole process as you can...

Can you try this to see if it works?(replace the profile and email address and fix the...

When you replace [[PDF_FileName]] does the rendered html have <br/> between each file name?

Can we see the final html (redacted)?

edit:

I see you have posted further ...

Get the html right and...

One thought I have is that you could store the required information in a database table along with a unique reference (e.g. a guid) then pass the unique reference back...

I can only think there was a problem with the way you tried?

Perhaps if you generate some sample html and post it here we can see what is wrong?