Disclaimer: I'm not sure if I got you right 😀

Yes, you can use the SQL Server procedure xp_cmdshell to execute your tool, but I wouldn't suggest to do this from...

Hi

As always, it depends. If "abc" is not needed in each query, then it is definitely a good idea. I suggest to read one of the last SSC articles Speeding...

Hi

I don't get any error when testing your sample data.

; WITH data (EmpNo, HoursWorked) AS (

SELECT '00532210',...

Hi

In this scenario it is a bit different. I thought you create the temp tables directly from SSMS or a client application....

Hi craig

No, that's not possible. The vice versa could probably be done with SQLCMD mode.

Greets

Flo

Hi

Call me the devils advocate but the temp table will not be dropped when the session becomes closed. It becomes dropped when the connection becomes closed or the session becomes...

nikk,

Good books are cheap. Independent on its price, the knowledge it will give you is priceless ;-). It...

ananda.murugesan (8/20/2011)

---

Hi Florian Reischl, One more help require from your side.

There were 76 non-clustred Index created in sql 2000 as of now data pages and index pages are same MDF...

Hi

ananda.murugesan (8/20/2011)

---

By this way corrected myself and inform to devlopement team to change the query at application side. but he is not using any view and SP, directly using asp...

Hi

Seems like SQL Server 2000 had a bug with column name referencing in ORDER BY clause. I suspect your table "desktop_info" has no column called "mac", does it?

If not, change...

Hi

Don't remove the whole ORDER BY. If it was needed on your SQL Server 2000, it will still be needed on your SQL Server 2008. Remove only the brace ")"...

Hi ananda

Just remove the last brace "order by d.mac,d.hostname )"

Greets

Flo

Hi Lance

You could use the DATEPART function to do that, but I'd suggest to do this kind of formatting in the front end application.

Greets

Flo

Hi

You don't need the leading 'N' if you already get the data as variables. But you need to define your variables in your procudedure as NVARCHAR, like in your table.

Greets

Flo

It's because I used a INNER JOIN by "c1.RowNum = c2.RowNum - 1" in my example. Change it to a LEFT JOIN and you will get all rows. In this...