Thx in advance
/MiZzaYou can get SQL to make COM style calls...look up extended procedures. However, you'd still need a way to identify what the calling application was.|||Main stored procedures to use:
sp_OACreate - Creates an instance of the OLE object on an instance of Microsoft® SQL Server?. (e.g. COM component)
sp_OAMethod
sp_OADestroy
Support stored procedures to use:
sp_OAGetErrorInfo
sp_OAGetProperty
sp_OASetProperty
sp_OAStop
Hi Engine room.
I want to automatically populate an alternative date column with hijri (Arabic) dates. So I will have two date columns in my datawarehouse table, one is for gregorian dates, the other for the equivalent in Hijri - a bilingual date system if you like. Now I guess I could do it in the SSI ETL tool and use Julian Dates, but the problem is storing the resulting value. - what data type should I use for hijri dates?
The dates can be input by the user in either format, which means the alternate date has to be populated.
Eventually I hope to make a bilingual system, I don't understand the user-defined types or how to define them, but I suspect they could be used in someway to help. Why am I doing this? - well eventually I hope to populate a cube for analysis and deliver a dual-language-dashboard using the new CTP3 stuff.
Any suggestions on how I can make this dual-date system? - with a view to making a bilingual system eventually.
adv(thnx)ance..Mark.
HijriCalendar is one of the Calendars defined in the .NET FCL(framewor. class library) so you can use either DateTime or INT to store it. The actual calulation start with MSDN Middleeast to see if code exist for it if not you have to look for code to do it. The links below will take you in the right direction.
http://authors.aspalliance.com/aspxtreme/sys/globalization/HijriCalendarClass.aspx
http://www.microsoft.com/globaldev/getWR/steps/wrg_clndr.mspx
http://www.microsoft.com/middleeast/msdn/
