Database

select convert(varchar,year(getdate()))+ <br />
(select top 1 cast(empsex as varchar) from emp )+<br />
(select top 1 cast((empid+1) as varchar) from emp order by id desc) 

declare @FNID as int<br />
set @FNID = (select max(ID) from firstnames)<br />
declare @LID as int<br />
set @LNID = (select max(ID) from lastnames)<br />
<br />
Insert into users (firstnameID,LastNameID) values (@FNID,@LNID)

DECLARE @FID INT
DECLARE @LID INT

SET NOCOUNT ON

SELECT @FID = [ID] FROM FirstNames WHERE FirstName = 'Fritz'

IF @FID IS NULL
BEGIN
  INSERT INTO FirstNames(FirstName) VALUES ('Fritz')
  SET @FID = Scope_Identity()
END

SELECT @LID = [ID] FROM LastNames WHERE LastName = 'Blignaut'

IF @LID IS NULL
BEGIN
  INSERT INTO LastNames(LastName) VALUES ('Blignaut')
  SET @LID = Scope_Identity()
END

INSERT INTO Users VALUES (@FID, @LID)

big_nige wrote:

Or is it possible to create a table view with the exact name of the original table (deleting the tables of course) and the SP's and reports will still pick up the data?

Rami Said Abd Alhalim wrote:

(the file you've specified is not a valid sql server database file )