Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: KH75
  • Order by date
  1. KH75

    How to convert char(date) to date to get noumber of months

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

    How to upgrade 2005 BIDS to 2008 BIDS

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

    How to upgrade 2005 BIDS to 2008 BIDS

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

    How to upgrade 2005 BIDS to 2008 BIDS

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

    How do I solve it

    Thanks for help
  6. KH75

    How do I solve it

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

    How do I solve it

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

    Extract Data From word

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

    Extract Data From word

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

    Business Intelligence Certification

    HI Thanks to reply Can you suggest any book & materials to achieve 70-448 (MCTS) certification? Thanks Kashif BS-Computer Science MCP VB6
  11. KH75

    Business Intelligence Certification

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

    Linksys WRT54G v8

    Thanks again
  13. KH75

    Linksys WRT54G v8

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

    Linksys WRT54G v8

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

    Cross Tab / PIVOTTABLE help needed

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

    Case statement error

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

    Case statement error

    you forget THEN befor columnA
  18. KH75

    Linksys WRT54G v8

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

Part and Inventory Search

Back
Top