thanks Luis > post corrected

http://www.sqlservercentral.com/articles/Tally+Table/72993/

see code in resources at bottom of article

edit> corrected IFCode shortcut

just had the same issue.....had to get respond to an email...which errored out when reconnecting to SSC...but after a few minutes it seemed to sort itself out ...

can you post all the code you are running when you get the error

good to hear you have solved it.

/*this works*/

DECLARE @poc1 AS money

DECLARE @poc2 AS money

DECLARE @sd AS money

/*this doesnt*/

--DECLARE @poc1 AS nvarchar(18)

--DECLARE @poc2 AS nvarchar(18)

--DECLARE @sd AS nvarchar(18)

SET @poc1 = 123.456789

SET @poc2 = 113.444

SET @sd = 99.533

SELECT

'$...

which part are you struggling with?

care to share what you have done so far?

still works as money.....did you try it in the code...

hmmmm...works ok for me

DECLARE @poc AS numeric(18,8)

DECLARE @sd AS numeric(18,8)

SET @poc = 123.456789

SET @sd = 99.533

SELECT

'$ '+ REVERSE(SUBSTRING(REVERSE(CONVERT(varchar,(CAST(round(isnull(sum(@poc),0),0) as money) + 1 -

cast(round(isnull(sum(@sd),0),0)as money)),1)),4,255)) as [PreOverride L2],

'$ '+ REVERSE(SUBSTRING(REVERSE(CONVERT(varchar,(CAST(round(isnull(sum(@poc),0),0) as...

any reason why you don't wish to use the function

edit>misread the response 😉

what is the data type for Pre Override Cost, Shared Dollars?

based on the article Eirikur pointed you to...

SELECT MAX( CASE WHEN ItemNumber = 1 THEN Item END) custid

,MAX( CASE WHEN ItemNumber = 2 THEN Item...

...sorry bin gone for a while on this thread............and a lot of follow up posts

have you / can you provide sample data for this table:

CREATE TABLE [dbo].[MitelCallTrace](

[calldata] [varchar](400) NULL

) ON...

cbrammer1219 (6/12/2014)

---

These are phone numbers, and I am using them to determine if it is a inbound call or outbound,

For example....

3333 917899999 3210

3333 is the extension the call came...