Viewing 15 posts - 1 through 15 (of 38 total)
Thanks Jeff.
I was exactly looking for something like
The bottom line here is to make sure the data in the join columns is "right sized" for maximum efficiency.
.
Thanks for...
April 15, 2013 at 4:57 am
Mansfield (4/11/2013)
2. It depends. ...
April 14, 2013 at 1:31 am
Though I checked the following link, still I am not very clear about how it works.
http://msdn.microsoft.com/en-us/library/cc966529.aspx
Any ideas where to get more info?
April 10, 2013 at 2:01 am
Great, thats is probably the best solution where in we can limit the number of records as that of source table and get the desired result. Thanks Eugene.
I guess this...
May 29, 2012 at 4:41 am
Eugene Elutin (5/29/2012)
the one with minimum id where any of the names match...
May 29, 2012 at 3:46 am
Eugene Elutin (5/29/2012)
Could you please specify all conditions you have
expanding the same sql
select s.id, s.name1,s.name2,s.name3,s.name4,d.[desc]
from dbo.Test_Join_Source s
inner join dbo.Test_Join_Destination d
on (s.name1=d.name1 or s.name2=d.name2 or s.name3=d.name3 or s.name4=d.name4)
May 29, 2012 at 3:26 am
Thanks for the reply Eugene. It was quite informative. Now I can say, I understand the joins some what better. Thanks.
Any ways, if we go back to the original question...
May 29, 2012 at 3:13 am
Eugene Elutin (5/28/2012)
pravasis (5/28/2012)
Dung Dinh (5/28/2012)
idname1name2desc
1test1 test2 ...
May 29, 2012 at 1:48 am
Dung Dinh (5/28/2012)
idname1name2desc
1test1 test2 ...
May 28, 2012 at 10:24 am
Try the following.
drop table [dbo].[Test_Join_Source2]
drop table [Test_Join_Destination2]
CREATE TABLE [dbo].[Test_Join_Source2](
[id] [int] NULL,
[name1] [varchar](50) NULL,
[name2] [varchar](50) NULL
)
CREATE TABLE [dbo].[Test_Join_Destination2](
[id] [int] NULL,
[name1] [varchar](50) NULL,
[name2] [varchar](50) NULL,
[desc] [nchar](10) NULL
)
INSERT INTO Test_Join_Source2(id,name1,name2)
VALUES(1,'test1','test2')
INSERT INTO Test_Join_Destination2(id,name1,name2,[desc])
VALUES(1,'test1','test4','testing')
INSERT...
May 28, 2012 at 9:50 am
patrickmcginnis59 (5/28/2012)
select s.id, s.name1,s.name2,d.[desc]
from dbo.Test_Join_Source s
inner join dbo.Test_Join_Destination d
on
s.name1=d.name1
union
select s.id, s.name1,s.name2,d.[desc]
from dbo.Test_Join_Source s
inner join...
May 28, 2012 at 9:24 am
Dung Dinh (5/28/2012)
How to prevent it? => It...
May 28, 2012 at 9:16 am
Hey, good news.
It worked in Windows 7.
Initially, I configured it in port 80. It was working with only with localhost option!!! When I tried with IP or system name,...
October 4, 2011 at 2:46 pm
Eric Klovning (12/29/2010)
There are two tools I know of, both plugins for SSMS.SQL Refactor from Apex SQL
http://www.apexsql.com/sql_tools_refactor.aspx
SQL Prompt (professional version) from Red Gate
http://www.red-gate.com/products/sql-development/sql-prompt/
Thanks!
Really appreciate it.
December 29, 2010 at 11:21 am
Viewing 15 posts - 1 through 15 (of 38 total)