Could you give us a few rows of data?  I am having trouble understanding the "seperated by even and odd numbers". 

Thanks Frank - I figured you or one or two other people would be the only ones to answer this... 

The script is not worth anyones time; actually, I was...

That sounds like a very good suggestion. 

If you want to keep historic data, no space is wasted in the "old" table; you want those records and no new records...

Thank you guys!  I was able to use your code in one location, Steve.  I am grateful for your research. 

I also very much appreciate knowing that @@Global does not...

I cannot seem to escape the requirement to DECLARE @Variable1Name, etc... 

I even tried changing everything to a @@Global, but once a new SPID is rattled off with Dynamic SQL,...

Thanks Steve!  Kenneth Wilhelmsson gave me URL to a great article on this using sp_executesql - I love it! 

Hopefully today I will be the weasel!!  (I can't believe I...

Thank you all!!  My horoscope said today would be good.  I have a number of things to try. 

I know the table method and that will work for this first...

I think if you put parens around your OR statement, it may look better. 

IF EXISTS(SELECT F00069, F00026, F01298, F01299, F01300

FROM patient INNER JOIN

tumor ON patient.UK = tumor.FK1 INNER JOIN...

Not having very good luck with this.  The first step in this existing process is to rename variables passed into the Stored Procedure. 

I was having a great deal of difficulty...

I would guess they meant to say a Trigger instead of a View.  Once one field in your tblStage2 is populated, (obviously you would want to pick a field that...

I do not use Coldfusion, but for SQL this is not as pretty, nor as specifc as the common code you are currently using.  But it will work. 

CREATE TABLE...

I think you need to write: 

WHERE     ( IN ('V5940R', 'V5941R'))

You are asking an extremely general question. 

You may want to hit some sights to find some good books on the subject. 

Until then, you can look in BOL under...

If you were using SQL Server, I would suggest getting a count from you Skillset table and either ALTER TABLE (if you are putting these into a #temptable for reporting)...

It sounds like you need to give more information.  Are you using single row processing, (the Cursor) to accomplish some kind of flow control for Updates versus Inserts? 

If not,...