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...

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...

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...

There is no "Rule of Thumb" here because there are two "Rules of Thumb"...

Dupe post so the forum software would actually let people see this page. 🙁

Your fingers might get considerably shorter, but you could always add a lot of these ...

IF UPDATE (colName )
BEGIN
  -- Add your column to DSQL...

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...

@MannySingh... despite what was found on script 2, thanks for stepping up to the plate to teach.

If it were me, I'd get on the phone with Veritas .

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...

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...

@dmcmorriswelcom-co-uk ,

Are you all set now?

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...

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...

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...