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
the table in csv format issee below
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
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...
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...
It gives me error DBname..spname has no column names varcharparameter error(7357)
what to do????
I have linked the server
For selct statement i know
I have to do
Select * from openquery(servername ,'Select * from ShareMarket')
But how to...
How to call stored procedure from from Sql Server on another with parameter
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 )
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
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.