data masking

Topic

I have an excel file. It contains several pivot tables which are updated from worksheets containing tables from SQL Server. How can I make the code in SQL server run and populate several worksheets with the resulting tables of the SQL code autmatically? Cheers

2005-05-11

RE: Placeholder column in a cursor

by Jim-W-White

Redgate

Sorry, I misspoke there. I tried Numeric(10,4), not Numeric(6,4). Jim

2005-05-04

1 reads

RE: Is XML the Answer?

by Don Peterson

Redgate

csv = comma seperated values. Normally it denotes an ASCII file, but not always...

2005-05-03

RE: Looking for SOX-Security Details

by Ed.Carden@Westdale.com

Redgate

Thanks to both of you for your response. Let me ask you both this and if anyone else owuld like to chime in then please do so. If I have a database on an instance of SQL Server that cintains fiancial data used to prepare financial reports and I leave that instance of SQL Server setup […]

2005-05-02

RE: Platform

by philcart

Redgate

PatAs I've mentioned previously, It'll probably help you frame your questiosn better if you do a bit of research for yourself before coming to the forum with sucha broad question.A simple Google search for "SQL Server platform suport" will take you to a few places that have relevant information. I'm sure the same search for […]

2005-05-02

RE: Retention

by Jamie Thomson

Redgate

What really grabbed my attention in what Steve said is the following:"My friend would seem to have a great place to work. Two weeks vacation off the bat, 3 after a year, 4 after 2. Not many places offer that"Is this considered to be a "great" amount of vacation time?What do US workers get in […]

2005-04-29

RE: How to change the login for an existing user?

by bart

Redgate

Thanks Andy , this should be highlighted on this site It fixed my 21002 error with login (restored Db from Prod )

2005-04-26

RE: replication type advice

by noeld

Redgate

Daniel,Merge replication is designed to do most of what you need but from application stand point you just have to be carefull to perform primary key partitioning if at all possible On the other end conflict resolution can be performed through a custom stored procedure so that you can do what you please with it […]

2005-04-22