On a personal note, this forum thread allowed me to break 3000 forum posts!

Edit: And that does NOT count this post!

Paul Nicholson (11/24/2008)

---

Lynn,

I just realised that the server running the application is one that hasn't been upgraded to 2005 and is still running 2000 - I also noticed that there...

Paul Nicholson (11/24/2008)

---

Lynn,

Thanks very much for your offer of assistance, below is a sample (10 rows) CSV file from the major query providing the source data. Further down is...

To make things easier, provide me with sample data as it would come as the result of your major query, you know the one with all those left and right...

The thing is, what I am seeing is a very procedural process. When moving to SQL, you have to change your mind set to a set based approach. ...

Jeffrey Williams (11/24/2008)

-- CASE

SELECT CASE WHEN col1 < 50 THEN 0

WHEN col1 < 40 THEN...

Some sample data and expected results based on the sample data would also be quite welcome.

RBAR! You should be able to do this in a set based query. First thing to ask, WHAT are trying to accomplish, NOT HOW do you do it....

jacroberts (11/24/2008)

---

timothyawiseman (11/24/2008)

---

I agree with Jeff that performance should always be a concern. After all, you may eventually need...

Have you read the article about running totals that I have linked in my signature block below? If not, you might want to spend some time reading it and...

Could you explain in greater detail what it is you want to accomplish?

Check out the following code:

CREATE TABLE [dbo].[TableA](

[fileID] [int] NOT NULL,

[langId] [int] NOT NULL

) ON...

Noticed one thing, make it a select distinct on the outer select.

Hope the following test code helps you out:

create table #TestTab (

Col1 int,

Col2 int

);

insert into #TestTab

select 4352279, ...

Chris Rogers (11/24/2008)

---

A little addition here. I was, obviously, having this problem as well. Here is an example of what my proc looked like:

CREATE PROC Reports.MyExampleProc

@StartDate DateTime,

@EndDate DateTime

AS

IF(@EndDate...