Search results for query: *

Hi I have text columns date1 = 20135 (2013 is year and 5 is month) date2 = 20109 (2010 is year and 9 is month) I want to convert text in to date to get the number of months I am using proc sql any idea how to do this in proc sql? thanks

Hi I have SQL sever 2005. I just want to update BIDS (SSRS,SSIS,SSAS) but not the complete SQL Server. Is it possible? Please guide me how I can achieve it. Thanks

I want to make a query to retrieve active client from different areas any client that is active in Cities (‘A’,’B’,’C’,’D’) as well as (‘X’ or ’Y’)? any client that is active in Cities (’E’, ‘F’,’G’,’H’) as well as (‘X’ or ‘Y’)? I write Where (( OrdDate Between FromDate And...

Hi I have lots of Ms word files in a folder. I want to extract E-Mail address from these word file. Is it possible through SSIS Thanks in advance

Hi It is much appreciated that can someone tell me about 1) What is the market value of business intelligence now-a-days 2) Is it worth while doing it or not ? Which BI Cert is better for me? 70-448 MCTS: SQL Server 2008, Business Intelligence 70-452 MCITP: SQL Server 2008, Business...

select CONVERT(VARCHAR(2), B.BILLDATE,101 ) BILLDATE, B.BILLAMT , b.sourceord , taro.client_id from [billing] as b with (nolock) inner join [orders] as srco with (nolock) on (b.sourceord = srco.order_id) inner join [funders] as fs on (srco.funder_id =...

Hi I have XP. few days before I am unable to open yahoo mail. when I enter my password my adrres bar start changing. Now I am unable go any web site Any help/idea please. I am unable to go any website other wise my pc is working fine. thanks in advance

Hi I am using CR 11 and Sql sever 2005 Blank Main report has 2 subreport I have 2 stored procedure parameter @cMonth int @cYear int I create same parameter in the main report strored procedure is attached with both sub report Parameter type in CR is showing Number and my SP Parameter is...

Hi In crystal it shows 10.25 25.65 100.00 3500.00 I have data like this totAmount 10.25 25.65 100 3500 I want it same like above Thanks in advance using crystal XI

Hi I am a Crystal Report Developer. I want to upgrade Query/Stored Procedure skills for reporting purpose. What about Exam 70-433: TS: Microsoft SQL Server 2008, Database Development or some other course Any suggestion. Thanks in advance

Hi I am using CR-XI I have a crystal report chart which displays the field name in the Legend. Is it possible to change the legend Legend is showing @YearSale I want Sale of 2009 I want to concatenate with parameter value like "Sale of" & @formula1 Please help me Thanks Haqqani

Hi I am using CR-XI I have a crystal report chart which displays the field name in the Legend. Is it possible to change the legend Legend is showing @YearSale I want Sale of 2009 I want to concatenate with parameter value like "Sale of" & @para1 Please help me Thanks Haqqani