This problem is unsolvable with the information that you have given us.  We don't know the logic for whether someone is moving out or moving in and there is nothing...

• This reply was modified 6 years ago by Steve Jones - SSC Editor.

As has been stated multiple times.  The table simply does not contain the...

It was missing parenthesis on the values...this worked.

USE [SSSUTIL]
GO

INSERT INTO [dbo].[RailCarCycleYard]
           ([RailcarID]
    ...

my bad..here is the insert again.

I though I was qualifying the field name by prefixing it with the table , I originally tried an alias but that gave me...

As a style note: LOSE THE BRACKETS.  They clutter up the code without adding anything.  Obviously there are some cases where you must use the brackets, but those cases are...

Hope this helps....

Here is the insert I was trying

Insert into  [RailCarCycle] ([Railcarid],[StartDate])
select    [RailCarid],[LoadDate]
from [RailCarCycleYard]
 where  [RailCarCycle].[Railcarid] = [RailCarCycleyard].[Railcarid] and [RailCarCycle].[EndDate] is...

You only answered question 1.  You have not addressed the other issues.  Specifically note that a list does not qualify as "a create temp table [or declare table variable] and...

You're missing a bunch of information.

1. Which column is the identity column?
2. Which column(s) do you want the unique constraint on?
3. Is the unique column a natural key or an...

When you provide sample data, you should also provide expected results.  This helps us compare our tests against what is expected to see how closely we match the expectations.  You...

1. SQL is not an operating system.
2. I've been using SQL for 20 years and have never heard these terms in reference to SQL.

Drew

Are you really still on SQL 2008?  There is a simple way to do this in SQL 2012 and up, and SQL 2008 is no longer supported.

Drew

Duplicate post.  Please respond to this one

Without the additional info we can only guess at your full reqirements.

My first 'guess' is as follows

CREATE TABLE #T (Type CHAR(1),Year INT, MOnth CHAR(3), Car VARCHAR(50),...

SELECTt.COUNTRY_CODE,t.COMPANY_CODE,t.ITEM_NBR,t.Department,t.[Week],d.[Day],q.QTY
FROM t
CROSS JOIN (
VALUES ('SUN'),('MON'),('TUE'),('WED'),('THU'),('FRI'),('SAT')
) d ([Day])
CROSS APPLY (
SELECT CASE d.[Day]
WHEN 'SUN' THEN t.SUN_QTY
WHEN 'MON' THEN t.MON_QTY
WHEN 'TUE' THEN t.TUE_QTY
WHEN 'WED' THEN t.WED_QTY
WHEN 'THU' THEN t.THU_QTY
WHEN...

What have you tried?

A few things to think about. When you note that something is in more than one  country, you're considering that it has appeared in more than...

• This reply was modified 6 years ago by drew.allen.