NJ-DBA (8/21/2011)

---

yeah, was a restore across the network using netbackup. netbackup just got "the connection was forcibly closed by the remote host".... thing is, we restore this way lots...

Please have a look at the first link in my signature and post ready to use sample data together with your expected result.

For sure, there is a set based solution.

Exactly the same results on my (test) instances (both on the same machine):

Microsoft SQL Server 2005 - 9.00.4060.00 (Intel X86) Developer Edition, (Build 2600: Service Pack 3)

Microsoft SQL...

You'll need to be more precise what you're looking for.

"Table space used in...

@tim-2:

Varchar without any length specification woud use a default of 30, which is oversize for the given task. Depending on the requirement how to display more than 24hrs (or 100hrs...

something like this?

SELECT DATEADD(mi,yourColumn,'19000101')

I'm not sure if I'd go that route and update the original BankDepositNumber. I'd rather either add another column to the original table or even a separate table that would...

It seems like the index in stage is totally fragmented. This leads the query optimizer to the conclusion that the index (being good enough in test) is not good enough...

Based on your description, the code does exactly what you're looking for: "two distinct query's and i want to insert the results into one temp table".

Separate INSERT statements will add...

Please don't hijack a thread.

The issue you describe is not even related to the subject discussed in the original thread.

Ask your question using a new thread in the SSIS section....

Ich habe keine Ahnung, ob dieser Link einen Bezug zum Thema dieser Web-Seite hat. Auf...

sauraviit-689328 (8/14/2011)

---

IN my case i have to create this much xml data . My i am getting this error "XML operation resulted an XML data type exceeding 2GB in size....

To expand on Flo's solution, performance is usually much better when using the CROSS APPLY approach if there's the need to return values from different node levels.

SELECT

...

Sachin Nandanwar (8/14/2011)

---

...

Just because you define it as a "Best Practice" and it gives me an overhead in maintenance then surely I am better off in not using those...

kumar1 (8/12/2011)

---

@ninja's_RGR'us: Thanks very much for this solution. I am working closer with this solution.

@Kurt W. Zimmerman: You are obsoltely right.I have done similarly before but used waitfor delay option.

Thank...