if i use correlated subquery, and join to two table.

what way should i choose for optimal performance when there large number of rows.

For Example

--************Retrieve a value from any one-table...

oh, it's my bit mistake that i use nvarchar to cocatenate with varchar variable. but it's not a problem because some value that loose is not in the WHERE clause...

Thank so much,

that you tell me about the solution.

I also do the same of yours to complete the crosstab-report, but something that i want is to know why it's process...

oh, no it's just brief explanation so you can see detail below.

Alter Proc rsp_IC_PackingList_CrossTab (@po_no nvarchar(32))

AS

BEGIN

DECLARE cShips CURSOR FOR

SELECT ShipmentDate,Id From tab_ic_packing_list_shipment

WHERE PackingListNo=@po_no

ORDER BY 1

Declare @sql as varchar(...