can you post results of:

select distinct ascii(substring(yourcol,1,1))

from yourtable

No, it's a fairly common English name and a brand of razor in Europe.

Your problem is what the error msg says. You have a null in product_details, but descriptionHTML in...

Yep.

>If leading zeros were permitted, or if alphabetic (left-to-right regardless of length) sorting/searching on leading characters made sense, then the 'numbers' would clearly be numeric strings and should (presumptively but...

Because openquery (1) returns a recordset (2) that is disconnected from the underlying data source.

So you can't specify a delete statement inside OPENQUERY because that doesn't produce a recordset,...

Amit, how does that help?

See if this gives better results. You probably have whitespace characters other than space.

select

rtrim(ltrim(replace(replace(

nope.

If like me you are CASE-averse, you can do it with arithmetic, but I don't see any advantage, except the satisfaction of not using CASE, and handling NULLs (but a...

Or

 

select t.Product, t.OrderNo, max(t.DeliveryDate) lastdeldate

from tab t

group by t.Product, t.OrderNo

-requirements not entirely clear.

declare @d smalldatetime

select @d = dateadd(month,-6,datediff(day,0,getdate()))

-- ^^ this is 6 months ago with the time...

Not TSQL

I am shocked that so many people talk casually of using NOLOCK in a production system that isn't read only! As if locks were an unnecessary annoyance that can simply...

update t

set col = substring(t.col,1,len(t.col)-1)

from table t

where t.col like '%/' --if not all records are affected

You might want to consider...

I have found that parallelism very often seems to spoil otherwise impeccable queries. Maybe it's better in v9, but I doubt it. MS just keep adding more 'features' and don't...