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

Does the data exist somewhere else or can it be imported? If so you could build an insert based on this data source.

INSERT INTO IndustryAss

SELECT

CompanyId,

IndustryID

FROM Some_Other_Table_...

The SELECT statement by...

Other options:

-encrypt the file(s) and transfer via ftp

-transfer the files via secure ftp

In any scenario you probably want to look at compressing the file(s) unless you have a small amount...

It looks like a single employee can have multiple records.

1 virginia usa

1 texas usa

1 new york usa

Can an employee have more than one record in the same state?

If you can...