No usable sample data, so I can't test it, but this should give you the results you want:

SELECT $month_of_year, $day_of_month,

SUM(CASE WHEN status ='success' THEN 1 ELSE 0...

• This reply was modified 6 years, 4 months ago by ScottPletcher.

True, but even better would be...

True, but that table only has 75K rows.  Create an index with only CommodityID and CommodityName and, yes, SQL will still have to do an index scan, but the overall query...

To help resolve this problem across the board, for all your queries, you really need to re-cluster the CommoditySupplier table.  This is a classic case of the "default clustering by...

WHERE DS.IsActive = 4 AND Std.DepartmentId IS NULL

Estimating the space requirement for database restores from the backup size can be really misleading.  One of the largest problems in this area is that free space in the...

Be aware, too, that an int column could require up to 10 bytes to store its value.  It's not safe to limit your result from this column to just 8...

Now, multiple online articles suggest to use only when data is huge and not for small amount of data

To put it simply, that's just wrong.  If you need to create...

I'd suggest always using SET XACT_ABORT ON.

(1) Otherwise, you can't be sure which part(s) of a transaction completed and which didn't.  Sometimes the entire transaction will be failed even with...

Oops.

You still don't need a temp table.  Instead:

INSERT INTO ...

SELECT ...

UNION

SELECT ...

UNION

SELECT ...

Insert into dbo.StdActiveTable
(StudentName ,
StdId ,
Stdgrade )

select std.Name
,std.StdID
,dp.stdgrade
from dbo.student std
join dbo.department dp
on std.stdid = dp.id
where (dp.isactive = 1) or
    (dp.isactive = 2 and sdt.isactive =...

Sure, easy to list only those two columns.  I was just mirroring what your original query had, since I wasn't sure exactly what you needed.

Personally I'd also make the job...

You need a few mods to your code, in particular to limit the results to only those with the current msdb session_id.  As a starting point for you, this code...

Should this be replaced with a table that has 17 computed columns ?

Yes, if a computed column would work, then that is what you should use rather than a function.

Can...

I guess I don't understand why anyone would write software based on the knowledge of novices.  If it's important for a novice to be able to maintain something...