A different approach maybe? Is it possible to build a table that links a 'web-product-attribute' to a 'crm-product-attribute' in some way? Is this some kind of general structure that is always applied, regardless of the product / customer who purchases the stuff? If that's the case, it should be fairly straightforward to build this as […]
2003-08-18
This script returns a description of the database with references to all tables in the database with keys listed. If the column description has been filled out the listing includes that text.If you want to get a report on the structure of each database, just add this script to each database, and then use a […]
2003-08-14
781 reads
Thanks everyone. I have some ideas now. I'm not sure ASP will work for me, I'll have to check into it more. I'm not allowed to use 'unapproved' software, so I need to find out exactly what ASP is. I'll check out the sites Frank posted. I'm also looking into testing Access since all my […]
2003-08-14
I schedule this proicedure to run 6 Am and there is another job on another machine which runs about 5 Am and completed around 5:15 and feed Data to this procedure. The frequency of the procedure is once in a day. I dont know why its gives me Locks and User error?. Some day its […]
2003-08-13
Thanks to all I found the problem, in sql 2000 numeric values are not implicitly converted to characters within a string concatenation statment
2003-08-13
I found the two mcse/mcdba (70-228/70-229) training kit books from mspress to be pretty good review. However, I think it is worthwhile to check out other books about sql server that don't focus just on the exams. These are two must-have titles: 1. Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook by Ken England […]
2003-08-12
1 reads
Chris discusses questions raised by his first article on clustered indexes. Few subjects more important to master than clustered indexes, this is good reading!
2003-08-12
9,827 reads
Hi there What approach did you take with the upgrade? Is this error your application table related, or system? Any fundamental architecture/OS changes? (long shot) The error is fair enough, and of course select cast('13495112479' as bigint) works a treat. Double check your v7 instance of the app and determine if this wasnt a problem […]
2003-08-10
2003-08-08
You cannot pass a field name into a select using a variable. One solution would be to pass it in to a dynamic select statement: declare @sql varchar(8000) set @SQl = 'SELECT TOP 100 PERCENT PCTR, SUM(' + @Month1 + ') AS [Month] FROM dbo.kc_Bud_EssbaseM3 WHERE (' + @Month1 + ' <> 0) OR (' […]
2003-08-08
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
By James Serra
A TON of new features announcements at the European Microsoft Fabric Community Conference help...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers