Check out TRIGGER_NESTLEVEL here : http://msdn.microsoft.com/en-us/library/ms182737(v=sql.105).aspx

you can put something like this in your trigger to stop it firing itself.

if TRIGGER_NESTLEVEL()>1

RETURN;

I know this may seem stupid, but can't you just use the create function statement?

If it already exists it will not touch the function and if it doesn't exist it...

The other way is to use the CountDistinct aggregate function in the total field of your report...

Like this, which counts "A"s...

=CountDistinct(Iif(LEFT(Fields!Column1.Value,1)="A","A",""))

You just need to make it into a singleton query by plopping some brackets round the selector...

select a.b.value('(PID[sql:variable("@LoopCount")]/PID.3)[1]', 'varchar(200)') as tehvalue2

from @XMLDoc.nodes('HL7Message') as a(b)

...but why are you using a...

Hi Phil,

This has been playing on my mind as I know it will be an issue for me at some point...so I tried it and could not get the error...

Ah right, sorry - I hadn't realised that didn't work any more in 2012, and you hadn't mentioned trying that technique...:-)

I don't have any other suggestions, sorry.

If I understand what you are seeing correctly, I think that adding a dummy select with the correct structure cures it.

e.g you have a stored proc that returns a result...

Question: Why are you all converting to varchar(8) to compare dates? Seems like a waste as even with the time in there, today is still today isn't it?

your original error may be due to SQL server attempting to enlist a distributed transaction and MySQL cannot take part in that transaction.

This would be because you are attempting to...

Your subquery is returning a money type - averagerate, but you are then using that as a lookup for a currency code, which is presumably a char type...this makes no...

First, let me say that your trigger will cause you problems as it does not cater for multiple row updates, this is something you should look into changing as soon...

You could try this, it produces the right output for me...

create function [dbo].[Code128Barcode](@input varchar(3997), @table char(1) = 'B')

returns table

with schemabinding

as

--=======================================================================--

--== Function to build the required data string for a code...

Your standard deployment...

How about this

select min(ID) ID,

Employee,

Job,

min(StartDate),

max(EndDate),

Workload

from #Something

where Job<>'Vacation'

group by Employee,

Job,

Workload

union all

select ID,

Employee,

Job,

StartDate,

EndDate,

Workload

from #Something

where Job='Vacation'

order by ID

My next question was going to be if...