*.SQL File - Seemingly Easy

The Set-Up:
Remote Shared SQL Server
Local Software - SQL Server Enterprise Manager
.SQL File
The Problem:
I am trying to set up a forum on my website which tells me to use the
supplied .SQL file to set up the tables. How do I go about doing that?
Thanks in advance for any feedback."Ryan" <Ryan@.discussions.microsoft.com> wrote in message
news:D3D230D4-6344-409A-9926-54BC64CBE973@.microsoft.com...
> The Set-Up:
> Remote Shared SQL Server
> Local Software - SQL Server Enterprise Manager
> .SQL File
> The Problem:
> I am trying to set up a forum on my website which tells me to use the
> supplied .SQL file to set up the tables. How do I go about doing that?
> Thanks in advance for any feedback.
Open up Query Analyzer (from EM you can highlight the correct database and
select Tools > Query Analyzer from the main menu). Then in QA, click File >
Open ... and load your .SQL file. Then select Query > Execute (or press
F5).|||Heck ya, thanks lots!

*.SQL File - Seemingly Easy

The Set-Up:
Remote Shared SQL Server
Local Software - SQL Server Enterprise Manager
.SQL File
The Problem:
I am trying to set up a forum on my website which tells me to use the
supplied .SQL file to set up the tables. How do I go about doing that?
Thanks in advance for any feedback."Ryan" <Ryan@.discussions.microsoft.com> wrote in message
news:D3D230D4-6344-409A-9926-54BC64CBE973@.microsoft.com...
> The Set-Up:
> Remote Shared SQL Server
> Local Software - SQL Server Enterprise Manager
> .SQL File
> The Problem:
> I am trying to set up a forum on my website which tells me to use the
> supplied .SQL file to set up the tables. How do I go about doing that?
> Thanks in advance for any feedback.
Open up Query Analyzer (from EM you can highlight the correct database and
select Tools > Query Analyzer from the main menu). Then in QA, click File >
Open ... and load your .SQL file. Then select Query > Execute (or press
F5).|||Heck ya, thanks lots!

(seemingly) simple query question

I have a table that looks like this:

x t
- --
1 0
2 0
1 1
2 1
3 1

How do I query it to get this:

t0 t1
-- --
1 1
2 2
NULL 3

the formatting is messed up, but there are 2 fields: type0 with records 1,2,NULL and type1 with records 1,2,3

Please help if you can, this is urgent.
Thanks In Advance, Yury.I don't know which tables contain which data, but an outer join should do what you need.

SELECT table1.type0
, table2.type1
FROM table1 RIGHT JOIN table2
ON table1.field = table2.field

Hope this helps.