131 reputation
11
bio website desperadomar.blogspot.in
location Njarackal, India
age 23
visits member for 11 months
seen Jun 16 at 5:53
stats profile views 28

Starting a career in dba and also a maths physics enthusiast ,fan of mir publications in russia and a passion to develop wonderful websites


Feb
4
awarded  Informed
Feb
2
comment Dissecting Joins
It really helped and thanks a lot. I just confused when joins got added more ,you gave me a crystal clear idea of the working of this query. thanks again
Feb
2
accepted Dissecting Joins
Feb
2
revised Dissecting Joins
added an sample data
Feb
2
comment Dissecting Joins
link to drawing please share your thoughts in this drawing
Feb
2
comment Dissecting Joins
do you know any common platform to show my thoughts in a diagram. I am trying to create a table and join each conditions , if you know any websites I can show what's in my mind
Feb
2
revised Dissecting Joins
added 531 characters in body
Feb
2
comment Dissecting Joins
kk I will add it andriy
Feb
2
revised Dissecting Joins
added 30 characters in body
Feb
2
comment Dissecting Joins
well edited the question ,you can find the query on the link given as question
Feb
2
asked Dissecting Joins
Jan
30
comment How to link each column in sql?
can you do me a help, the query above is great but I looked inside it but I didn't got the inside working of it. can you please suggest some wise advice to me (for building the basics ,some web tutorials will be fine) to solve the problems arising in hierarchy
Jan
30
accepted How to link each column in sql?
Jan
30
comment How to link each column in sql?
that's fantastic. a very good implementation without CTE. I really loved it. I thought it won't be possible to create a hierarchy without using CTE again thanks chris
Jan
28
comment How to link each column in sql?
I think I am looking for recursive cte +1 for that
Jan
28
asked How to link each column in sql?
Jan
17
comment SQL Server BPA 2008R2
This is for windows 2012 any Idea of running it in SQL server 2008r2
Jan
17
comment SQL Server BPA 2008R2
let me check this and have test run on my test machine if it works fine I will reply
Jan
12
asked SQL Server BPA 2008R2
Dec
3
comment Many To Many Relationships
take a look at this wiki. It will help you to understand basics