Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
DECLARE @StartingDate smalldatetime DECLARE @EndingDate smalldatetime DECLARE @StockID INT DECLARE @DAYS INT DECLARE @AG FLOAT DECLARE @AL FLOAT DECLARE @RS FLOAT SET @StartingDate = '20110215' SET @EndingDate = '20110309' SET @StockID = 107 SET @DAYS = 14 SET @AG =( SELECT SUM(Last-Prev) FROM Feed_Quotes_Details_Closing WHERE StockID = @StockID AND (ValueDate BETWEEN @StartingDate AND @EndingDate) AND (Last-Prev)>0 )/@DAYS --SELECT @AG AG SET @AL =( SELECT SUM(Last-Prev) FROM Feed_Quotes_Details_Closing WHERE StockID = @StockID AND (ValueDate BETWEEN @StartingDate AND @EndingDate) AND (Last-Prev)<0 )/@DAYS SET @RS = @AG/ABS(@AL) SELECT 100 - (100/(1+@RS)) RSI
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL 2016: choose separate instances for software install; performance||19||24|
|MS SQL Sever Import/export problem||7||51|
|Building JSON Results Table FROM DB||9||37|
|T-SQL: Need Group By to use "fuzzy logic"??||3||23|