Indianrock (2/21/2008)

---

I'll have to dig for solid evidence...

Yep. It's actually worse because the introduction of...

From a security stand point, less is more. Here's a great white paper from MS that details all sorts of security best practices, not the least of which is masking...

Sorry. I'm not terribly familiar with bcp.

There is no immediate if statement in TSQL. You'll need to create some other mechanism, probably a CASE statement to get the same effect.

SELECT CASE WHEN CurrentSickTerm= 'LT'

THEN 'Long Term'

ELSE...

It's probably a permisssions issue. XP_commandshell is going to run under the security context of the sql server instance where as your command prompt is going to run under your...

First, why are you using dynamic sql here?

You can simply do this:

ALTER PROCEDURE sp_Sample

(

@Empid nvarchar(100)

)

AS

Begin

SELECT * from Employee WHERE empid= @Empid

end

Go

But, if there really is a reason to...

Holy moly. Referring back to my statement, after having seen this code, I wish to refine my original estimate.

Nope. Won't scale. Next.

BTW, I reformatted the query so I could actually...

Well, first, seperate derived tables & CTE's from temp tables & table variables. They are totally different critters. Derived tables & CTE's are constructs that exist within a query statement...

Well, it depends. If you have a TSQL script open, it should work just fine (just tested it to reconfirm). If you don't have a script open, the replace window...

I'm not the admin expert that configures our servers, but I do know the guy who does it sets the memory allocation to a fixed amount. Dynamic memory is primarily...

Can you post the full execution plan? You might be hitting the scan because of other things within the query, such as performing functions on the columns then using them...

I'm not sure, but it sounds like you might be talking about execution plans? These show what the optimizer and query engine will do with the code that you wrote....

Yeah, it only takes one row.

Using my code sample

UPDATE [ATI].[dbo].[IV00101]

SET ITEMDESC = x.ITEMDESC

,ITMSHNAM = x.ITMSHNAM....

FROM [AMCHR].[dbo].[IV00101] AS x

WHERE x.[ITEMNMBR]=[ATI].[dbo].[IV00101].[ITEMNMBR]

AND x.ITEMDESC IS NOT NULL

fred (2/19/2008)

---

I am having a little problem with my update query. I get the following Error msg.

Msg 515, Level 16, State 2, Line 1

Cannot insert the value NULL into column...