It's not completely necessary to use a textual method for identifying the group of related codes.

Similarily, having a status based on a textual value is also not ideal.

eg.

Use one table to...

simflex,

Right, here goes. This is how I do more or less what you are wanting to do, ie. present data from multiple queries on a form/report.

Below is the sp that...

Simflex,

Your form is getting longer and longer and longer and longer and longer etc.....

You may be better off re-thinking your interface. I would.

It is not logical to have one form...

Bingo!

Code Reuse!

The reason I wanted to use a cursor apart from not being able to see a set solution was so that I could call an sp I had already...

Also :-

select name, count(name) as namecount, count(name) * 100 / namecount_total as namecount_percentage

from tablename, (select count(name) as namecount_total

from tablename) name_totals

group by name

order by name

As sometimes it is useful to get...

Another little thing, you will have to play/read up on all the possible values for type, xtype etc to ensure you have the correct "text" type fields.

Here's a useful view...

A weird request, but one that could be solved writing some dynamic SQL.

1. Iterate through the list of tables in the database that contain "text" type fields. Probably best declaring...

I'm not being daft then.

I cant understand why people go to such lengths to avoid using a technology / method that has been around for decades (almost). Just coz it's...

simflex,

I actually tried to help you with this in my previous post :-

SELECT 1 AS Recorset_Id, *

FROM table1

WHERE IncidentId = @l_Parm_Incident_Id

SELECT 2 AS Recorset_Id, *

FROM table2

WHERE IncidentId = @l_Parm_Incident_Id

SELECT 3...

It is if you know what you are doing with database tables and how to design them properly when the values inside them can be created or modified by a...

simflex,

On a completely different subject, nice looking form, although the validation is a little awkward. Validating and Reporting each field one at a time is a pain. Try building up...

Same Versions!

SCOPE_IDENTITY it is then.

Once again, many thanks for contributions.

Thanks for assistance.

IDENT_CURRENT seemed to do the trick. Although I was forced to enter the name of the table.

Help much appreciated.

Many thanks to all who replied. Especially Antares686, I followed all the links and found the information very useful - albeit stuff I already knew.

I have come to the conclusion...