Hi,

Try using numeric datatype.

As-

select ID,

ROUND(convert(numeric(18,1),id),1)

from test01

Good Luck

Hi,

Try this, please remember to cast your parameter.

select * from tablename

where monthColumnName = case when @month='' then monthColumnName else @month end

AND

yearColumnName = case when @year='' then yearColumnName else @year...

Answer given is wrong. I am getting this -

Vyas Mohan

Mohan Shobha

Shridhar Mohan

Sourabh Mohan

Hi,

You can use Filter option so you dont have to too much scroll up and down.

Hi,

text datatype can have maximum length of 8000.

I think you should break your dynamic query into 2-3 parts.

Sorry , i dont know about it. I was replying first time.

Hi,

Try this,

DECLARE @CountGroup INT

SELECT @CountGroup = Count(Distinct GroupID) FROM reminder

SELECT TOP (@CountGroup) id, groupid, MIN(days_remaining) FROM reminder

GROUP BY groupid, id