Viewing 15 posts - 16,711 through 16,725 (of 59,067 total)
SQLBill (10/3/2016)
Lynn Pettis (10/3/2016)
What ever happened to basic problem solving skills?
Basic Problem Solving Skills checklist:
1. post issue on SQL Server Central without examples or all the details
2. if you don't...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 3, 2016 at 3:34 pm
The Dixie Flatline (10/3/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 3, 2016 at 3:31 pm
SQL Galaxy (9/27/2016)
Issues resolved by developer, he has changed and modified the existing whole query at application side. After that there is no glitch...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 2, 2016 at 4:28 pm
TomThomson (9/26/2016)
Jeff Moden (9/26/2016)
Steve Jones - SSC Editor (9/26/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 2, 2016 at 4:19 pm
The Dixie Flatline (9/30/2016)
Fortunately, I only need around 300, not thousands. 😀Thanks guys.
Just curious.... what are you doing that needs so many APPLYs?
--Jeff Moden
Change is inevitable... Change for the better is not.
October 2, 2016 at 4:04 pm
Sorry... I wasn't paying attention. This is a 6 year old thread and andrewd.smith did previously post code for the "Average Date" problem.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 30, 2016 at 9:16 pm
Evil Kraig F (11/2/2010)
If you really wanted a date average,...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 30, 2016 at 9:14 pm
alex_martinez (9/26/2016)
Jeff,By chance it's only about 10 - 20 rows per day to insert so that shouldn't be an issue. Thank you.
What are the ramifications if those 1-20 rows...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 26, 2016 at 1:27 pm
The Dixie Flatline (9/26/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 26, 2016 at 12:25 pm
Jeff Moden (9/23/2016)
h.tobisch (9/23/2016)
I do not like the wording. A column HAS a name and CONTAINS values.so, to my understanding,
'first pivoted column' should be 'first value of pivoted column'
Since...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 26, 2016 at 12:23 pm
SQL Galaxy (9/25/2016)
Pl. suggest me, How can escalate to application developer?
Ummm... ostensibly, you're the DBA on this system. You need to figure it out without having to rely on...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 26, 2016 at 12:15 pm
pcd_au (9/26/2016)
However my original question did (try to) restrict answers to data warehousing style applications.
Understood that from the beginning. A data warehouse application isn't much different than anything else...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 26, 2016 at 12:05 pm
Steve Jones - SSC Editor (9/26/2016)
jasona.work (9/26/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 26, 2016 at 11:56 am
Steve Jones - SSC Editor (9/26/2016)
Gary Varga (9/26/2016)
Steve Jones - SSC Editor (9/26/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 26, 2016 at 11:19 am
I can't speak for anyone else but here are my thoughts and a couple or personal observations on the subject.
On the original subject of "does it really matter", the answer...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 25, 2016 at 6:40 pm
Viewing 15 posts - 16,711 through 16,725 (of 59,067 total)