And where are you expecting the messagebox to be displayed?

Change your simple script such that it does not require any sort of UI interaction and you should find that it...

You would probably do something like this:

DECLARE @LatestExpiredDate DATETIME = DATEADD(d,-1,GETDATE())

SELECT * FROM Book_Reservation br
WHERE @LatestExpiredDate >= br.reservation_To_date

This sets a temporary variable to the date/time of 'now'...

• This reply was modified 6 years ago by Phil Parkin.

I appreciate that you are dealing with sensitive data, but are you able to put together some example data – which could be completely nonsensical – along with desired results?...

Are you saying that the column you are searching may contain two numbers (eg, '123|456') or that the user may enter two numbers and you want to search for both...

What is your question?

I don't use the data import wizard, but if you know how to edit the SSIS package it produces, you will see that there is a property called 'Header rows...

My head just overheated, trying to understand what your query is trying to do 🙂

Can you explain, in English, what you are trying to achieve?

Even better if you can provide...

It's not clear what sort of output you are looking for, but how about this?

SELECT t2.CATEGORY
      ,t2.ITEMID
FROM dbo.SomeTable t2
WHERE EXISTS
(
  ...

What exactly are you hoping for? Some code to generate a calendar table, or some code which takes a date as its input and returns week number? Something else?

Did my response satisfy your requirement?

Are all of the job steps running pure T-SQL?

Or are there other task types (eg, execution of SSIS packages)? If so, this task could be deceptively difficult.

Do you have any backups of this database?

Try this:

DROP TABLE IF EXISTS #T;

CREATE TABLE #T
(
    ServiceDate DATE
   ,Department VARCHAR(50)
   ,WeekOfYear INT
);

INSERT #T
(
    ServiceDate
 ...

• This reply was modified 6 years, 1 months ago by Phil Parkin.

Have you tried something like this? The HOLDLOCK helps avoid potential concurrency issues.

MERGE [dbo].[tableone] WITH (HOLDLOCK) T
USING [dbo].tabletwo S
ON (S.PARTID = T.PART_ID AND S.SERIAL = T.SERIAL)
WHEN MATCHED...