Another way to do the comparison is to cast the values to VARBINARY.

Also, a LIKE comparison will be "closer", but it is not 100% either.

That is correct, SQL will ignore trailing whitespaces.

http://support.microsoft.com/default.aspx/kb/316626

I think it was touched on with the distribution of data. But, to add to that, if you have a query plan in cache it'll use that until it thinks...

Not to try to confuse things anymore, but there is also: SET XACT_ABORT { ON | OFF }

Which may or maynot help you in your particular scenario.. 🙂

SELECT

*

FROM

TableA AS A

LEFT OUTER JOIN

TableB AS B

ON A.Col1 = B.Col1

AND A.Col2 = B.Col2

...

AND A.Col9 = B.Col9

WHERE

B.Col1 IS NULLIf the tables are on different servers you will need to fully...

I agree with what GSquared said. In Addition to that there are some trade offs.

The File System is nice bcause you can use "xcopy" deployment (just copy the pacakge...

Is there an order of operations issue?

I would assume that you would populate your dimension from your staging table not populate your staging table from your dimension. So, I assume...

I'm not saying this gives you correct results, but integer math returns integer values. Try changing the 8 to 8.0:declare @thisTime decimal(8,2)

set @thisTime = datediff(hh, getdate(), '11/22/2009')/8.0

select @thisTime

Hehe, thanks.. Yeah they changed the wording at some point. My Local BOL says:

TOP ( expression ) [ PERCENT ]

Specifies the number or percentage of rows that are affected...

Florian Reischl (11/11/2009)

---

Yep, looks like. But I have to do some deeper tests to provide a more reliable statement about that. However, as BOL says, MERGE always performs a full...

If you change my WHERE cluase to:WHERE

RowNum = 1 OR Code <> '' OR Location <> ''I think that'll work.

lmu92's solution and mine differ slightly because of there the...

Supriya.S (11/12/2009)

---

@Lamprey13: Nice trick using Row_Number(); going in my file of "SQL tips and tricks" 🙂 It had one issue though, your script ignores the row say when code is...

Here is one other way:SELECT

name,

email,

code,

location

FROM

(

select

name,

email,

ISNULL(code,'') AS code,

MAX(isnull(location,'')) as location,

ROW_NUMBER() OVER

(

PARTITION BY

Name,

Email

ORDER BY

CASE WHEN code IS NULL THEN 1 ELSE 0 END,

code

) AS...

First, I think SQL will handle it, but you should preface your string literal with N for unicode strings. Maybe that'll help?

set @msg= N'C?????'

Secondly, is the display of "C?????" showing...

gboyer (11/5/2009)

---

Now I am not an expert in database design but I would say that is not a good design. Don't you have to define the FK relationship when...