*nix files end in a LF only.

Just an FYI.

The following is test code. Look at it and adapt it as needed for your purposes:

declare @ClaimCat table(

Claims int,

Category char(2)

);

insert...

raghu (3/24/2009)

---

HI

i have a proc which displays the result as

CLAIMS CATEGORY

12345 P1

42342 ...

It would help to see the actual code you are trying to replace. In addition changing from a cursor to a while loop doesn't really change much, it is...

foxjazz,

First, don't repost this thread, maybe we can get Steve to move it to a SQL Server 2005 forum.

Second, since you are using SQL Server 2005, please post future questions...

foxjazz,

You post the DDL for your tables, which is good. What you also need to do is post the SQL code you are writing and having difficulty with, not...

Roy Ernest (3/24/2009)

---

Hahahaha Lynn, Maybe you should not have put Drop Table statements in the end. :hehe:

Maybe you should edit your post and state that you should not use the...

Is it me or are the people we are trying to help just getting dumber, or do we need to start commenting are code a lot more heavily?

You don't need to use the INSERT statements. Those were there to load the test table (dbo.TestTab1) with data, which was then used to load dbo.TestTab2 with the same...

As I said before, we need the DDL (CREATE TABLE statement) for the table, sample data for the table (formated as INSERT statements so we may cut, paste, and run...

suhailquadri (3/23/2009)

---

Hey,

following expects to display distinct rows but it is not.. can any body help me out..

TID datatype is integer

SELECT distinct TID, EID, ENAME, EDATE, UID, EISSUCCESSFUL, EREMARKS

FROM ...

Here is some test code for you to start with and it does it all in T-SQL, not SSIS:

-- Create initial test table that will be the source data

create table...

Jack Corbett (3/23/2009)

---

And what's your definition of short? Even though I'm...

You are missing the "end" for the case statement in your original code.

try one of these:

select

(case when (leavedate is null)

...

True, but for me there are three seasons of soccer, Fall, Spring, and Tournament with a definate break in there to relax. I haven't done indoor soccer and I...