It won't work, your column is defined as an integer,...

Run this:

Do you see your executable listed?

Ohhhh yesss! 🙂

In that case you might be better off asking your question in the InstallAware forums.

An SQL Reporting Services report, a Crystal Report, or something else...?

It usually better to do this sort of thing in the reporting tool itself.

Seems that most of your code follows a similar pattern for each of the cursors, so can be replaced by code similar to Lutz's example earlier.

The section marked "xraysID...

Try this to illustrate Gail's explanation:

SELECT TOP 10 NEWID() FROM sys.objects

It depends on a lot of things, please post more info on exactly what you are trying to achieve including table structures, example data.

Do you want to use a...

Slight problem, I think the question is incomplete:

1. In the text the table is referred to 'QOD_Customer' (singular), but in the SQL it is 'QOD_Customers' (plural)

2. There is no mention...

Here's another idea to add to the pot. Add an ordering column to your table and use ROW_NUMBER to populate it, like this:

INSERT XMLmodelMap(ordering,machineID, machineType, [.... etc ...])

SELECT ...

First you need to eradicate the cursor by doing your insert something like this:

INSERT XMLmodelMap(machineID, machineType, [.... etc ...])

SELECT

machineID,...

A variation on arun's solution above with fewer string concatenations:

SELECT

ID, substring(item1,N,charindex(',',item1+',',N)-N)

FROM

tally

CROSS...

If you provide a table definition and sample data in a ready to use format you're likely to get more help more quickly. See the 'How to post...' link in...

Sounds overly complicated, can you not just remove the column from the table?

Or delete the expression in the textbox?

Yes, that would do it too. But proper normalization would be better, as Jeff recommends (if possible).

I guess my attempt at humour...