How long does it take? I'm just wondering, because this installer seems to park at the "loading..." screen forever and ever. (A good 10-15 mins?) Maybe i should start it...

(Notes from the field: I worked in a place where they didn't know how to normalize... As a result, I was there for 8 months instead of maybe a week....

• This reply was modified 3 years, 8 months ago by pietlinden.

CAST('Action - 1. Analysing' AS DATE) END

'Action -1. Analysing' is a string that cannot be coerced to date. If that's supposed to be a column in your table, then wrap...

You mentioned a Fact table... you usually only have that kind of thing in a data warehouse. Where are you analyzing said data? Because the way you would answer this...

you need LEAD() to get the next row. See here

You'd put the PartNum in the OVER clause and then ORDER BY EffectiveDate

Couldn't you just use NTILE() to split the file into a given number of pieces?

DECLARE @Tiles INT;
SELECT @Tiles = CEILING(COUNT(*)/10000)
FROM dbo.CovidData;

SELECT 
bucketNo = NTILE(@Tiles) OVER (ORDER BY...

If I were you, I would get out a whiteboard (or piece of paper) and draw / diagram this:

1. a company can have many workers(01,02)  Company ---(1,M)--Worker
2. worker can have...

views/stored procedures to hide columns from some users --Sure, you wouldn't let just anyone see a patient's Social Security Number, for example. If you did, and someone misused it, that...

No problem. Just looking for general directions. I think I can figure the rest out myself. (Well, I hope I can!)

bcp out

Okay, I think I get it. Thanks, Chris!

So I would have an Ingredient table (IngredientKey, IngredientSK, IngredientName, Category, UnitPrice, ActiveDate) and then use FILTER() and/or TOPN() to get the most...

SELECT Location_ID, Location, SUM(TotalRate)
FROM <tableName>
GROUP BY Location_ID, Location;

Sorry, missed the n0t-so-fine print.

Not a clue about PostGRES. =(

I'm pretty sure this is what you want. First, create the Supplier table with a primary key, and then reference that in the constraints of the Product table. (it's a...

What's the best way to segregate the SSRS stored procedures from the rest, put them in their own schema, and then grant users execute on the schema? (and SSRS devs...