SP_oa~ series procs let you interact with COM objects, so you could compile it with the COM interop setting, access it that way. A different way would be to shell a mini exe that just runs the dll and uses a value passed on the command line. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-06-09
1 reads
Nice work Andy. Running profiler led me to the sp_msupd sproc. The dist agent was passing the correct variables but my sproc was not running appropriately. This is one that I have manually modified to handle identities and primary key settings. When I manually added the columns to the sp, I should have pushed the […]
2003-06-09
Thanks for the response. Yes there are over 20,000 rows that have been updated for these columns. I have not run profiler. Thanks for the tip. Any thoughts on what the best filter would be? thx.
2003-06-09
without researching it... I'd say yes, the change of collation will cause a problem.
2003-06-09
1 reads
See if any of the following apply: http://support.microsoft.com/default.aspx?scid=kb;en-us;819264 http://support.microsoft.com/default.aspx?scid=kb;EN-US;316541 K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-06-06
Try this, I hope it will help: /* Assumption 1: PutawayPriority is unique for each Item (no two bins for an item can have the same priority) If this is not true, the some another criteria should be used to UNIQUELLY order bins, like concatenating the BinId to the priority (converted to varchar). Assumption 2: […]
2003-06-06
I realize that, as this uses a cursor, it's the ultimate evil; however: SELECT Timecard.EmpID, SUM(Timecard.WrkHrs) AS WrkHrs, WrkEmp.FName AS EmpFName, WrkEmp.LName AS EmpLName, MgrEmp.EmpID AS MgrID, MgrEmp.FName AS MgrFName, MgrEmp.LName AS MgrLName INTO #EmpHoursByProject FROM Timecard INNER JOIN Project ON Timecard.ProjNum = Project.ProjNum INNER JOIN Employees MgrEmp ON Project.mbillaty = MgrEmp.EmpID INNER JOIN Employees […]
2003-06-05
quote: Not one update statement, hope it helps! While Not (@CurrentBin Is Null) And @QtyToPutAway>0 Thanks for your suggestion. But you are using a loop, which is what I was hoping to avoid. I have a loop that works. It looks like this: Create Table ItemBin ( Item varchar(80), BinId varchar(10), PutawayPriority int, QtyMax numeric(19,2), […]
2003-06-05
If you don't mind having an intermediate help table (temporary or otherwise) you could use something like this - FillList may even prove usefull. /* Create Table ItemBin ( Item varchar(80), BinId varchar(10), PutawayPriority int, QtyMax numeric(19,2), QtyOnHand numeric(19,2) ) Set NoCount On Insert Into ItemBin Values ('A1', 'BIN1', 1, 100, 50) Insert Into ItemBin […]
2003-06-05
I guess you need to Rebuild the master database and re-attach all the user databases.
2003-06-04
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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