Try executing this script. It creates a table and function in tghe tempdb database

USE TEMPDB

go



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[EMPLOYEES]') and OBJECTPROPERTY(id,...

The script is simply an example of how this could be done. It creates a temporary table in the tempdb database and populates it with some test data. The select...

try adding to the vb code this line after the cmd is executed

lngProductID = cmd.Parameters.Item(4).value

Navin Parray

Here's a script that formats as you request

 



/** SCRIPT **/

USE TEMPDB

GO



CREATE TABLE TESTFORMAT (FA VARCHAR(10), FB VARCHAR(10), FC VARCHAR(10), FD VARCHAR(10))



INSERT TESTFORMAT (FA, FB,...