Probably should be listed under "Scripts" instead of "Articles".

At the bottom of your query window is a status bar with your connection information. First connect you session, then check to see what it says.

Now execute...

You're almost there:

select

code,

description,

sum( Case When priority=1 Then Amount Else 0 End ),

sum( Case When priority=2 Then Amount Else 0 End ),

sum( Case When priority=3 Then Amount Else 0...

Thanks for letting us know.

Glad I could help.

Try adding "[font="Courier New"], @datasrc=@ServerName[/font]" to your [font="System"]sp_addlinkedserver[/font] statement.

ISNULL does require two arguments and you have 2 ISNULL functions in that statement (only the outer one has the second argument). I suspect that you do not need...

OK, on QA for SQL 2000 it is under the "Tools" menu, click the "Options" item, then select the "Connections" tab on the dialog that comes up. You should...

Is this homework? And if it is, how much help are you allowed to have from sources like this one?

Select ID

From Properties

Where ID Not IN (Select Assigned.PropertyID From Assigned)

If [font="Courier New"]SELECT * FROM INFORMATION_SCHEMA.TABLES[/font] returns no output then either something like SET NOEXEC is preventing run from running or producing output, or else, you just do not have...

I've wondered the same thing for 7 years. Let me know if you find out.

You had it right about...

Right-click: "Query Options"...

under "Execution..Advanced" tab, uncheck "Disconnect after query executes"

--------------------

Is someone practicing April Fool's jokes early today?

SET NOEXEC OFF