Viewing 15 posts - 2,326 through 2,340 (of 59,066 total)
To Eirikur's point, what will a row look like in the tblStudentMarksCopy1 table if a student hasn't taken one of the subjects? Will there always be only 3 subjects in...
November 30, 2022 at 3:33 pm
I don't work with SSRS but... this is no different than any other process... If you suspect bad connections (and it does look like that), then you need to rework...
November 30, 2022 at 3:03 pm
I ran this query containing a field (EntityType) that I don't have any index on. It still ran the same execution plan and took the same time. I don't...
November 30, 2022 at 2:49 pm
well , there must be some thumb of rule , i think that can be answered.
There is no "Rule of Thumb" here because there are two "Rules of Thumb"...
November 30, 2022 at 2:30 pm
Dupe post so the forum software would actually let people see this page. 🙁
November 30, 2022 at 6:04 am
Your fingers might get considerably shorter, but you could always add a lot of these ...
IF UPDATE (colName )
BEGIN
-- Add your column to DSQL...
November 30, 2022 at 6:02 am
Jeff Moden:-
Yes, that was my exact test.
I have attached a test sql code.
Jeff, thanks for being a real one.
Sacrificing your soul to make sure that everyone gets a lot...
November 30, 2022 at 2:59 am
@MannySingh... despite what was found on script 2, thanks for stepping up to the plate to teach.
November 30, 2022 at 2:53 am
If it were me, I'd get on the phone with Veritas .
November 30, 2022 at 1:48 am
Thanks, Steve.
It's a tougher question than I thought.
All I want to do is add an Instead Of Update trigger to a table, do a small task, and then do an...
November 30, 2022 at 1:43 am
From the article:
"The last few years, however, it seems that ASD is getting features first, which then slip into a release that I can download and run locally."
I...
November 30, 2022 at 12:58 am
Are you all set now?
November 29, 2022 at 10:57 pm
SGAB, does any one have a decent example of an Instead Of Update trigger that will handle more than one bloody row at a time and also ONLY...
November 29, 2022 at 10:50 pm
hi,
We have a master table, single table which I loop thought, to do some task, the master table is very rarely changed.
So while looping through , I put some...
November 29, 2022 at 10:43 pm
Manny:-
I do not think example 2 actually works.
Here is your SQL Statement for Example 2:-
Declare @holdname sysname
Declare getdbname cursor for
Select name from master.sys.databases order by name
Open...
November 29, 2022 at 10:33 pm
Viewing 15 posts - 2,326 through 2,340 (of 59,066 total)