or maybe

declare @first DATE = '20200101';
insert into dbo.report (First_Of_Month, Customers_Count)
select top(20) 
    dateadd(d,1-day(saledate),saledate) as First_Of_Month, 
    count(distinct customerid) as Customers_Count
from Sales
where...

Correct, if the length is not explicitly declared, a VARCHAR type variable is defined as being one byte long. 🙂

https://docs.microsoft.com/en-us/sql/t-sql/data-types/char-and-varchar-transact-sql?view=sql-server-ver15

varchar [ ( n | max ) ] Variable-size string data.

When n isn't specified in a data...

I'm not at all sure I have understood your question correctly, but this query does produce the desired outcome:

 WITH
MultiCodes AS (
SELECT PartID, CodeTypeId, zValue
FROM #tradecode
GROUP BY...

If you simply want to get rid of the decimal point, you can use the REPLACE funtion to replace it with a zero-length string, i.e.

SELECT REPLACE(yourColumn, '.' ,'') AS yourColumn

I'm...

• This reply was modified 4 years, 1 month ago by kaj. Reason: Little typo

Building on what Ant-Green wrote, you can use this:

select *
from sys.dm_exec_sessions s
inner join msdb.dbo.sysjobs j 
on convert(char(34),convert(binary(16),j.job_id),1)  = substring(s.program_name, charindex('(Job 0x',s.program_name,1)+5,34)
where s.program_name like 'SQLAgent%Jobstep%'
and j.name='TEST' --...

You query produced the correct results. You need to use your reporting tool to handle the display that you want. SQL will not produce what you are looking for as...

• This reply was modified 4 years, 1 month ago by kaj.

Test data:

create table #CaseNames (
"Case ID" varchar(10) not null,
"Case Name" varchar(50) null,
constraint CaseName_PK primary key (
"Case ID")
)
create table #CaseFlows (
"Case Flow ID" varchar(10) not null,
"Case ID" varchar(10)...

This is probably just contributing to the guessing game, but I'll ask anyway...

Based on the difference in the number of records (your statement that the file has 2881 rows and...

One of my top use cases for APPLY is with a TOP(1), which is hard to achieve any other way, like for example selecting the latest price, i.e. something like...

You really should take a timeout, step back and seriously consider changing the structure of that table.

If you change the app_time and end_time into columns of type time(0), this would...

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

There are a few additional variations that will achieve the same. The resulting query plan will probably look slightly different too.

 update pwc
 set pwc.companyId = p.CompanyId
...

The EOMONTH() function returns the last day of the month of a specified date, with an optional offset. The EOMONTH() function accepts two arguments: start_date is a date expression that evaluates to a date. The EOMONTH() function returns the last day of...

The standard behavior for concatenation of strings is that if one of the strings to be concatenated is a null the concatenated string will also be null.

You can change this...

select
PartId,
FeatureName,
Status,
case when exists (
select * from #parts 
where PartId=p.PartId 
and FeatureName=p.FeatureName 
group by PartId, FeatureName 
having count(distinct status) > 1
) 
then 'Have Multistatus' else Comment end as...

The picture you posted is not a table by definition. It's got duplicate rows! You have no key or constraints. The strings you posted are not how we represent...