Viewing 15 posts - 1,471 through 1,485 (of 2,452 total)
I find it far easier to understand if I have something to work with...
here is a very simple set up....based on these values...what do you expect from your query?
USE [tempdb]
GO
CREATE...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 2, 2014 at 9:48 am
vigneshkumart50 (5/2/2014)
I am using this below query to sum my column values.
Query:
select
'$ ' + REPLACE( CONVERT(VARCHAR(32),cast(round(isnull(sum([Share_Invest]),0),0)as MONEY),1), '.00', '') [Investment],
'$ ' + REPLACE( CONVERT(VARCHAR(32),cast(round(isnull(sum([Profit_Share]),0),0)as...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 2, 2014 at 8:48 am
Informer30 (4/28/2014)
thanks for reply, please let me know what further information is required...
I have a select statement that I need to run 15 times with a different where clause...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 28, 2014 at 11:04 am
itortu (4/28/2014)
example
--------------
order quantity
40000
--------------
1st...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 28, 2014 at 10:02 am
itortu (4/28/2014)
The code that you gave me (the link) worked. After that I needed to add one more cte I think.
And adjustment to catch orders like
S20026, the order...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 28, 2014 at 8:23 am
ben.brugman (4/28/2014)
Thanks for your contributions and sorry for not responding.
This weekend I had a fall and have a head injuri. In a few days time everything should be...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 28, 2014 at 7:42 am
itortu (4/27/2014)
I know I went back and forth with this question several times, but it would be really great if you would help me a last time because I...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 27, 2014 at 3:07 pm
well...I didn't know this was called a Lorenz Curve...and neither have I done this in SQL before.
but saw this "simple" explanation http://courses.washington.edu/geog326/Lorenz.pdf in how to do it in Excel.
so...thought I...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 27, 2014 at 9:01 am
is this what you are trying to achieve?
SELECT dbid
INTO #dbcheck
FROM sys.sysdatabases
WHERE dbid > 4
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 26, 2014 at 1:47 am
itortu (4/24/2014)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 24, 2014 at 12:53 pm
itortu (4/24/2014)
I have a question about something I noticed, and this is probably a communication flaw of mine.
Using the data...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 24, 2014 at 11:02 am
itortu (4/23/2014)
i am getting nowhere :/whenever you have time, i would appreciate any help.
thank you
here you go...this works for your sample data....probably a more eloquent solution could be written,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 24, 2014 at 2:13 am
probably be easier if you can supply some table create scripts / sample data and the results you would expect based on the sample data provided.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 23, 2014 at 8:10 am
itortu (4/23/2014)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 23, 2014 at 8:00 am
itortu (4/22/2014)
Your query works very well for what I need it to do.
I am not approaching to our NAV vendor because I...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 22, 2014 at 1:50 pm
Viewing 15 posts - 1,471 through 1,485 (of 2,452 total)