Viewing 15 posts - 32,266 through 32,280 (of 59,102 total)
Ok... with the understanding that I may not actually understand what you need, the following will do what I think you're saying using the test data you posted...
WITH
cteUnPvt AS
( --===...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 16, 2011 at 4:44 pm
Drew,
I'm really confused as to what you want to do. Your textual description says you want to "unpivot" the rows but your example is matching up quarter information based...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 16, 2011 at 4:03 pm
GilaMonster (10/15/2011)
Jeff Moden (10/15/2011)
Heh... nah... you're a good friend... so I thawed the chops for ya. 😛
And even de-boned and par-cooked em to be really nice.
That was just for the...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 16, 2011 at 1:23 pm
Here's my solution for the original problem. Keep in mind that I'm assuming from the original description of the problem that there are no more than three F2s for...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 16, 2011 at 1:05 pm
chandan_jha18 (10/15/2011)
GilaMonster (10/15/2011)
A temp table and 3 updates for what can be done in a single query? Not exactly the best option around for performance...
Hi Monster,
Are temp tables bad and...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 16, 2011 at 10:34 am
erhanduman (10/15/2011)
Hello;I have table;
These values are
F1F2
621apple
621orange
622banana
622grape
622strawberry
623apple
623plum
623melon
624apple
624strawberry
I want convert this table.
F1F2.2F2.2F2.3
621appleorange
622bananagrapestrawberry
623appleplummelon
624applestrawberry
I'm tried with join and pivot table methods. But I can't do it. Is there any suggestion
Thanks
Erhan
Erhan,
The reason why I...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 16, 2011 at 10:28 am
Performance Guard (Shehap) (10/15/2011)
If huge data entity for table1 , please let me know to guide more about the best performance options
That seems quite contrary to what you said after...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 16, 2011 at 10:10 am
Performance Guard (Shehap) (10/16/2011)
Jeff ,To clarify more ....Thinking of all performance terms is the best way to keep your production servers healthy all the time....
You're definitely preaching to the choir...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 16, 2011 at 10:05 am
Ninja's_RGR'us (10/15/2011)
Jeff Moden (10/15/2011)
Ninja's_RGR'us (10/14/2011)
Is [font="Arial Black"]that [/font]why you stopped being a manager and went back to "normal" DBA?Considering I covered several different topics in my post, is WHAT why?
Micro...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 15, 2011 at 10:47 pm
Just my personal opinion... I think that breakdown has already been accomplished and, for a team lead, the admin time for 3 DBA's seems about right to me especially since...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 15, 2011 at 10:35 pm
Aspet Golestanian Namagerdi (10/15/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 15, 2011 at 10:20 pm
Performace Guard (Shehap) (10/15/2011)
1.Create temp table commands are always better than declare temp table commands where temp clustered + non clustered index could be there as...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 15, 2011 at 10:16 pm
GilaMonster (10/15/2011)
Steve Jones - SSC Editor (10/15/2011)
Not enough of a detailed explanation according to Gail as she was trying to throw a shuriken, or rubber duck, or something at me.
I...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 15, 2011 at 10:04 pm
Steve Jones - SSC Editor (10/15/2011)
GilaMonster (10/15/2011)
Steve Jones - SSC Editor (10/15/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 15, 2011 at 9:53 pm
Steve Jones - SSC Editor (10/15/2011)
GilaMonster (10/15/2011)
Steve Jones - SSC Editor (10/15/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 15, 2011 at 9:47 pm
Viewing 15 posts - 32,266 through 32,280 (of 59,102 total)