Viewing 15 posts - 2,191 through 2,205 (of 2,452 total)
pathuripr (9/18/2011)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 18, 2011 at 8:58 am
suggestion...read up on GROUP BY / SUM et al
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 17, 2011 at 2:02 pm
Hello
you have asked a sensible question....you have been asked to provide suitable scripts that willl assist someone on here to hopefully provide a solution to your pronlem.
At the moment only...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 17, 2011 at 11:04 am
to help us help you...please post table creation / insert data /query scripts that will provide a representative sample of the data...based on the sample dat you provide, please provide...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 17, 2011 at 10:20 am
deleted....think I may have misunderstood your requirements :ermm:
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 17, 2011 at 9:02 am
Hi simflex
to help us help you...please post table creation / insert data scripts that will provide a representative sample of the data...and allow us to use the query you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 17, 2011 at 8:58 am
😀
good luck.....post back if you get problems
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 16, 2011 at 12:17 pm
SQL_Surfer (9/16/2011)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 16, 2011 at 10:45 am
Jason
now you are spoon feeding .....:-P:-P:-P:-P
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 16, 2011 at 10:27 am
not sure why you are using SSIS...a TSQL possible solution below.
have a play around with this code.....seems therre are several posts recently relating to "fruit"....are you all on the same...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 16, 2011 at 10:14 am
NJ-DBA (9/15/2011)
The answer is 42.
So Long, and Thanks for All the Fish
...sorry 😀
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 15, 2011 at 3:45 pm
zaleeu (9/12/2011)
Hi ,Yes, that is exactly what I was trying to achieve.
Thank you so much !
----------------------------------------
ok...so we now have some clarifcation on what you require.
Given this table of results, what...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 12, 2011 at 10:14 am
zaleeu (9/12/2011)
Ignore the | characters , that was just to seperate the data.
So, I need it to be
Paul Oranges ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 12, 2011 at 9:28 am
Hi Zaleeu
But I am still looking for an output like below.
Peter| Apples | Plums ( No NULL Value inbetween )
can you please clarify....do the results have to be in separate...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 12, 2011 at 7:34 am
many thanks for clarification....
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 12, 2011 at 4:59 am
Viewing 15 posts - 2,191 through 2,205 (of 2,452 total)