Exec Sp_ExecuteSQL @SQL 1

[LeonelSanchezJr]

I get the following error:

Cannot convert parameter '@statement' to ntext/nchar/nvarchar data type expected by procedure.

when I run my stored procedure below. Of course the code below is just the portion of the stored procedure which gives me this error.

Declare @SQL VarChar(1024)
Set @SQL =
'Select
Hawb.cHawbNum
, Hawb.dShipDate
, Hawb.cOrigin
, Hawb.cDestin
, HawbDetail.cCustcode
, HawbDetail.dDueDate
, #TmpHawbsNoDoc.cDocType
From Hawb (nolock)
Join HawbDetail (nolock) on Hawb.cHawbNum = HawbDetail.cHawbNum
Join #TmpHawbsNoDoc On Hawb.cHawbNum = #TmpHawbsNoDoc.cHawbNum
Order By ' +
Case @cDocType
When Null Then 'cCustCode, cOrigin, dShipDate'
When "INLND_BL" Then 'cCustCode, cOrigin, dShipDate'
When "PO" Then 'cCustCode, cOrigin, dShipDate'
When "HAWB" Then 'cCustCode, cOrigin, dShipDate'
When "POD" Then 'cCustCode, cDestin, dShipDate'
End

Exec Sp_ExecuteSQL @SQL
GO

 

[tlbroadbent]

Change the declare statement as follows.

Declare @SQL nVarChar(1024)
Terry

http://members.home.net/tlbroadbent/prog.htm

------------------------------------
Experience is the hardest kind of teacher. It gives you the test first, and the lesson afterward.