Have a look at the CONVERT topic in Books Online. This gives you all sorts of date formats.

John

Steve

Anything that changes your database in any way will cause your log to grow: DML statements, DDL statements, reindexing, TRUNCATE TABLE, bcp, BULK INSERT....

John

There could be a Windows or third-party scheduler running stuff on your SQL Server. Try setting Profiler to start at 3:09 in the morning and capture what happens.

John

You'll need to speak to whoever wrote the asp.net C# code in order to get the dynamic SQL generated in the way you expect it.

John

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...