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, 4 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...

Since SSIS packages do not share memory with SQL Server and you are not using the DB engine, it seems like it would make sense to reduce that allocation, not...

each one has there own opinion.  it should be left to them. that idle for mutual respect.

i would like to maintain my code in pastebin.

is there any hard rule...

Given any MSKU, what is the lookup logic for getting its Title?

if I understand right, you want to do an insert into 2 different temp tables from a CTE in a single query?  If so, I don't think that is...