Don't need any JOIN 😛

DECLARE @Name varchar(255),@Surname varchar(255);

SELECT @Name = [Name] FROM [table1];

SELECT @Surname...

Bit late 😀

SELECT NewsId

FROM #NewsEntities

WHERE EntityId IN (1,2)

GROUP BY NewsId

HAVING SUM(EntityId) = 1

Mine too LOL I just an idea that jumped into my head

I was thinking of adding a new derived...

Jeff Moden (6/10/2015)

---

David Burrows (6/10/2015)

---

Shouldn't that be...

This might be possible using derived columns but would be a very complex expression or using several derived columns to pad the string into 50 column chunks and a final...

In that case a script task is probably the way to go but in your case change the code to

start at col 50 and work backwards to first non space...

Your welcome

For quick, excellent and efficient answers Jeff's articles should always be your starting point 😉

Shouldn't that be max number of rows...

With derived column transformation set it to new column and use an expressions like

SUBSTRING([address ] +REPLICATE(" ",50),1,50)

SUBSTRING([address ] +REPLICATE(" ",100),51,50)

SUBSTRING([address ] +REPLICATE(" ",150),101,50)

*NOTE* Not tested

Jeff Moden (6/3/2015)

---

David Burrows (6/3/2015)

---

Just one...

Jeff Moden (6/3/2015)

---

Thanks Jeff

Yes PeriodNo will always be increasing

I will go with Tom's suggestion 🙂

Brandie Tarvin (6/3/2015)

---

If UploadID is used for anything at all, I might make it part of a composite clustered index. But, as Tom suggested, make it a separate UNCLUSTERED PK...

Thanks Tom 🙂

Thanks for the feedback Tom

1) How frequent are deletes?

Unknown as the user can run a process any number of times or not at all

2) How frequent are updates? Or are...

You need to make a Cartesian of the 2 tables and then left join them, like this

WITH a AS (

SELECT DISTINCT allowance.empid,allowances.allid

FROM allowance

CROSS JOIN allowances

)

SELECT a.empid,a.allid,ISNULL(allowances.amount,0) AS [amount]

FROM a

LEFT...