No - the syntax coming out of your dynamic SQL is incorrect. correct syntax is

[somecolumn] = somevalue or [somecolumn] is null

You can't...

Lynn Pettis (2/18/2010)

---

Matt Miller (#4) (2/18/2010)

---

Lynn Pettis (2/18/2010)

---

First, make sure you have at least two ways to login with sys admin rights. One way is to have a group...

Lynn Pettis (2/18/2010)

---

First, make sure you have at least two ways to login with sys admin rights. One way is to have a group created and have the DBA's...

You've still got a problem here:

deptmaster as

(

select

dm.Company, dm.Acct_Unit, dm.Description, dm.Dept_Type

From dbo.Dept_Master_old dm

inner join dbo.Dept_Master_old ON fa.Acct_unit = dm.ACCT_UNIT

)

Notice two problems:

- you're linking a table to itself, but...

Anam Verma (2/16/2010)

---

hi Jason

I am using T-SQL for data transformation. I think i have confused everyone on the forum.

Let me rephrase what i am doing. I have a source...

There's a rather distinct difference.

If you were to "translate" your colleague's way to your notation, it would be:

IF @Var1 Is Null OR @var1='SomeValue'

exec someSP

ELSE

Exec SomeOtherSP

That's essentially an entirely different possible...

on #3, the thing to look at closely is how Books online defines a LEFT OUTER JOIN. Per BOL:

Specifies that all rows from the left table not meeting the...

like2innovate (2/15/2010)

---

Currently I intend to refer to "Beginning SQL Server 2008 for Developers From Novice to Professional" by Robin Dewson (Apress publishers) while using SQL 2008 Developers Edition. Just wondering...

steve dassin (2/16/2010)

---

What does relational theory have to do with sql?:-) The problem is...

You're looking to do some form of Dynamic SQL. In other words - you will have to build the SQL statement in a varchar variable, then use EXEC or...

The joys of null!

NULL is not a value, so as such, NULL is neither equal nor not equal to any value. Unfortunately, that also means that it's not LIKE...

stan.teitelbaum (2/15/2010)

---

Thanks Jeff.

That's my point. If something can generate both a negative and positive number 2, they may look random but abs reverses that effect.

Also, it seems to us...

Your conclusions are actually backwards. The first one returns NULL, the second one returns nothing. Run them separately.

Are you sure you're not looking for something like the xml.nodes() method from the SQLXML functionality? This does allow you to pass in a single XML datatype, and split...

Are the two SQL Servers in the same domain? The errors you've posted kind of imply that they are not, in which case "in the same context" is not...