I too am a fan of triggers (only for auditing).  A long time ago I wrote an article to automate the creation of audit tables and audit triggers.

https://www.sqlservercentral.com/articles/an-auditing-solution-with-xml-and-xsl

A second...

In two of the last three companies I've worked in (Banks in Luxembourg), we still used Lotus Notes.  Unfortunately from a user perspective, it really hasn't aged well, and hasn't...

Thanks Martin.  Sound advice.  Still feeling my way around OLAP via trial and error, but I'll get there in the end.

I appreciate your help.

Thanks Martin....yes, this does help a lot.

But an account has other attributes....e.g. Account Status (plus half a dozen others.)

Assuming I add the AccountType attribute to my Account dimension, should I...

Just watched a compelling youtube video which makes me think that I need to incorporate all the IDs from the Process fact table also in the Validations fact table, and...

I just read a post in the 'Strategies and Ideas' forum (which is maybe where I should have posted this!).  It's making me think that I should combine the two...

• This reply was modified 3 years, 3 months ago by  David McKinney.

Is the definition of schemabinding not backwards?  i.e. Surely it prevents changes to the underlying objects and not the function?

A slight variation (although I've not got SQL installed to test it.)

CONSTRAINT ck_xxx CHECK ('' not in (c1,c2,c3,c4,c5))

Would you kindly check and let me know if that works?

No....I don't see any performance impacts...it's just a valid piece of data for the column's datatype.

That's my view anyway.

Actually, I was going to suggest using rownumber until I re-read and realised that's what you started with. 😀

So my suggestion is that you return to rownumber and look...

VoldemarG (2/23/2016)

---

that's exactly right. I do not want comma delimited.

but the output (DESIRED one) that you see on the top of the first page of the attachment is correct,...

Very interesting article...having done a little reading recently on Kaggle and analysing massive datasets with Python and R, I wonder if the recent R extensions to SQL Server would not...

curious....the output you've shown doesn't look like fixed width (rather comma delimited)....are you sure you're looking at the right output file?

what about simply....

update admin

set [add]= 1

where uname IN ('jain', 'baiju')

one year later, I know....but.....looks like you've got this all wrong....your xsl sheet doesn't change....your data does.

check out http://www.sqlservercentral.com/articles/XSL/2831/