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 uninstall my SQL server 2005 through control panel and try to install 2008 standard edition. when I click on setup file it gives me an err [highlight #EF2929]Managed SQL Server Installer has encountered a problem and needs to close. we are sorry for the inconvenience[/highlight] can you...

Thanks

Actually I want to create reports and ETL in SSRS/SSIS 2008 for learning. I have XP where I can find SS2008 Client Tools 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

Thanks for help

Thanks for help. any client that has active order within a time frame(parameters) for group 1 Cities and group 2 Cities 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’)? 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 Thanks for reply What word version? If it's a later version is the file a docx file or .doc These document are mixed with *.doc and *.docx extesion How is the address held? Address usually at the top of first page in middle Is it the only text in the document? No Is it im the middle...

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 Thanks to reply Can you suggest any book & materials to achieve 70-448 (MCTS) certification? Thanks Kashif BS-Computer Science MCP VB6

Thanks

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...

Thanks again

Hi Thanks for replying me In the manual ifound 'External, 12V DC, 0.5A' Thats why I purchase it. Thanks

Hi I am sorry i bug you again. I don't know what happend with my Wrt54G router it is not working. I lost its power adopter during moving and I purchase a new power adopter 12-VDC 500MA but it is not working, any way. please can you suggest me any 2 routers and how can I make a wireless...

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 =...

declare @value1 int set @value1=2 select * from table1 where 1 = CASE WHEN @value1>1 then columnA ELSE 1 END

you forget THEN befor columnA

Thanks I will try next week. because this week i am out of city thanks again