Viewing 15 posts - 16 through 30 (of 33 total)
Dear Sean
I am not new here, this is my friend's problem.I am bit curious.so considered all these i just posted...
December 3, 2013 at 9:54 am
Select Count(*) from
(
Select T1.Column1,T1.Column2,T1.Column3,T1.Column4,T1.Column5,T1.Column6
From Table1 T1 Inner join
(
Select T2.Column1 a,T2.Column2 b,Count(*) From Table1 T2
group by Column1,Column2
)dev
on dev.a=T1.Column1 and dev.b=T1.Column2
)ab
Hi Luis you are saying something like this.i tried this...
November 4, 2013 at 11:32 am
@chrism-2 thanks.yes really i am curious.....
September 10, 2013 at 10:19 pm
thanks grant frinchy. now i am reading the book sql-server-execution plans by you.extraordinary book for execution palns.
September 10, 2013 at 10:18 pm
Thanks for spending valuable time and suggestions......
August 22, 2013 at 10:10 pm
If it is Materialised then i thought it will defenetly increase the performance.
June 18, 2013 at 4:03 am
Thanks Gila Monster for the reply.But There is an exception with out searching which procedures are getting used
the table and what are the columns getting used is it possible...
June 18, 2013 at 3:54 am
With out using Sub Queries is it possible to get the required output
May 24, 2013 at 7:24 am
in sample data exept fileid 6 remaining all have the filetype with txt so my output will be like below
Fileid Filename FileType Count
----- ------- -------- -----
1 A ...
May 24, 2013 at 6:44 am
Thank you Dina
Your Explanation And presentation Makes Me Clear Of This Question.
And for a clarification tell Me The datatype Of...
April 18, 2013 at 5:11 am
Viewing 15 posts - 16 through 30 (of 33 total)