Viewing 15 posts - 2,116 through 2,130 (of 2,452 total)
Dear sushilb
based on the spreadsheet you provided, I have taken the liberty to use this as the source for some sample data.
Hopefully.........we can then start to see where your code...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 13, 2011 at 7:56 am
good to hear you have the testrig sorted now.
so back to your original post
However, upon conducting some tests using a simple single column query (I can provide the query and...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 13, 2011 at 6:12 am
I am sorry but if i break your code out...I still get divide by zero errors...
probably best if you can repost your set up scripts, with all the recent amendments...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 13, 2011 at 3:31 am
sushilb (11/13/2011)
I have commented the line which is giving the error
what error messge are you getting please?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 13, 2011 at 2:39 am
your set up script still throws error...it is looking for "EOD_NSE_Stock" in the proc.....please check your code before posting...
ok... I change EOD_NSE_Stock to "NSE_Stock_Data"...now when I run this section
SELECT
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 13, 2011 at 1:10 am
sushilb (11/12/2011)
Sample data to test----create the table NSE_Stock_Data run below query to get the data
------------------------------------------------------------------
--drop table NSE_Stock_Data
create table NSE_Stock_Data
..............................................................--
Hi...by ADX can I assume you are talking...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 12, 2011 at 12:32 pm
raotor (11/10/2011)
J Livingston SQL (11/10/2011)
take a look at my sample testrig earlier in this thread.
I've copied your test script into SSMS and executed it. However, it appears to run extremely...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 10, 2011 at 12:30 pm
take a look at my sample testrig earlier in this thread.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 10, 2011 at 2:41 am
does this help...
SELECT ID, Name, MIN(Update_date)
FROM <YOURTABLE>
GROUP BY ID, Name
HAVING (COUNT(*) > 1)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 7, 2011 at 11:57 pm
Jeff Moden (11/7/2011)
adonetok (11/7/2011)
How to modify code to display as '09:30:00 PM'?
declare @date datetime
set @date = '2011-11-08 21:30:00.000'
select CONVERT(VARCHAR, @date, 108) +...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 7, 2011 at 11:27 pm
L' Eomot Inversé (11/7/2011)
Gianluca Sartori (11/7/2011)
I think this is a very bad habit to kick and I...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 7, 2011 at 12:22 pm
agree with CC...if you need "total" as well
select country,
COUNT (level) as total,
sum...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 7, 2011 at 11:29 am
try this...hopefully it meets your specific requirements:
declare @date datetime
set @date = '2011-11-08 21:30:00.000'
select convert(varchar,@date, 103) --- change 103 to 101 if mm/dd required
+ ' '
+ CONVERT(VARCHAR(30), Dateadd(HH, CASE WHEN...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 7, 2011 at 10:38 am
is this part of the code correct?...not sure this is what you want.
CASE Datediff(mm, SaleTransferredTS, GetDate())
WHEN 0 THEN 1
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 7, 2011 at 9:26 am
...ok, so assume you havent got a solution yet?
can you post the table "create" script.....maybe we can generate some sample data for you.
In SSMS...right click on your table > Script...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 5, 2011 at 11:06 am
Viewing 15 posts - 2,116 through 2,130 (of 2,452 total)