Viewing 15 posts - 16 through 30 (of 2,452 total)
If you're fancying a change of pace the Slack community is forever increasing (https://aka.ms/sqlslack) although that is also again not without its limitations, as there's over 16k people in...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 25, 2021 at 2:56 pm
So, my personal and heartfelt request as a member of "the community that was", I'd love it if you and JLS (another recent revisitor) and a host of others that...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 24, 2021 at 8:18 pm
JCelko
Thanks for your reply....but your coded response does not meet my expected results (which I posted)
Other posters have resolved the problem for me.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 24, 2021 at 6:00 pm
Thanks Homebrew....
it was the "trick" CASE WHEN LAG(t_type) OVER(PARTITION BY t_id ORDER BY t_date) = t_type THEN 0 ELSE 1 END AS IsStart that Mark used was the bit I...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 24, 2021 at 1:42 pm
Thanks Mark
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 24, 2021 at 7:12 am
I am getting really annoyed with this "link to the post takes me to the second last page of the thread, not the actual post" issue.
yup .......
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 23, 2021 at 10:30 am
Never knew about that Jeff......thanks muchly
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 23, 2021 at 9:42 am
I am getting really annoyed with this "link to the post takes me to the second last page of the thread, not the actual post" issue.
yup .... and the...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 21, 2021 at 3:18 pm
maybe this will help?
if you paste code into https://www.dpriver.com/pp/sqlformat.htm (Instant SQL Formatter) by default it breaks the brackets out so it is easy to follow...other formaters are available <grin>
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 21, 2021 at 2:07 pm
Was this the info you where looking for?
Thanks.
Please provide details of your expected answer based on the demo data provided.....prevents any confusion on my part <grin>
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 17, 2021 at 1:42 pm
Hi...just wondering why you would want to create a table with just one row from these results?
Also....what do you want to record when the postcode column is just an empty...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 10, 2021 at 3:31 pm
Well, after a 3 year absence I decided to take another look at SSC........Nice to see a lot of the names I remember still posting.
Am no longer earning with SQL,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 9, 2021 at 5:11 pm
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 20, 2018 at 8:59 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 20, 2018 at 8:05 am
maybe read this https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum
and repost....?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 9, 2018 at 2:36 pm
Viewing 15 posts - 16 through 30 (of 2,452 total)