I fixed it...

IT matters the order you put the ROWS clause in. Switching to

BETWEEN 12 PRECEEDING AND CURRENT ROW

mad it work.

Must be the way it spools the...

Well, it seems to work when I use FOLLOWING.. but obviously that's not what I need 🙁

The column is a decimal(5,2) -- it is actually the target column.. it updates to its own value if the case statement is not capturing a change for that scenario.

I...

Hi, thanks for replying. I am getting a bit further. I have changed it to:

CAST((CAST(ISNULL(SU.Num, 0) AS Decimal(10,4))/CAST(o.Num AS Decimal(10,4)) * 100 )AS Decimal(5,2)...

Hi,

Thanks for all of your replies. I executed the code outside of a stored proc, replacing the input param with a known value. and managed to get the...

Hi

Thanks again. I took the print statement out, as it wasn't even getting that far.

I set no count too off, and see row counts for the inserts t the...

thanks for replying. I tried this, but it made no difference:

snip

--Execute SQL

EXEC (@W_SQL)

SET @W_NoOfBBMs = @W_NoOfBBMs - 1

END;

-- MERGE Routine to Update / Insert BBM_detail

MERGE BBM.BBM_Detail AS...

Hi,

wow, thanks for all the replies, I will work through them in my lunch hour. Yes, I cannot say how high each of the digits will go. It could...

Thank you so much, it works perfectly with single quotes!

I will have to read up about the difference between single and double quotes

Thanks to you both, once again 🙂

hi,

thanks for your quick reply. I did try this, but now I get another error with the Invoke-Expression:

Changed the command to :

$Command = ".\CheckJavaProcesses.ps1 -arg (,$ComputerArray)"

Error now is:

Invoke-Expression :...

Sorry for delay in replying.

I tried to use the transform data step, and although it parsed OK, when I ran it I got an invalid pointer error.

I rolled...

At the moment I have two tasks. The first runs two queries, and based on the results of those queries, it then executes another query in the next task, the...