Fill in the missing dates in what table? In the shift table?

This should get you started:

SELECT c.DateKey
FROM dimCalendar c
WHERE NOT EXISTS (SELECT 1
    ...

This is somewhat cringeworthy, but since nobody else answered...

use tempdb;
go

-- create a table to store the results:
CREATE TABLE GotData(
RecNo INT IDENTITY,
col1 char(1),
col2 char(1),
col3 char(1),
col4 char(1),
col5 char(1),
col6 char(1)
);
GO
--...

You've been here for a while...

Surely you know how to post consumable data.

When I copied and pasted your pictures into SSMS, it wouldn't execute them... so I don't know how...

Something like this maybe?

SELECT *
FROM
(SELECT MasterRolls
, MrWgt
, TrimWgt
, rn = ROW_NUMBER() OVER (PARTITION BY MrWgt ORDER BY TrimWgt)
FROM RollSlice) orderedSlice
WHERE orderedSlice.rn = 1;

Jeff explains how to post consumable data in this article. Absolutely worth reading. If you read it, and follow the instructions in your next post, someone can write a...

Dynamic SQL?

Create one variable to hold the static part of the INSERT statement, and then use the cursor to create the dynamic part, and use sp_executesql to execute the whole...

So what happens if you create your temporary table and then do something like

INSERT INTO #TempTable(col1)
SELECT * FROM OPENROWSET('MSDASQL','Driver={MySQL ODBC 5.3 ANSI Driver};server=xxxxxxx;userid=xxxxx;pwd=;database=xxxxxx;port=xxxxx;','SELECT col1 from table1')

use a stored procedure, and create a variable in it, say @Total and ...

SELECT @AllSalesAmount = 1.0 * SUM(Sales[Amount]);

Then divide your sum by that in your pivot.

Do you mean something like this?

SELECT *
FROM duplicateSample ds2
WHERE ds2.RIN IN (SELECT RIN
FROM duplicateSample ds1
WHERE rowNum = 2 );

The most likely reason you're having a hard time is that you're missing a Calendar table. I borrowed some code from Dwain Camps for it. I ran this part...

Don't get into the habit of using implicit casting. If you're joining on two columns with different data types, one entire column has to be cast, and if you have...

It's not that CAST doesn't work, it's that it's expensive, especially if you use it in a crazy place like a join.

It's easier than that.

select * from tblTest
where TestNumber = '20012';

You're welcome... sorry it took me a bit to actually understand the question.

(sorry, my internet is freaking out... double post).

• This reply was modified 5 years, 9 months ago by pietlinden. Reason: duplicate post