Viewing 15 posts - 16 through 30 (of 457 total)
Sorry, I was just trying to help and that link sounded like exactly what you were after.
I did not try it, and shares are "discouraged" on our network.
To be honest,...
September 19, 2019 at 1:06 pm
Would this do it?
Top of the page on DuckDuckGo "powershell create share"
September 18, 2019 at 11:02 am
Found the solution.
And Group-Object does come into it:
# Group the objects by table name$Tables = $array |Group Table# Select the table name + sum of each group$Tables...
July 11, 2019 at 11:07 am
I don't *think* Group-Object is what I'm looking for: "...a table with one row for each property value and a column that displays the number of items with that value."....
July 8, 2019 at 3:19 pm
I meant, in Powershell, how can i get the equivalent of
SELECT Table, Col1 = SUM(Col1), Col2 = SUM(Col2)
GROUP BY Table
In my example,
Table Col1 Col2
Table1 4 9
Table2 6 11
July 8, 2019 at 2:02 pm
I don't see how a trigger helps in this scenario...? If there's no table activity, no trigger is fired, nothing changes...? Or am I standing to close to the tree...
May 29, 2019 at 3:09 pm
So after the above comments, it's now a giant CASE statement.
May 29, 2019 at 2:19 pm
So I got a prototype going as a computed column calling a scalar function, and the perf hit appears negligible.
Further investigation underway.
May 28, 2019 at 6:41 pm
Coming from you, that's a... shall we say, less than ringing endorsement of the current implementation.
Here's the bones of the table, minus the meat columns - and believe it or...
May 28, 2019 at 2:42 pm
PRINT, IF APP_NAME() LIKE "%QUERY%" BEGIN...END, DECLARE @Debug variable
I remember being SOOO excited when SQL2K came with a debugger... and the crushing disappointment at its unmitigated clunkiness.
May 28, 2019 at 11:36 am
If you need to track the date of an insert, and the table doesn't already have a field from which that can be derived, that's a case for Insert trigger.
May 14, 2019 at 12:26 pm
Well, you asked specifically how it could be achieved using constraint violations, so that's what I came up with.
IMHO, it's clumsy at best. And, you must hard code either the...
May 13, 2019 at 11:11 am
I suppose you could achieve this using TRY-CATCH. Try to Insert it. If the insert fails on a violation of that constraint, increment the visit count for the user.
May 8, 2019 at 11:03 am
I completely agree that the implementation of the OUTPUT clause for INSERT is... shall we say, disappointing.
And you're correct that there may be obstacles to modifying prod tables.
Another workaround I've...
April 2, 2019 at 1:53 pm
One workaround is to add the OldId column to the new table, and include it in your INSERT statement. It'll then be available to the OUTPUT..INTO.
You can then decide if...
April 2, 2019 at 10:55 am