you could replace blank values with infinity values for the datatype and range on those or you could also just replace blank values with the compared column like so:

select ...

from...

is Reorders.NDC indexed? if not that would explain the difference since the outer join to KeyIdentifiers would be supported by KeyIdentifier's clustered index but the IN() would have...

it's installed properly. use management studio, not the configuration manager to browse databases and objects.

sounds like you're trying to do something like this:

insert into A (x,y,z)

values (B.x,B.y,B.z)

you should be doing this instead:

insert into A (x,y,z)

select B.x,B.y,B.z from B

as requested earlier, please post your...

you have not specified any join condition between imlabel_sql and imitmidx_sql. so, imlabel_sql.description will have arbitrary values from imitmidx_sql.item_desc_1.

also, unless your app really allows imitmidx_sql.itemno to have leading spaces,...

do you see the MS SQL Server 2005 program group in the start menu? did you use the defaults when installing? (C:\Program Files\Microsoft SQL Server is the default home.) do...

does your database's collation support the characters?

no need for a numbers table.

declare @t table ( string varchar(255))

insert into @t

select 'CHARLES H#L6CAL JOEL4'

union select 'CHARLESHLCALJOEL'

union select 'red and green'

union select 'RedAndGreen'

union select 'RedAndGreen.'

select string, case when...

group your data based on an anchor date and divide by 7. adjust the anchor date based on what you consider the first day of the week. for...

don't forget that except implicitly compares every column, not just keys. so it can be used in situations where a not exists or not in or outer join wouldn't...

if possible, get those embedded fields into seperate columns via a view or computed columns! that'll make the code so much easier to follow and depending on your db...

views can't reference temp tables, but they can reference synonyms which in turn can reference temp tables. run the code below in a scratch db.

select getdate() as date, 1...

as an aside, using replace() to change UTF-x with UTF-y (or any encoding) is not a good idea. changing the character encoding declaration in the doctype DOES NOT change...

actually fListToVarchars can handle xml markup with a judicious use of replace(). just replace char(60) with '<' and char(38) with '&'. i posted an old version without that...

this suggestion addresses your need, not the error.

declare @Url table ( url varchar(1024 ))

insert into @Url

select 'http://website.net/trimmed-Jacket.aspx?yyy=137668&DeptId=16465&TypeId=1&Type=0&viewall=1'

union select 'http://www.website.com/Elastic-Triple-Pleated.aspx?yyy=96561&DeptId=13898&TypeId=1&Type=0'

union select 'http://www.website.com/Double-Pleated-Stretch.aspx?yyy=111616&DeptId=14376&TypeId=1&Type=0'

union select 'http://www.website.com/Product/AltPopUp.aspx?yyy=120767&DeptId=13849&TypeId=1&Type=0&NotFound=1&za=1'

union select 'http://www.website.com/DetailNotFound.aspx?yyy=103770&DeptId=13849&TypeId=1&Type=0&NotFound=1'

union select 'http://www.website.com/DetailNotFound.aspx?yyy=69371&DeptId=13848&TypeId=1&Type=0&viewall=1&NotFound=1'

union select 'http://www.website.com/Green-Living-Cotton-bed.aspx?yyy=127553&DeptId=15184&TypeId=1&Type=0'

union...