Can you post some DDL and sample data so I can check?

It may depend on the type of your sal column.

RTRIM(ISNULL(abc, '')) = ''

The above code converts abc (character string)...

Sorry. Let's try that one more time.

;WITH CTE1 AS (

SELECT TOP 100 PERCENT Origin, Destination, Tonnage

FROM #Trips

ORDER...

Try:

select *

from tablename

where RTRIM(ISNULL(id, '')) = '' or RTRIM(ISNULL(name, '')) = '' OR RTRIM(ISNULL(sal, '')) = ''

Interesting. I found a way to force it to work.

;WITH CTE AS (

SELECT c.Origin, c.Destination, c.Tonnage

,n=ROW_NUMBER() OVER...

Jeff is probably right, of course.

However I thought I'd try this using a quirk I've seen in CROSS APPLY VALUES with respect to the order of the results...

Just what am I dangling? I didn't think...

Something like this perhaps?

DECLARE @t TABLE (Name VARCHAR(10), [TYPE] VARCHAR(10), Price MONEY)

INSERT INTO @t

SELECT 'nameA', 'typeA', 1.00

UNION ALL SELECT 'nameA', 'typeB', 2.75

UNION ALL SELECT 'nameB', 'typeA', 2.00

UNION ALL SELECT 'nameC',...

saschup (8/24/2012)

---

Thanks Fishman! This worked snazzily. I really appreciate the help from you and Ev. I can use these tips for all the other migration tasks I...

ChrisM@Work (8/24/2012)

---

Shadab Shah (8/23/2012)

---

Hi,

I have one query as SELECT A FROM TEMP1.

And the other query as SELECT B FROM TEMP2.

Now i want the answer to be shown as A-B.

I don't...

J Livingston SQL (8/24/2012)

---

whar results are supposed to be returned for this data set?

CREATE TABLE #Test

(ID int NOT NULL IDENTITY(1,1) Primary key,

TranID int NOT NULL,

OriginCode varchar(5) NOT NULL,

DestinationCode...

There is a faster way though.

SELECT TranID, RouteInfo=

(

SELECT OriginCode + ''

FROM (

...

A deadlock will throw this exception:

Error Number: 1205

Error Severity: 13

Error State: 13

Error Message: Transaction (Process ID 78) was deadlocked on lock | communication buffer resources with another process and has...

ChrisM@Work (8/24/2012)

---

Absolutely. The weight of opinion won't magically change the way SQL Server works, or anything else for that matter - and yet it's...

Depending on how many legacy rows you need to convert, you may want to consider this approach to the phone numbers:

INSERT INTO #TempPhone

( ContactID, PhoneTypeID, PhoneNumber)

SELECT

ContactID, n, Phone

FROM

#TempLegacy

CROSS APPLY (

...

Since row ordering is not guaranteed by SQL, how do you know you're subtracting the right numbers at each row?