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...
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.
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
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...
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 =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.