I got the solution. Hope it helps someone else.

select

CollectionUrl

, MAX(LastAccessedDate)

from dbo.tracking

group by CollectionUrl

having DateDiff(dd, MAX(LastAccessedDate), GETDATE()) > 60

Thanks. Somehow I missed thinking from that angle. The following query worked fine for me.

Insert Into courseProgress (userId, classId, classParamId, status)

select empTraining.userId, empTraining.classId, classParamDetails.classParamId, (CASE WHEN appCategory = 'Eq....

Thanks, Maxim. It worked. I wrote sql joins before and I never encountered this issue with condition in where clause. As far as I remember, Left Join and Right Join...

My mistake. The column title is from the query, itemId (not categoryId).

I gave more thought on this and came up with some ideas.

The material expression would be evaluated as follows [where op is AND/OR].

((((m1 op1 m2) op2 m3) op3 m4) op4...

I am not using any Stored Procedures.

Its because of the SQL Server behavior. If you try to put '' into a column of int datatype, SQL Server puts a default...

Here is the whole Insert statement

Insert Into catalogItems (categoryId, itemPrice, supplierCompanyId, itemDeliveryDays, itemLimit) Values ('${param.category}', NULLIF('${param.itemPrice}',''), '${param.splrCompany}', '${param.delDays}', NULLIF('${param.itemLimit}',''))

itemPrice is of float datatype and itemLimit is of int datatype. If user did not...

Used NULLIF(column-name, '') and that helped in converting '' to NULL.

I was able to resolve my problem using NULLIF. Thanks.

The Column allows NULLs and there is a default value of (null) for the column. There are no triggers. Also, There is no default value in the insert statement. I...