SELECT otherstu0_.STUDENT_DBKEY AS STUDENT1_0_ , otherstu0_.IDENTIFIER_DBKEY
AS IDENTIFIER2_0_ FROM OTHER_STUDENT_IDENTIFIER otherstu0_ WHERE
otherstu0_.STUDENT_DBKEY IN ( SELECT studentpdo0_.STUDENT_DBKEY FROM STUDENT
studentpdo0_ inner join TUTOR tutorpdo1_ ON studentpdo0_ ...

I need to write a query and am stuck at this last requirement so I am
looking for a little help,
User   Perm. Address    Temp. Address
A    1                      1

I just updated my PC with XP service pack 3 and now I cannot connect
to the SQL server on my network via the host name.  I can however
connect with the IP address.  Named pipes are enabled.  Where do I go
from here?

Question:  is SSIS (sql server 2005 and higher)  like online analytic
processing?  Does it involve cubes at all?  My place may be stepping up to
sql server 2005 from 2000.  The big buzz word is SSIS.  Any explanations
appreciated on what SSIS entails.

CREATE TABLE #TEST_ONE (
    ID INT IDENTITY(1,1) NOT NULL,
    TEST_ONE_ITEM VARCHAR(30) NULL
)

I just started using SQL to create a report. I got the syntax working
but I have absolutely no idea of how to format data. Can anyone kindly
look at my code and help me? I thank you in advance.
Details:-

Below script works fine with in sql2000 version without errors
DECLARE grant_cursor CURSOR READ_ONLY FOR
    select * from #test
    OPEN grant_cursor

I have added my Active Directory server as Linked Server, ADSI, and was able
to query it like:
select * from openquery
(

SQL2000 standard SP4. I've given a user exec permission on a stored
procedure that I've created but she gets an error when running it. The
output through QA when I run the stored proc with exec is:
(8062 row(s) affected)

I have a view that is refusing to run. The view is stored in database1, the
view does a select on tables in database2 and when I run the view I get an
timeout error after it runs about 10 seconds but if I remove all of the SQL
within the view and copy and paste it to a new query ...

Trying to delete from a Table variable from a join on 2 tables.
Why is this example deleting all rows instead of just what is equal to the
where clause?
DECLARE @TABLE1 TABLE

I need a sql code to replace all alphanumeric from a column value,
basically; its a varchar column to store telephone num. for e.g
Data                                            Result
================================

i just want table order to create using  sys.foreign_keys , because i have
every table as separate object
with help of this query i took those not having relationship , so these
table can be created first

I have a query that produces a list of companies and their effective controls
status for the given year:
select companyname, iseffective, year from internalcontrols
where year > 2004

I am trying to move sp from SQL2000 to SQL2005.
I guess I have to go to do this procedure (below)..
"Right click on the database in the object explorer, go Tasks->Generate
Scripts. Set Script Object-Level Permission to True, click Next, check only