The only problem is -L is local and broadcast servers. I want those broadcast servers filtered out.

-L

Lists the locally configured servers and the names of the servers broadcasting on the...

It needs to be something like this:

CREATE TABLE dbo.TableC

(

TableCid uniqueidentifier NOT NULL,

BookName nvarchar(50) NOT NULL

) ON [PRIMARY]

GO

ALTER TABLE dbo.TableC ADD CONSTRAINT

PK_TableC PRIMARY KEY CLUSTERED

(

TableCid

) WITH( STATISTICS_NORECOMPUTE = OFF,...

i don't really have an answer for you but I have to solutions for you to figure out what the issue is.

1) Use the import task from SQl and have...

select *

FROM TableA with (index(IX_TableA))

IX_TableA = Index on date

I am thinking something like this

wow thanks. I am asleep at the wheel!

select a.*, b.*

from a

join b with (index(b_col1_index)) on a.id=b.id

Something like this?

Here is the SQL function. Using a CLR can I improve this? The lists that we send in are usually guids. Most our system runs on them....

Yeah that is kind of what I was asking. Thanks

sorry answered my own question -C{OEM}

that is a good idea. I did not think about using that since I had the wrapper on that already. I wonder if that will work. I...

Agreed I should have used raise error when I started making these but the code architecture expects the @@error return so I screwed that up. I have over 200...

Thats funny because we proved that wrong. If we do not check for errors it is not rolling back. We now are checking so it does roll back....

We saw a few ways.

1) Store RGB in three fields (int) that way shades can be accounted for

2) Varbinary - Store the hexidecimal Value

3) have predefined colors that are associated...

I use BCP but usually do not use a global temp. I am curious when you dispose of the global ##temp. When you create the .txt it should...

Yeah, I was surprised that is what is the best technique. Since I guess we are not storing shades that will work.