It will modify to work with SQL Server 2000 fine; however, you will need to use derived tables instead of CTEs. I will look at this over lunch and...

Karthik:

In general neither of these alternatives would be my typical first choice at addressing a problem. There are times in which LOOP and CURSOR are the prescribed approach to...

The simpler approach would be to just pass through the table for each column and use SUM and CASE to count up your totals. However, if your "Kipp" table...

Kipp,

Here is my first pass at this; I hope this helps a little:

with baseProject as

( select distinct

case when charindex('.', proj_id) > 0

...

I am not sure which format you are aiming at; you might want to give a look at the CAST AND CONVERT article in books online. If you are...

Well said. Thanks to both of you for picking me up on this. 🙂

Ripal,

I would suggest that you need to make a compromise in your constraints. There several major obstacles here including (1) you are using SQL 2000 instead of SQL 2005,...

If you would rather have two distinct comma delimited lists this is also an easy task to perform using XML formatting. That can be done using the same source...

Table variables are not available to be used as arguments to procedures or functions in either SQL 2000 or SQL 2005. Table variables are a feature that continues to...

If you are wanting to pass a table to a function you might want to consider converting the table to XML and passing the XML as the argument to the...

When you execute your create the temp table through dynamic SQL you are creating that temp table in a context that is completely separate from the context of the stored...

It will help if you give more description of what it is you are trying to do so that we do not end up helping you destroy your table. ...

Oh well, are you using SQL Server 2000 or SQL Server 2005?

I can put a query together to produce this report, but the relationships of the data to produce this report looks very weak or even technically not related. I...

Mahesh:

I would suggest that in addition to preparing for the set of questions that come from the person reviewing you that you also be prepared and have yourself a set...