ANSI_PADDING, in older versions, referred to whether trailing blanks shoud, or should not, be retained in varchar columns. If 'ON', then they would be retained. If 'OFF', they would be...

In your logic, you are declaring @newProjectId, then immediately using it in an INSERT statement. It has NOT been assigned a value at that point. What value to you think...

R.P.Rozema (8/18/2011)

---

It's a fairly obvious one, but have you tried this?

alter PROCEDURE [dbo].[brw_Rec]

@rId numeric(18,0),

@rId2 numeric(18,0) = NULL

AS

BEGIN

SELECT RID,PA_ID

...

Sorry. Missed the second column in the first query.

Unfortunately, Mike John's SQL will also return 0 if there are any spaces in the column. This can be solved by replacing LEN with DATALENGTH.

Thanks, Sean, I didn't even notice...

If you have 'L / S', with a space before and after the '/', do you want to replace the '/' with a space, or just remove the '/'? The...

My apologies, Lowell and Armando. It's been a while since I read the entire entry for BCP comand options.

I use BCP quite often, and have run across this before. Other...

Review the "BCP" entry in Books Online.

-c controls the output of data - in this case, "character."

-r controls the row delimiter

-c -r /n

Review the "BCP" entry in Books Online.

Everything you...

Review the "BCP" entry in Books Online.

What you want is "-r /n" (without the quotes).

If ANSI_PADDING was set to 'OFF' when the table was created, trailing spaces are removed from varchar columns when values are inserted or updated. This also applies to varbinary columns...

Since your WHERE clause specifies a value for the 'c' table, your LEFT JOINs effectively become INNER JOINs, in that the value from the 'c' table MUST exist. You...

Thanks, Paul!

Will do. Good advice...

Ah! Thanks! That's the missing piece of the puzzle. I don't have access to the .NET logic, which is where the transaction would be controlled. I'll...