Jeff Moden (3/24/2009)

Also, your query doesn't put it all back together like the op wanted and you don't...

Actually Mohit is right. The best way is to have a decrypted copy of the code.

Thank you.

Pls post the whole query, table structure and some sample data.

Jeff

I mistook this (1230-544,15C5487,132DE78) for a single value rather than 3 values that they are. I assume the op wanted to process one value.

Using a number table would be...

check these out

http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/30622/

http://www.sqlservercentral.com/Forums/Topic668995-146-1.aspx

Have a look at this

declare @str varchar(100)

select @str = '1230-544,15C5487,132DE78'

;With Breakdown as

(

Select

SubString(@Str,1,1)[Chr],

1[Idx]

Union All

Select

SubString(@Str,Idx+1,1),

Idx+1

from Breakdown

where (Idx+1)<=Len(@Str)

)

select chr from Breakdown where isnumeric(chr) = 1

Edit:- This will return ',' and '-'....

Look up the EXISTS clause.

IF EXISTS (your query here)

BEGIN

Do something

END

Pls give more details.

In BOL under Creating Indexes (Database Engine) section its mentioned that there can be 249 non clustered indexes per table.

But In BOL under Create table sections its...

Edit:- I posted a query which was not correct. I have removed that query. I could not delete this post.

Hi

Lonekat_id inserted into personal table must be existing in lonekat table.

As Chris pointed out the rule needs to be mentioned to eliminate the row but still here goes.....

select *,'A' from samm where noo <> all (select noo from #sammM)

UNION

select...

You need some identifier value to tell which records are from which table. It could be a column or a static value.

Ex: SELECT *,'A' FROM samm

union

SELECT *,'B' FROM sammM...

You can use openrowset or opendatasource to export data to excel. If the data set is large its better to use bcp.

Example of bcp - xp_cmdshell 'bcp "select col1,xol2 from...