Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anandbohra
Starting Member
4 Posts |
 Posted - 2007-06-12 : 04:28:27
|
| hi all i am totally new to SQL (just started classes) but familiar with EXCELso i am trying to use EXCEL as front head & sql as data storage. EXCEL will fetch data from sql in Pivot table or through connectivity.now coming to the point my query isin SQL table i import this file Daily (no change in format every thing is unique means no replication of scrip in a daydata will look like (if you aware about NSE cash market bhavcopy in CSV)Scrip--type--Closeprice--timestamp (only few which i need) ABB--EQ--500--01/01/2007 (Eq is for Equity & gs stands for Govt. sec)ABB-GS--100-01/01/2007 (means no replication in a day)next dayABB--EQ--550--01/01/2007ABB--GS--90--01/01/2007so on i will import the bhavcopy in SQLnow i want one report which shows meScrip--% ChangeABB--EQ--10ABB--GS--(-10)how to achive the same.hope this will be left hands job for genius people like youi can do in excel but excel is not for data storage that is why i start taking interest in SQLAnand Manmohan Bohra |
|
|
|
|
|
simple % return required