Why not? It'll be a once-in-a-lifetime experience 😛

May I ask for the table definition involved?

You provided a view definition. But we'd need the table def. Especially for [ExtOLSMachine].

Wow!

The script name have nothing to identify the table in question.

You really like to provide puzzles, do you?

Also, please provide the code of DML.GetRetailOrOnlineIndicator(), which seems to be a function...

How are we supposed to know?

You didn't bother to mention where the columns you're referring to (Username/pw) are stored.

So my guess is: You don't need to join any tables at...

Especially if the value is used in other tables so we'd have a PK/FK scenario.

The minmum number to prefer is Zero, meaning the PK should be part of the initial table definition.

What makes you think there's a relation to the number of rows in...

You could build a dynamic query and use sp_msforeachdb as described here[/url].

lnardozi 61862 (4/22/2014)

---

if you wanted to force that business requirement to work, maybe you could insert the original request with a priority of say, 2,000,000,000 and with all future requests...

A concept where a new row requires an update of (almost) all current rows in a table is questionable in terms of the relational theory.

Taking this aside: what would you...

Here's something to start with.

It's based on the gaps'n'island concept.

;

WITH cte AS

(

SELECT

*,

ROW_NUMBER() OVER(PARTITION BY employee_id ORDER BY effective_date) as pos1,

ROW_NUMBER() OVER(PARTITION BY employee_id,employee_dept ORDER BY effective_date) as pos2

FROM mytbl

)

SELECT...

All I can recommend is Gails great article for catch-all-queries[/url]

If it's client based, how do you plan to expand your software

?

That's contradictory to your client based installation.

At this point I...

As to my understanding the SQL SERVER CAL licensing model is not based on concurrend users but on named unsers/instances.

Those 5 CAL's are used either by 5 different logins or...

There's no time...

here's the approach I came up with returning exactly the rows you requested.

Depending on the original data size it might be better to store the results of cte_production_slots in an...