Viewing 15 posts - 436 through 450 (of 2,452 total)
Nomvula (8/23/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 23, 2016 at 5:04 am
Nomvula (8/23/2016)
my question is now, I technically I don't have ROWId in my table, I've it there In the example so I can distinguish easily...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 23, 2016 at 4:36 am
shagil.a.gopinath (8/23/2016)
According to given scenario I have time till end of June, % should be calculated by considering the scheduled date, Completed Date. In the row number...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 23, 2016 at 2:10 am
shagil.a.gopinath (8/23/2016)
I would like to find out the percentage for the delay only, I have the ScheduledDate and if do the activity on or before then i can say...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 23, 2016 at 1:39 am
shot in the dark......whilst you have posted sample data it is not easily reproducable in SSMS......did you read the link I provided ? (eg CREATE TABLE / INSERT DATA...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 22, 2016 at 11:44 am
ok...I think I understand what you want, but your description of the problem comapred to the limited sample data and expected results doesnt clarify it for me.
suggest you post some...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 19, 2016 at 12:25 pm
gjoye (8/19/2016)
SALES REP -- COMPANY -- TRANSACTION DATE -- PYEAR -- PMONTH -- Number Of Employees
Allen...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 19, 2016 at 10:57 am
what version of MS SQL are you using?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 19, 2016 at 9:42 am
james.stanich (8/18/2016)
I would need the pivot to handle dynamic dates, but no more than 7 since the display is for weekly...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 18, 2016 at 11:33 am
james.stanich (8/18/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 18, 2016 at 11:15 am
suggest you post the create table script and insert data scripts for your sample data please.
thanks
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 18, 2016 at 9:39 am
jssashank (8/16/2016)
J Livingston SQL (8/16/2016)
jssashank (8/16/2016)
J Livingston SQL (8/16/2016)
jssashank (8/16/2016)
J Livingston SQL (8/16/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 16, 2016 at 1:05 pm
jssashank (8/16/2016)
J Livingston SQL (8/16/2016)
jssashank (8/16/2016)
J Livingston SQL (8/16/2016)
can I please ask you to explain why you wish to exclude rows where the first row is a debit?
Sure. My intention...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 16, 2016 at 12:26 pm
jssashank (8/16/2016)
J Livingston SQL (8/16/2016)
can I please ask you to explain why you wish to exclude rows where the first row is a debit?
Sure. My intention for adding that is...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 16, 2016 at 11:37 am
can I please ask you to explain why you wish to exclude rows where the first row is a debit?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 16, 2016 at 9:40 am
Viewing 15 posts - 436 through 450 (of 2,452 total)