Database

Michel Godfroid wrote:

Semi-colons do not display in Braille?

CREATE PROCEDURE  CreateOrderDetails

	(
		@ProductName			NVARCHAR(50), 
		@Price				NVARCHAR(10), 
		@Quantity			NVARCHAR(10), 
		@Total				NVARCHAR(10)
	)

AS

SET NOCOUNT ON

DECLARE @MyRecordId		INT

INSERT INTO
	TableA (productname, price, quantity, total)
VALUES
	(@ProductName, @Price, @Quantity, @Total)

--Get the ID of the record we just created
SET @MyRecordId  =  SCOPE_IDENTITY()

INSERT INTO
	TableB  (Orderid, productname, price, quantity, total)
SELECT 
	Orderid, productname, price, quantity, total
FROM
	TableA 
WHERE 
	Orderid = @MyRecordId

RETURN @@ERROR
SET NOCOUNT OFF

test-09 wrote:

Now i need to search columns from 5 tables How can i do it....

select projectID=projects.projectid,projectname,
[image],country,county,ClientCompany,city,ConstructionCompletionDate_dt,
OverallBuildingSize_uts from projects, schedule,BuildingSiteStatics 
where projects.projectid=schedule.projectid and projects.projectid=BuildingSiteStatics.projectid

FROM dbo.FactConsoTB AS F
  INNER JOIN dbo.Branch AS B ON F.BranchID = B.BranchID
  INNER JOIN dbo.lnkAccountProduct AS L ON F.APLinkID = L.APLinkID
  INNER JOIN dbo.Account AS A ON L.AccountID = A.AccountID
  INNER JOIN dbo.Product AS P ON L.ProductID = P.ProductID
  INNER JOIN dbo.Currency AS C ON F.CurrencyID = C.CurrencyID
  INNER JOIN dbo.Currency AS BC ON F.BaseCurrencyID = BC.CurrencyID
  INNER JOIN dbo.ProductCategory ON P.ProductCategoryID = dbo.ProductCategory.ProductCategoryID

test-09 wrote:

select projectID=projects.projectid

SELECT     dbo.Projects.ProjectID, dbo.Projects.ProjectName,
 dbo.Projects.City, dbo.Projects.County, dbo.Projects.Country,
 dbo.Projects.ClientCompany, 
                      dbo.BuildingSiteStatics.OverallBuildingSize_uts, 
dbo.Schedule.ConstructionCompletionDate_dt, 
dbo.OverallDevelopment.TotalNumberDwellings

FROM         dbo.Projects INNER JOIN
                      dbo.BuildingSiteStatics ON dbo.Projects.ProjectID = dbo.BuildingSiteStatics.ProjectID INNER JOIN

                      dbo.OverallDevelopment ON dbo.Projects.ProjectID
 = dbo.OverallDevelopment.ProjectID INNER JOIN

                      dbo.Schedule ON dbo.Projects.ProjectID = dbo.Schedule.ProjectID where projectname like '%%' or country like ''
 or clientcompany like '%%' or ConstructionCompletionDate_dt like '%%'

test-09 wrote:

Now i need to search columns from 5 tables How can i do it....

I are Troll