--===== A nasty fast solution to convert to the DATETIME data type. SELECT * ,ConvertedDateTime = DATETIMEFROMPARTS(IntDate/10000, IntDate/100%100, IntDate%100 --Date ,IntTime/10000, IntTime/100%100, IntTime%100 --Time ,0) --Milleseconds FROM #TestTable...

If you store times as integers, it makes life much easier if you have a time table containing all the formats you need, however, if you need to just change...

• This reply was modified 3 years, 6 months ago by Ed B.

I think the OP's problem is the inclusion of procvaldate in the partition by. The output will be 1 for all rows. If procvaldate is removed from the partition, then...

Noted. I almost didn’t suggest it, because I thought I remembered you saying something similar in the past. I only...

Can you use FORMAT? I have only ever used it in ad-hoc queries to make numbers easier to read, and I can't vouch for its performance, but it seems to...

This is a SQL Server forum, not MySQL and I know nothing about MySQL.

At a guess I would say you are not connected to the database or service, It says...

I found that you can include up to column c0308. Any more and the row size exceeds 8060.

If the table is empty the problem doesn't happen.

If the columns are populated...

Have you...

• This reply was modified 3 years, 6 months ago by Ed B.

If your code works for a specific object, can you grant the permission on a schema /  all schemas, rather than specific objects?

GRANT EXECUTE ON SCHEMA::[dbo] TO...

Yes. I just set the compatibility of a database to 2012 and ran the code in the link you supplied and it worked fine. I believe that SQL 2016 is...

• This reply was modified 3 years, 6 months ago by Ed B.

Can you create a column in your data set that is a 1 if the case is before 4:40 and a zero if after, then sum that column as your...

I don't think any date functions return a decimal.

Either of these might work.

SELECT TOP 100 [name], create_date,
       DATEPART(hour, create_date),
  ...

• This reply was modified 3 years, 6 months ago by Ed B.

Does the public role have read access to those tables? I don't think you can remove a user from public.

You could create a new role, add the user to the...

• This reply was modified 3 years, 6 months ago by Ed B.

You original post talked about 1's and 0's.  You've now post data with only 1's and haven't posted the result that you're looking for.  I don't know about anyone...

• This reply was modified 3 years, 6 months ago by Ed B. Reason: Format code

SELECT GivenPartNumber_Non, vcompanyid, MAX(SourceType) AS 'SourceType'
FROM   #notmappedsources
GROUP  BY GivenPartNumber_Non, vcompanyid
HAVING MAX(SourceType) = 484456
AND    MIN(SourceType) = 484456

and for fun.

DECLARE...

• This reply was modified 3 years, 7 months ago by Ed B.