hi,

go to http://www.planetsourcecode.com/ and search vb projects and look for

enterprise manager. there is a brilliant project available

regards

zaid

hi there,

visit the following website and you will find vb source code for your own version of enterprise manager.

http://www.planetsourcecode.com/

regards

zaid

SET QUOTED_IDENTIFIER off

declare @add1   varchar(31),

 @add2   varchar(31),

 @add3   varchar(31),

 @add4   varchar(31),

 @add5   varchar(31),

 @fld  varchar(200)

/*

rec1 MAIN ROAD;GLENORCHY TAS;;;

rec2 ;;;;

rec3 FLOOR 17;255 GEORGE STREET;SYDNEY NSW;;

rec4 LEVEL 20;500 OXFORD STREET;BONDI JUNCTION NSW;;

rec5 255 GEORGE STREET;SYDNEY NSW;;;

rec6 LEVEL...

Hi,

change your proc as shown below

CREATE PROCEDURE au_info @lastname varchar(40), @firstname varchar(20) AS

SELECT au_lname, au_fname

FROM authors

WHERE au_lname = isnull(@lastname,au_lname) and au_fname = isnull(@firstname,au_fname)

go

EXECUTE au_info @firstname = null, @lastname =...