David (4/8/2009)

---

Flo, I managed to do it by following Bob's...

Hi Vijaya Kadiyala

Thanks for confirmation! 😎

Greets

Flo

Hi Jonathan

OPENXML is marked as deprecated in SQL Server 2005. It will be removed in future version. You should...

Lowell (4/8/2009)

---

Florian thanks for your function;

one format, the ISO one, is really handy for me, as I have to do a lot of that conversions;

ISO8601 (XML) ...

Lowell (4/8/2009)

---

florian i named it with sp_ on purpose in this case, and then placed it in the master database; that way i can call it from any database i...

Hi Lowell!

Lowell (4/7/2009)

---

lots of questions hit SSC on formatting dates to a certain format; the procedure below, sp_dates is really handy to just get that information, as well as the...

So here is my formatting function 😉

It's another concept than Lowell's but might also help in some cases. Keep in mind, if possible use CONVERT due to a much better...

Duplicate post: http://www.sqlservercentral.com/Forums/Topic692873-149-1.aspx

You're very welcome!

Greets

Flo

Hi

SSIS web casts at MS:

http://www.microsoft.com/events/series/bi.aspx?tab=webcasts&id=42664

... maybe anybody knows better.

SSIS start page at MSDN:

http://msdn.microsoft.com/en-us/library/ms141026(SQL.90).aspx

SSIS tutorials at MSDN:

http://msdn.microsoft.com/en-us/library/ms167031(SQL.90).aspx

Greets

Flo

Hi

Just remove the doubled "'" within the brackets:

sp_MSforeachdb

'

ALTER DATABASE [?] SET AUTO_CLOSE OFF WITH NO_WAIT

'

To avoid any errors you have to exclude at least the master and tempdb. I would...

Hi

To your error:

Seems that you call your procedure without the @forename parameter.

To your problem:

Some more information would be helpful:

* Are the 4 (source + 3 destinations) same structure?

* Could you...

Hi

The 2^n-1 logic comes from old systems because the last character was a 0-character which terminated the string. New systems usually do not use this termination and are optimized to...

No cross posts...

http://www.sqlservercentral.com/Forums/Topic692311-149-1.aspx

... another reason why the name "TIMESTAMP" should be removed:

In ODBC the SQL Server DATETIME is mapped to type...