Temp table is useful, if you want to supply the same table/data in the next calling procedure in the hierarchy.

Yes you are.

You need to create temp table & use it to store the return resultset of stored procedure.

CREATE TABLE #tempTable

(Col1 NVARCHAR(MAX),

Col2 NVARCHAR(MAX)

)

INSERT INTO #tempTable

EXEC procSample;

Hope sample...

Hello,

Please take a look at below query:

SELECT orders.OrderID,

[Order Details].ProductId,

( [Order Details].Quantity * [Order...

Use this one:

SELECT 0 AS RecordStatusID

,LEFT(COALESCE(STOCK.postcode + N'/','') + STOCK.address1 ,30)AS ShortName

,STOCK.ADDRESS1

...

Hello,

I am able to resolve the issue.

select id, boss_id, managername, title, changedate, changetime, ROW_NUMBER() OVER (PARTITION BY id ORDER BY id) rownumber

into #temptable

from @t order by id

select * from #temptable

select...

Can you please send me the query example?

Query is dynamically created and I have executed it using sp_ExecuteSQL, also there are other tables in the FROM clause (joins) so not able to change the query.

That was a sample XML and function which I am using to parse the XML and return the data.

When XML has small numbers of data (suppose 2 to 3 records),...

Jacob, please find sample XML & its parsing function:

declare @XMLdata XML

SET @XMLdata =

'<XmlStart xmlns="http://abc.com" xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns:a="http://hd.com">

<data>

<a:Col1>

<a:col1Data>

...

Yes it is inline function. Function returns the table.

CREATE FUNCTION hdFunction ( @XMLdata XML )

RETURNS @Datatable TABLE

(

Col1 SMALLINT

...

Thanks Jacob for your quick reply.

I have checked that query is running perfectly fine and it is retrieving the data within 3 seconds but when I am using the ...

Hello,

Thanks for your post. It is really useful.

Currently I am facing an issue related to performace if XML is huge (nearly about 1 MB in size - 200 records). I...

If possible restart your sql server service