There is definitly not a pretty way to do what you want. My advice is to split by, then strip out, all non-numeric characters, cast the remaning numeric characters as...

very cool!

If you're interested in digging deeper into the system tables, you may find this link useful:

http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

I'm sorry, I'm not going to get a chance to put anything together today. I'm happy to help, just need to find some time.

I'll second Ninja's suggestion of using a stored proc. Building applications that build sql string from data (any data) introduces a very significant security flaw.

Some examples:

User input expects...

It depends on how reliable you want the results to be.

Using NOLOCK, you're query can sometimes double-read rows, skip rows, do phantom reads, dirty reads etc.

Yes it is faster,...

Cool!

Thanks for the feedback. I'm glad I could help!

One more question:

How many questions (roughly) do you expect in an average survey?

In the meantime, I posted a dynamic solution to a similar problem here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=321627#bm321791

I figured.

I'll post a dynamic solution a little later today.

Cheers!

-Robert

If you are wrapping this inside of a transaction, the user will not see the table as empty (in fact, the user will not see anything as both tables will...

Off the top of my head, this might give you the desired results, but it also may not be exactly what you are after. The query does use an aggregate...

The proc SP_Helptext will give you proc/trigger/view source

Use MyDB
EXEC sp_helptext myProc
--OR
EXEC mydb.dbo.sp_helptext myProc

For tables, the only way that I am aware of to programmatically generate create scrips is through DMO....

Yes. Use this syntax

DECLARE @return_Val INT

EXEC @return_Val = s_Proc
IF @return_val =...

This will work as long as the proc uses the RETURN statement.

Hmm, that is a mystery. When you are referencing these views, what happens if you fully qualify the names (Databse.owner.objectname)?

Does it still work with one user but not the other?

Good, I'm glad you've found a solution!

I don't know any way to add the double quotes either (short of doing it in the query). If anyone finds a way to,...

The most likely answer is the views were created by the database user and when the user created the views, he/she didn't prefix the names with dbo.

When you don't qualify...