When I've had to follow a hierarchical relationship in SQL 2000, I usually do the following:

1. create a temp table to store my results, with a Level column

2. "seed" the...

10x

How do you know when your parameter contains an optional value? Lets assume for a minute that it is NULL. You could do something like:

If @Parm1 is NULL

...

I'd agree with everything above. Also, run the profiler to get the exact string that RS is passing in, so you can test with something real.

How many rows are we talking about here? What happens when you run Select count(*) from the table, then run Select * from the table? Do the records match? Do...

I remember paying $0.80 per gallon in Texas in the mid '90s 🙂

If I would try to write in "SQL 2000" style SQL, I think I'd do something like

Select codSubTasks.taskID, codSubTasks.SubTaskID, codSubTasks.subTaskSequenceNum

(

Select codTasks.taskID,...

Perhaps a TOP 1 With an ORDER BY clause would also meet the need.

Check out...

http://www.connectionstrings.com/?carrier=sqlserver2005

Thx Jeff, you da man.

Select * From [1invalidtablename]

I was just thinking of a plain vanilla stored procedure that returns a single result set. When I develop client side applications, or even SQL Server Reporting Services, some code...

Is there no way to peek at the code of the SP you are calling and determine that? It will be the datatypes of all of the columns that are...

Here I go with another looping post...

If for some reason bcp does not do what you're after, you could do something like

declare

@a char(10)

, @b-2 char(255)

,...

With a UNION, it only matters that the data types of the columns you choose are the same. The column names that are returned in the first query in the...