Posted
by vanslly
on Stack Overflow
See other posts from Stack Overflow
or by vanslly
Published on 2008-10-20T20:11:15Z
Indexed on
2010/03/24
19:53 UTC
Read the original article
Hit count: 378
A cross join performs a cartesian product on the tuples of the two sets.
SELECT *
FROM Table1
CROSS JOIN Table2
Which circumstances render such an SQL operation particularly useful?
© Stack Overflow or respective owner
as seen on SQL Authority
- Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL…
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
Earlier this week, I was delivering Advanced BI training on the subject of “SQL Server 2008 R2″. I had great time delivering the session. During the session, we talked about SQL Server 2010 Denali. Suddenly one of the attendees suggested his displeasure for the product. He said, even though…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
I am trying to install SQL Server on Windows 2012. I was able to finally get the wizard up and running after making some changes on the server, but now it fails no matter what I do with the following error:
TITLE: SQL Server Setup failure.
SQL Server Setup has encountered the following error:
…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I need to detect which version of SQL I am dealing with to perorm various tasks, I need specifically detect if I am on SQL 2008 or SQL Azure.
How can I do this with detection code written in SQL?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Here is the query:
INSERT INTO @TempTable
SELECT UserID,
Name,
Address1 =
(SELECT TOP 1 [Address] FROM
(SELECT TOP 1 [Address] FROM [UserAddress] ua INNER JOIN UserAddressOrder uo ON ua.UserID = uo.UserID WHERE ua.UserID = u.UserID
ORDER BY uo.AddressOrder ASC) q
ORDER BY AddressOrder…
>>> More
as seen on SQL Blog
- Search for 'SQL Blog'
The query optimizer does not always choose an optimal strategy when joining partitioned tables. This post looks at an example, showing how a manual rewrite of the query can almost double performance, while reducing the memory grant to almost nothing. Test Data The two tables in this example use…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Just a small question regarding joins. I have a table with around 30 fields and i was thinking about making a second table to store 10 of those fields. Then i would just join them in with the main data. The 10 fields that i was planning to store in a second table does not get queried directly, it's…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Just a small question regarding joins. I have a table with around 30 fields and i was thinking about making a second table to store 10 of those fields. Then i would just join them in with the main data. The 10 fields that i was planning to store in a second table does not get queried directly, it's…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Table 1
Field1 Field2
AA 20
AA 20
AB 12
AC 13
Table2
field3 field4
AA 20
AA 20
AC 13
AD 23
AW 21
output required:
newfield field2 field4
AA 20 20
AA 20 20
AC 13 13
I used:
select field1 as newfield, t1.field2,t2.field4
from table1 t1 join table2 t2 on t1.field1=t2.field3
This…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a program to use the IMDB database and am having very slow performance on my query. It appears that it doesn't use my where condition until after it materializes everything. I looked around for hints to use but nothing seems to work. Here is my query:
SELECT *
FROM name as n1
FULL JOIN…
>>> More
