Search results for query: *

I copied this from the knowledge base How To Access and Modify SQL Server BLOB Data by Using the ADO Stream Object Article ID : 258038 Last Review : July 15, 2004 Revision : 1.0 This article was previously published under Q258038 On this page SUMMARY MORE INFORMATION REFERENCES...

I have an app that stores groups of .bmp images in a sql data base. They are images of flaws on plastic film (used for filtering products) associated with a roll of film about 1 meter wide, 1600 or 3200 meters long. there can be several hundred to several thousand images for a roll. The...

I am trying to create a stored procedure and can not get temp tables created in the proc to pass to subsequent steps of the same proc. The first step SELECTs INTO a temp table #tblCertRollTest The next step uses that table to SELECT INTO another temp table #tblTest #tblTest is used to...

How did you fix it - I have a similar problem Thanks Marvin

I am trying to create and run a dynamic Sql statement in a stored procedure. The part of the proc that creates the @Sql is "SET @SQL = 'SELECT IDENTITY(int, 1, 1) AS Testid, rtblCertRollTest.SapLotNumber, rtblCertRollTest.SapRoll, rtblCertRollTest.Ply, ' + @tstTable + '.SapLotNumber AS...

Thank you very much. I tried your solution and it is charmed. Thanks again Marvin Jean

I have a table with a column that may be null and may have data. If the field is null I want to copy from the previous record. The first record will not be null. Table: Group Unit Data 123 1 Alpha 123 2 <null> 123 3 <null> 123 4 Beta 123 5...