Thank you, everyone for your feedback! 

I have considered myself an intermediate user for a while now, and this is totally greek to me.  But, I will walk through it...

Thank you for the reply!

I am not sure if this is going to work for me.  I dont know the rank ahead of time of each record, and it appears...

I have used this same crosstab procedure, and when I run it in Query Analyzer, it works great!!

However, when i try to call the procedure from my web page (I...

That worked great!!

Thank you for your help!

This is what I need to get away from:

INSERT INTO @tbl VALUES ('user1',125,'rsn1','cd1','loc1')

 INSERT INTO @tbl VALUES (NULL,128,'rsn3','cd27','loc3')

 INSERT INTO @tbl VALUES (NULL,721,'rsn3','cd4','loc5')

 INSERT INTO @tbl VALUES ('user2',122,'rsn3','cd1','loc3')

 INSERT INTO @tbl VALUES (NULL,125,'rsn9','cd5','loc5')

I...

Ram,

Can the INSERT INTO values be populated from a query?  I have approximately 115,000 records in my table so I dont want to type each of them out.  I tried...

WOO HOO!!  Thank you! 

That worked like a charm!

I dont believe so.  Here is a sample of my query:

SELECT UsersID, COUNT(SDDField) AS SDDField, COUNT(ETField) AS ETField, CASE WHEN CMPField = "Hello" THEN (SELECT COUNT(CMPField) FROM MyTable) END AS...

mkeast -

this new one gives me a syntax error.  yes, it is giving me these results:

IW555124null

nullACS3411190

I modified your last code to this: 

function Main()

{

  var c9 = DTSSource("Col009")

  var...

mkeast - I tried your last suggestion, same results.  I went into the .txt file and typed n/a into the null field on the first record that wasn't coming across,...

D'Arcy had asked the question if these columns are really null...

They are null.  In the text file in one record column 8,9,10,11 look like this:  |WWW|IW555124||jm9999| 

the next record looks...

mkeast and D'Arcy Irvine - 

Thank you for your help!!!!!  This partially works.  I am getting the values now from column 009 without the null appended to it, but i...

phillcart - thanks for the post!  I have tried several variations of your suggestion and come up with syntax errors.

In the ActiveX Script window it shows that I am using JavaScript. ...