Gustav Brock
gustav at cactus.dk
Mon Jan 20 10:51:43 CST 2014
Hi Arthur Yes, I just did a test, and T-SQL's CheckSum works great. Very handy. /gustav -----Oprindelig meddelelse----- Fra: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af Arthur Fuller Sendt: 20. januar 2014 17:40 Til: Discussion concerning MS SQL Server Emne: Re: [dba-SQLServer] [AccessD] Hash value of record fields Gustav, I'm HUGE Fan of PTQs. I don't think you're going to need any fancy VBA code to do this -- unless I'm mistaking your intent. On the Back End, create an SP that accepts a variety of optional parameters. Then ether create a new PTQ or modify a template PTQ and pass in the values of interest. Arthur