AT TIME ZONE

Union Date/Time Data Types

Time zones

Convert Months,Days,ShortMonths to different Languages

Convert Months,Days,ShortMonths to Different Langauges with out sql server set language function can be used in views tables and stored procedures also includes proper case conversion

Date Conversions

RE: subtraction of column doesn''''t work correctly

Thanks Jeff I changed the column to a decimal in the table but I am still having the same problem. Should I format the Profit column that gets created in the query? Does it have a default data type if you don't specify one?  The Profit column isn't in any of the views I reference it is created only in […]

RE: Print in DTS Package

If you don't have access to VB and it is an ActiveX Script you can use the MsgBox to display values at given points.

sp_addsubscriber - What permissions does login need?

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

CDOSYS, CreateMHTMLBody and Stored Procedures

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

RE: Edition of RS/SQLServer2k

I was unaware that there were different versions of RS, a co-workers of mine downloaded the version for me (turns out to be the Developer Edition).  Here's the EULA displayed when I installed RS.Microsoft SQL Server 2000 Reporting Services, Developer Edition...1.   General.   The accompanying Microsoft software includes computer sftware and may include associated media, printed […]