Thanks! I'll look it over.
> -----Original Message-----
> From: janet [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 18, 2008 02:59
> To: [email protected]
> Subject: RE: Witango-Talk: User defined SQL function
>
> Hi This is a stored procedure I use but you can use the
> syntax in a Direct to DataBase action
>
> UPDATE physio.re400
> SET re400datetosecs = DATEDIFF([second],
> '1970/01/01 00:00',
> re400startdate)
> FROM physio.v_patient_info_noRE150 v1,physio.re400
> WHERE (v1.id_pa100 = physio.re400.id_pa100authztn)
> AND (v1.id_de300orgdep=@@de300)
> AND (id_pa100authztn = @@pa100)
>
> -- If you try to make dateToSecs COMPUTED column it will fail
> -- Unable to modify table.
> --Computed column 're400datetosecs' in table 'Tmp_re400'
> --is not allowed to be used in another computed-column definition.
>
> -----Original Message-----
> From: Tom Ferguson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 18, 2008 1:18 PM
> To: [email protected]
> Subject: Witango-Talk: User defined SQL function
>
> Does anyone have/use a UDF for MS SQL that works similarly to
> the <@datetosecs> Witango metatag?
>
> I'm not smart enough to write one. LOL!
>
> TIA
>
>
> Tom Ferguson
> ______________________________________________________________
> __________
> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
> ______________________________________________________________
> __________
> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
>
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
