Luis Cazares (8/28/2015)

---

Of course, you need some tweaking to make it numeric.

CREATE TABLE #SampleData( num varchar(100));

INSERT INTO #SampleData VALUES

('1000:001'),

('1001:001'),

('1002:001'),

('999:001'),

('998:001'),

('99:001'),

('1:001'),

('2:001'),

('3:001');

--This won't work correctly

SELECT * FROM #SampleData ORDER...

chindilog (8/28/2015)

---

select sum(woitem.qtytarget) as total, wo.num, sysuser.username

from woitem

join wo

ON wo.id = woitem.woid

Join moitem

on moitem.id = woitem.moitemid

Join mo

ON mo.id = moitem.moid

LEFT JOIN SYSUSER ON mo.userid = sysuser.id

group by sysuser.username, num

order...

I would use a conditional split and check that the id (as a string) is 10 characters long and has its first 2 characters being numeric, the third character being...

serviceaellis (8/26/2015)

---

J Livingston SQL (8/26/2015)

---

in addition to what Alvin has already said....your TSQL code IS different to the Excel function....(ignoring the &_ line continuation)

TSQL

FROM attribute.PersonMembership LEFT OUTER JOIN USFSA.dbo.SOP10100 AS...

serviceaellis (8/25/2015)

---

Does that matter?

Strange thing is nothing has...

Looks like you're using pm as an alias twice; on the 2nd line of Split2 and at the end of Split3.

I remember that Excel is hard to deal with when you have a query that cannot be expressed visually.

I have had to create macros before, that would read the...

TomThomson (8/25/2015)

---

Perfectly reasonable would be an understatement for me. ...

You're talking about redoing an OLTP database using Type 2 SCD?

Type 2 SCD is something that is normally used in Reporting database/Data Warehouse. I've never heard of it in...

J Livingston SQL (8/25/2015)

---

maybe best if you explain how you are expecting Excel and SQL to interact first....then we...

serviceaellis (8/25/2015)

---

Alvin Ramard (8/25/2015)

---

Create 2 variables for the start and end dates of your range and use those instead of the hard coded dates you used.

How is the user going...

Create 2 variables for the start and end dates of your range and use those instead of the hard coded dates you used.

How is the user going to interact with...

Ed Wagner (8/25/2015)

---

I don't know if it's just me, but SSC has been having some blocks of time where it's very slow recently. I had one this morning where...

SQLRNNR (8/25/2015)

---

Sean Lange (8/25/2015)

---

Alvin Ramard (8/25/2015)

---

OP is looking for: "... I just looking for good understandable explanation by pptx slides for (Index internals & Isolation levels as well) and some...

blake.hartman (8/25/2015)

---

We need the actual date for the "week of" rather than the number and that seemed to be the simplest expression to calc that date

Is there an easier way...