Unfortunately I do not use SQL server 2005.

Further more, above link is talking about static 90 degree turn, as he knows all the columns, I do not. It will be...

oh, forgot to mention.

select statement is dynamic, ea

select ' + @fields + ' from table

so we don't really know what @fields may have.

try

... WHERE @@IDENTITY ...

I think it's possible if your column 1 has IDENTITY.

Then I believe you can do whatever with that.

Such as ORDER BY $IDENTITY or WHERE $IDENTITY = 'blabla'

got it to work w/o cursor. thanks all

Sorry... there was not suppose to be COUNT

tring is like this:

EXEC ('SELECT ' + @ReverseFields + ' = ItemID FROM biditems where EventID in (' + @EventID + ')')

won't work... i get an error... like data type int and convert type modulo...

ok... let's try w/o modulo

how can I do some sort of a INSTRING to cut numbers before...

oh, how would I do that if originally @currentBid and @NewBid are data type 'money' and @bidincrement is 'varchar'

Thank you... I forgot about modulo existence

I just didn't know if something like that would possible to do on Application side. I'll try that. SOrry for asking here =)

Yeah, only users associated with those specific EventIDs and FieldIDs we are passing in should show up.

Yeah that would work except.... thanks for replying though.

As I said - data in DB is dynamic, procedure should not rely on UserID.

Procedure will only receive 2 parameters - set...

I was trying to find some solution, but couldn't. COuld you please help me do this?

here is statements as you asked:

create table zTempTable1 (FieldID int, FormID int, ReportName varchar(128))

create table...

I thought tables show everything in pretty easy way.

What other details should I provide?

no one knows?