sql version in red, Os version in BLue

select @@version

Returns

Microsoft SQL Server  2000 - 8.00.194 (Intel X86)

 Aug  6 2000 00:57:48

 Copyright (c) 1988-2000 Microsoft Corporation

 Personal Edition on Windows...

A bit of light reading.

I do not believe there is an "Easier way"

This article discusses several options

Output Parameters

Rewriting query using table valued functions

Sharing TempTables

Insert/Exec

Openquery.

http://www.sommarskog.se/share_data.html

I'm not exactly sure what you mean cursor data.

But you cannot easily pass Recordsets between stored procedures.

You have to persist the data to a temporary table and you have to...

Is there a question somewhere in here?

Tough problems may require creative solutions. T-Sql may require you to be a little too creative.

T-Sql is fairly inadequate when it comes to dealing with objects outside of the database.

So...

Performance ahh who needs it.

its all good.

Performance is all in the users experience and perception.

You can have a subsecond query, but if the...

You may be experiencing locking.

in query analyzer open a session window, and perform your select.

Then in a different session window type in sp_who2

In the resultset If you see a number...

Not knowing your entity definitions, or relationships, from what you have described it looks ok.

Declare @category varchar(50)

Set @Category = 'MyCategory'

select id_Products

From Products

Join Categories_x_products on id_products = product_id

join Categories on categories_id...

You cannot union the results of many stored procedures.

you can insert results from each stored procedure into a temp table, and then select from that.

Or create a new stored procedure...

Aside from Sql Bills Advice.

Did you try to fully qualify your table. using

databasename.dbo.tablename?

So your build sql statement will look like this

Select @col = name from syscolumns where id = @tbid...

Uh oh, Feel a good debate coming on w/ this one.

I'm sure There will be a small difference of opinion, but here goes.

Some feel the Logical database schema is relegated...

It all depends on your grouping. Modify the grouping visibility

The default visibility should be Hidden. Then check the Visibility can be toggled by another report item., then select the item...

Check out Books online on Expanding Hierarchies:

BOL MSDN: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_14_5yk3.asp

This describes a way to retrieve data using a recursive model

Also Google search on "Trees in Sql" You;ll likely find an...

Check out

http://www.sqldts.com/default.aspx?205

sqldts.com has a ton of articles about this stuff.

copying between servers is easy, you can set up connections for each server, and create data pump tasks.

Take a...

I'm totally confused.

You should not have to drop the primary key constraint on a table just to drop a column. (Unless the column you want to drop participates in the...