.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

FROM db2 TO sql

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :Sql Server
 
this is part of a stored procedure that I need to convert to sql - it is called in sql to db2 db via openquery but this function need to be parsed and made to loook like something in sql leaving the dbd db out... , VARCHAR( CASE WHEN HOUR(pf.NXT_DAY_APRV_DTS)>12 THEN HOUR(pf.NXT_DAY_APRV_DTS) - 12 ELSE HOUR(pf.NXT_DAY_APRV_DTS) END) || '''''''':'''''''' || LEFT(''''''''00'''''''', 2 - LENGTH(VARCHAR(MINUTE(pf.NXT_DAY_APRV_DTS)))) || VARCHAR(MINUTE(pf.NXT_DAY_APRV_DTS)) || '''''''' '''''''' || CASE WHEN HOUR(pf.NXT_DAY_APRV_DTS)>12 THEN ''''''''PM'''''''' ELSE ''''''''AM'''''''' END APPROVAL_TIME


View Complete Post


More Related Resource Links

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend