Sure, you can PM me if you want.

Still not 100% sure what the problem is - screenshots would be nice - but I'm getting a hunch.

CSV is a simple plain text file. Since carriage returns are row...

If you want to run this every month, you'd need some sort of scheduling.

By the way, if you truncate the table it is already reseeded, so you don't need the...

You need to use the data type datetime2 for this.

The data type datetime has a precision only up to 3ms, so there's no .999 precision.

tommy.tooten (9/12/2013)

---

It is no problem 🙂 You do not have to install any new drivers or providers to connect to SQL Server 2012. You can use the SQL Server Native...

What do you mean with "it looks terrible" and "not displayed correctly"?

What is the problem?

(we cannot see what you see)

Nice question Steve, thanks.

Maybe your post should focus more on the fact that this bug is already resolved.

The fix can be downloaded here:

Non Security Update for SQL Server 2012 SP1 (KB2793634)

Does the SQL Server Agent account have permissions to open the file? Or are you using a proxy?

Probably looking at the actual exection plan will provide you with the answer.

No idea,...

Since you already know SSRS and some T-SQL, SQL Server seems the obvious choice, but I don't know how the market is at your place.

Oracle developers tend to get paid...

Does Redgate SQL Data Compare not give you the option to sync?

Another option to quickly generate insert statements for a table is to right-click on the database, select tasks and...

Vobr Jiri (9/11/2013)

---

In SS2k you must use in T-SQL script this version:

INSERT @i VALUES ('Steve')

INSERT @i VALUES ('Stephan')

INSERT @i VALUES ('Stephanie')

INSERT @i VALUES ('Sterling')

INSERT @i VALUES ('Steppenwolf')

Then are 4...

Which events did you log?