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

Top 5 Contributors of the Month
Gaurav Pal
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

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