Could theoretically also be caused by a bug in SSMS. Are you using the latest version, i.e. 18.9.2?

If I misunderstood and you want the alarm noticiation flag to control the selection criteria, then it's best to use two separate queries instead of trying to cram everything into...

Uneducated guess:

DECLARE @AlarmNotification BIT
SELECT
    mpe.MeasuringPointEntryID,
    @AlarmNotification = CASE WHEN mpe.DateTimeEnd IS NOT NULL THEN 1 ELSE 0 END 
FROM [location] l
JOIN...

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, 6 months 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, 6 months 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, 11 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...