I have three scheduled at 7 pm at nightMy daughter changed the system time setting to 2011 which i noticed later and rectified.However the jobs now...
the table in csv format is INSTRUMENTSYMBOL EXPIRY_DTOPENHIGHLOWCLOSETIMESTAMP FUTSTK3IINFOTECH30-Apr-0933.0535.432.834.71-Apr-09...
the table in csv format issee below
Hi , I download data in csv format. The data has futures quotes for 3 months with following rows Symbol , expiry date , open ,high ,low, close,...
I have a table with following fields Date closePrice symbol I have to calculate % change in Closing Price compared to prvios day price for all...
This happend only in my production machine No other process is running on that. Same database in my other machine returns data in 6 secs when many...
REATE TABLE [dbo].[EODQuotes] ( [SYMBOL] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [OPEN] [char] (10) COLLATE...
Hi, I have SQL SErver 2000 The database consist of 2 tables Table 1 having details like company name,code etc. The second table the important one...
Hi, It gives me error DBname..spname has no column names varcharparameter error(7357) what to do????
Hi, I have linked the server For selct statement i know I have to do Select * from openquery(servername ,'Select * from ShareMarket') But how to...
Hi, How to call stored procedure from from Sql Server on another with parameter thanks
Hi Frank , I am planning to have a table listing the days shares are traded (since in our exchange sometimes trading is done in saturdays ) Even in...
Table example ACC 29/6/2005 360 ABB 29/6/2005 1000 TISCO 29/6/2005 480 ACC 30/6/2005 363 ABB 30/6/2005 980 TISCO...
Hi, I need a query to do the following. I have a table which has stock name, stock symbol,date and close price. Stock symbol and date are primary...
Separate names with a comma.
