> My own personal preference is to store similar data in a single table with an int status column, but I'm not sure if that would help out your cause.

I...

You require to use EXEC(...)

DECLARE @col varchar(10)

SET @col = 'UR_COLUMN'

EXEC ( 'SELECT ' + @col + ' FROM FOOBAR' )

Alternatively,

DECLARE @sql varchar(50), @col varchar(10)

SET @col = 'UR_COLUMN'

SET...

Hi Dan

I am sorry, could not get back to you.

Truly speaking I haven't tested with the solution you have given and I cannot test it till 15th.

Will let you know...

This is not the problem of the cursor...

The problem lies with the way you are creating the SQL query in the SET @Statement.

Check out this

SET @Statement...

Thanks a lot for the solution...

Will get back to you in a day or two...busy with some more things...

IF U DON'T SEEK PERFECTION, U CAN NEVER REACH EXCELLENCE!!!

SD

When RECURSIVE_TRIGGERS option for a database is set OFF, direct recursion is prevented. To diable indirect recursion the nested trigger server option has to be set to 0.

What about other...

Was very busy...could not reply...

Well, it works fine, but I have to do similar operations when Rejoining Status is updated.

When I update Rejoining Status to ACT,

then corresponding Leaving Status...

Well, no foreign key constraints in place...

I did not get time to work on this...will do it after weekend...

probably on sunday...

Thanks for the reminder... "always test code before you...

Well, here is my case

I have three tables

LeaveReq (ReqNo int, Empid int, Status varchar(3), ...)

Leaving (ReqNo int, LRReqNo int, Empid int, Statusvarchar(3), ...)

Rejoining (ReqNo int, LVReqNo int, LRReqNo int,...

Hi Danw

Thank you for the prompt reply...

But, I am still unclear about "rowset-based logic"!!!

Well, I will get back tomorrow since its time to leave for me...

IF U DON'T SEEK PERFECTION,...

Nice topic by SQL Server Guru, Antares686, really "Anything that is NOT about SQL"

Its cool to read about other members, although I have not read all...and definitely don't wanna miss...

hi carmmit

can u be more precise with your table design and what u wan't to do?

at the same time you can try

select salesid, partyid, vehicle1id vechile from fact

union all

select salesid,...

I guess you posted almost the same query in "General > SQLServer Newbie" with a detailed explanation...

You can refer that. Hope it helps you

IF U DON'T SEEK PERFECTION, U CAN...

You are using Query Analyzer to view the contents of the table (in text format)

Well, open your Query Analyzer, go to "Tools > Option" menu.

Go to the "Results" tab of...

Hi Scott

Yes that answer's my question!!!

Well, what you can do is create two lookups.

To the first lookup, you pass the index key as the parameter and get the record count....