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...

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...

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...

what error messge are you getting please?

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

...

Hi...by ADX can I assume you are talking...

raotor (11/10/2011)

---

I've copied your test script into SSMS and executed it. However, it appears to run extremely...

take a look at my sample testrig earlier in this thread.

does this help...

SELECT ID, Name, MIN(Update_date)

FROM <YOURTABLE>

GROUP BY ID, Name

HAVING (COUNT(*) > 1)

Jeff Moden (11/7/2011)

---

adonetok (11/7/2011)

---

The code below will display as '21:30:00 PM'

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) +...

L' Eomot Inversé (11/7/2011)

---

Gianluca Sartori (11/7/2011)

---

Totally different topic: this thread asks how to format datetime values in T-SQL.

I think this is a very bad habit to kick and I...

agree with CC...if you need "total" as well

select country,

COUNT (level) as total,

sum...

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...

is this part of the code correct?...not sure this is what you want.

CASE Datediff(mm, SaleTransferredTS, GetDate())

WHEN 0 THEN 1

...

...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...