It looks as if it is the date that's the problem, then. Have you tried changing the double quotes to single quotes?

John

OK. Did you get any error message? What was in the columns that were not inserted to? Are there any triggers on the table? What is...

I don't understand. If the difference is in date formats, why have you highlighted values that appear to represent sums of money? Please show us what the query...

The thing about using temp tables is that it will materialise the whole of the "view". With a CTE, it will only take out what you need.

Consider the following

SET...

One way of doing it (not necessarily the most efficient or most secure) is to use xp_cmdshell to run the dir command in the folder your backup files are in....

Use sp_who2. It's an undocumented stored procedure similar to sp_who, but it provides more information.

John

Anirban Paul (4/18/2008)

---

select [id], max([order])

from #a

group by [id]

order by max([order]) asc

The above T-SQL statement is wrong. You required Group By clause as you are using MAX function. The statement will...

Use the first query, but put the column name in brackets in the third row, the same way you did in the first.

By they way, if you are going to...

Have you posted all of your code? If so, what is it supposed to do? It fetches the results into the variables, but then moves on without actually...

The first thing I would try is getting rid of the semicolons. I don't think they're strictly necessary.

John

What is your stored procedure trying to do? The code you have posted only creates and populates the temp table. It doesn't do anything with it. If...

Use the HAVING clause so that you only return results with sum = 0. Then join that result set to the original table to get the rows that...

sp_helptext should give you what you're looking for. But you may have to grant your user higher permissions than it already has - check out the Permissions section of...

Helin

It's not something I've done before. But one thing you could try is to monitor the sys.dm_exec_requests view and check that cpu_time and/or logical_reads are increasing all the time...

Just because you can put it all on one drive, it doesn't mean you should. For optimum performance, you should put data and log files on physically separate disks....