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 5 years, 5 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...

5. Avoid using reserved words as column names (PERIOD)

PERIOD is not a reserved word in SQL Server. (Nor is it reserved in ODBC, also not on the list of...

OK, I've had a coffee now, so brain is out of first gear!

Are you suggesting that SSIS packages run OK after a reboot of the SSIS server, but then at...