Viewing 15 posts - 4,156 through 4,170 (of 5,504 total)
It's kind of a PIVOT but this scenario is also sometimes referred to as CrossTab.
To get the individual numbers grouped together it's better to use the PARTITON BY clause of...
February 27, 2010 at 11:25 am
lmu92 (2/27/2010)
table dbo.TempUserTags has three entries for TagId=1 (C Sharp). (ID 1,7, and 17)
Why do you expect C Sharp existence in...
February 27, 2010 at 9:39 am
@paul-2: Interesting approach!
Which one out of the three solutions would you actually use on the given scenario (extended volume)?
I'm not sure if the execution plan shows real figures on that...
February 27, 2010 at 8:46 am
jaspreetsingh8 (2/27/2010)
This relationship refers to one to many. Tag created by one user also used by other multiple users.Actually all this is like twitter tags functionality.
That doesn't answer my question.
I...
February 27, 2010 at 8:17 am
Divya Agrawal (2/26/2010)
I have written a post on DATEFIRT which can help you understand the usage of it..
I did refer to your article a few posts back.
But the subject Paul...
February 27, 2010 at 8:14 am
Paul White (2/27/2010)
Not as easy as using the WITH_XMLNAMESPACES clause though!Click that link to see how to specify a default XML namespace from T-SQL. It's easier.
Paul
... or look a...
February 27, 2010 at 8:11 am
Paul White (2/27/2010)
...Anyone interest in a FLWOR version?
🙂
Sure I am! It's "skills improvement" Saturday anyway! ;-):-D
February 27, 2010 at 7:23 am
Paul White (2/27/2010)
February 27, 2010 at 6:45 am
There seems to be something wrong in your sample data:
table dbo.TempUserTags has three entries for TagId=1 (C Sharp). (ID 1,7, and 17)
Why do you expect C Sharp existence in all...
February 27, 2010 at 6:31 am
Paul White (2/26/2010)
DanielP (2/26/2010)
... does the Table's Insert Trigger still fire or is it treated like bulk-insert?Yes.
LOL 😀
@daniel-2: to rephrase Pauls answer: it depends.
You need to be a little more...
February 27, 2010 at 5:25 am
And befor simply copy and paste the stuff from that link please read and follow the first link in my signature on how to post sample data.
Otherwise, you might get...
February 27, 2010 at 5:17 am
Your verbal description doesn't match your table structure:
USER2 :- A,B,C,D
vs. UserTags :- Id, TagId, UserId, TagType
Do you have the data available in a relational structure or are those values concatenated...
February 27, 2010 at 5:10 am
Ok, I see your point.
Didn't have to deal with those "special characters" in my concatenation scenarios (yet), so I wasn't aware of the side effects. Thanks for clarification. Learned something...
February 27, 2010 at 5:01 am
I added the ORDER BY statements to my solution to get the same output like you did and compared both execution plans.
Unless I'm overlooking something I'd prefer my solution over...
February 27, 2010 at 3:18 am
Unfortunately, we don't know how the final date value of your case statement has to look like...
Since you're getting rid of the time portion I'm guessing you're just looking for...
February 26, 2010 at 4:21 pm
Viewing 15 posts - 4,156 through 4,170 (of 5,504 total)