A programmer and Founder of Girfa
IT Services, working from 2009.At Starting computer teaching was my full-time job but after 10 years of teaching I chose to programming as a full-time job and teaching become part-time. In real life, I am very lazy and I made it my coding style I always try to make a reusable component that’s my USP for programming which saves my time and extra working both.
I was making an image gallery with images only. So I have created a table with a single column named ID with identity. I want to create a row with the auto number and create an image with a created auto. number.
This problem is solved by the query given below.
INSERT dbo.TABLE DEFAULT VALUES;
Next Example
A programmer and Founder of Girfa
IT Services, working from 2009.At Starting computer teaching was my full-time job but after 10 years of teaching I chose to programming as a full-time job and teaching become part-time. In real life, I am very lazy and I made it my coding style I always try to make a reusable component that’s my USP for programming which saves my time and extra working both.
Welcome, This post will help you to make a chart for Success Pending order count datewise. This Sales chart shows the business summary of a month date-wise in just a glimpse. It takes a few seconds the get an idea of the whole month's business, It is a better choice to written business summary.
data.addRows([
[1, 0, 0],
[2, 2, 0],
[3, 0, 3],
[4, 18, 10]
]);
with str1 as
(
select day(orderdate) as day,case when status=1 then sum(status) end as success,case when status=0 then count(status) end as pending from [Order]
group by (OrderDate),status having month(OrderDate)=month(getdate())
) select * from str1
I have saved query in CTE to output in str1 variable, which will be used output for next query.
Now we have the list of success and pending order list datewise. We have to combine this in a single row for datewise.
2. Now it is time to sum the pending and success order datewise by combining the above query output to other CTE variable str2
(
select day(orderdate) as day,case when status=1 then sum(status) end as success,case when status=0 then count(status) end as pending from [Order]
group by (OrderDate),status
having month(OrderDate)=month(getdate())
),
str2 as
(
select day,sum(success) as success,count(pending) as pending from str1 group by day,success,pending
) select * from str2
with str1 as
(
select day(orderdate) as day,case when status=1 then sum(status) end as success,case when status=0 then count(status) end as pending from [Order]
group by (OrderDate),status
having month(OrderDate)=month(getdate())
),
str2 as
(
select day,sum(success) as success,count(pending) as pending from str1 group by day,success,pending
)
select day,max(success) s,max(pending) as p from (
select day,isnull(success,'') as success,isnull(pending,'') as pending from str2 group by day,success,pending) tbl
group by day
A programmer and Founder of Girfa
IT Services, working from 2009.At Starting computer teaching was my full-time job but after 10 years of teaching I chose to programming as a full-time job and teaching become part-time. In real life, I am very lazy and I made it my coding style I always try to make a reusable component that’s my USP for programming which saves my time and extra working both.
