Is there an existing application or reporting tool that already is writing or retrieving data against the data?

If so you can run the SQL Server Profiler tool to see what...

Thank you both. This has been educational and I have been able to unequivocally demonstrate to my very expensive and supposedly enterprise-level vendor that their product is just not very...

Thank you so much. A few more questions if I may.

Am I correct in thinking that this character may not show up, that is be visible, in a normal text...

I get this

subloc(No column name)

148

246

357

457

513

SELECT'*'+IssuerValue+'*' returns '*0.99 *' as an example. It appears to be a space. If I add IssuerValue LIKE '% ' to my WHERE statement nothing is returned.

ISNUMERIC(IssuerValue) = 0 returns...

I checked in a...

Here is a kludge possible solution if you really want it.

Create a a master generic table with enough columns to accommodate your widest result set. They'll probably need to be...

Oh I'm sorry you answered that question. Are the three sections side by side or underneath each other?

Are the three result set identical as far as columns? Can you UNION them together?

Thanks, this is what I call actionable intelligence. Its a vm system so hopefully may admin can easily bump it up...

How about this update statement?

UPDATE CLI_CleanUp

SET CLI = stuff (CLI, patindex( '%[^0-9]%', CLI),1,'')

WHERE patindex( '%[^0-9]%',CLI) <>0

Thank you GSquared.

I have an 'AttributeDataType' field in my Attributes tables which has a constraint limiting that field to either 'Numeric' or 'Character'.

Is it possible for my 'one or...

Ok thanks that sent me in the correct direction.

ALTER TABLE [dbo].[AttributeValues]

ADD CONSTRAINT CK_Attributevalue

CHECK

(

(Value_Numeric IS NULL AND Value_Character IS NOT NULL)

OR

(Value_Numeric IS NOT NULL AND Value_Character IS NULL)

)

The foreign key constraint error message would indicate that you are attempting to insert a industry into IndustryAss which doesn't exist in table Industry.

You will need to populate the industry...

I believe these will help.

http://www.bimonkey.com/2009/08/the-derived-column-transformation/

http://sqlyoga.com/2010/01/sql-server-ssis-derived-column-data.html