Can you set step 4 to go to step 1 on failure?

This does not allow you to limit the number of times it will try to restart and could end...

I may have missed something simple, but I don't think this is as straightforward as it should be.

If you set double quotes as the text qualifier for the flat file...

• This reply was modified 2 years, 9 months ago by  Ed B.

I want UID column in linuxdata table to map with the importid column in computerdata table and give the output of UID( from linuxdata table ) with its name(column...

• This reply was modified 2 years, 9 months ago by  Ed B.
• This reply was modified 2 years, 9 months ago by  Ed B. Reason: spelling

--===== 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 2 years, 9 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 2 years, 10 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 2 years, 10 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 2 years, 10 months ago by  Ed B.