Viewing 15 posts - 1,396 through 1,410 (of 2,452 total)
Luis Cazares (6/13/2014)
J Livingston SQL (6/13/2014)
http://www.sqlservercentral.com/articles/Tally+Table/72993/see code in resources at bottom of article
Just correcting the IFCode to make it easier.
thanks Luis > post corrected
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 13, 2014 at 9:50 am
http://www.sqlservercentral.com/articles/Tally+Table/72993/
see code in resources at bottom of article
edit> corrected IFCode shortcut
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 13, 2014 at 9:42 am
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 ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 13, 2014 at 9:35 am
can you post all the code you are running when you get the error
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 13, 2014 at 5:38 am
good to hear you have solved it.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 13, 2014 at 4:54 am
/*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
'$...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 13, 2014 at 4:27 am
which part are you struggling with?
care to share what you have done so far?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 13, 2014 at 4:22 am
vigneshkumart50 (6/13/2014)
I am really sorry, its money datatype.Preoverride, postoverride and shared dollar values will be like this $ 3, 456
still works as money.....did you try it in the code...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 13, 2014 at 4:06 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 13, 2014 at 3:32 am
ykonline (6/13/2014)
Hi Livingston ,Thx for ur quick response.
Can you help with out using UDF functions.
any reason why you don't wish to use the function
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 13, 2014 at 2:58 am
edit>misread the response 😉
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 13, 2014 at 2:56 am
what is the data type for Pre Override Cost, Shared Dollars?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 13, 2014 at 2:26 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 13, 2014 at 1:33 am
...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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 12, 2014 at 11:22 am
cbrammer1219 (6/12/2014)
For example....
3333 917899999 3210
3333 is the extension the call came...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 12, 2014 at 9:15 am
Viewing 15 posts - 1,396 through 1,410 (of 2,452 total)