Форумы HiProg.com - MS ACCESS, VBA, VB

ник: Мюллер

А алиасы при работе с MS SQL-server допустимы?

Да без проблем

ALTER PROCEDURE spSmeta1 @IdObj int AS WITH Tab1 AS( SELECT DISTINCT dbo.TblDol.IdDol, dbo.TblDol.IdZnach, dbo.TblZnachPokazat.Znach, dbo.TblZnachPokazat.IDPok, dbo.TblDol.IdKlassDol, dbo.TblZnachPokazat.IdObj FROM dbo.TblDol INNER JOIN dbo.TblZnachPokazat ON dbo.TblDol.IdZnach = dbo.TblZnachPokazat.IdZnach INNER JOIN dbo.TblDolObj ON dbo.TblZnachPokazat.IdObj = dbo.TblDolObj.IdObj WHERE (dbo.TblZnachPokazat.IDPok = 1)AND dbo.TblZnachPokazat.IdObj = @IdObj) SELECT IdDol,IdZnach,Znach, IDPok,IdKlassDol,IdObj, ROW_NUMBER()OVER (order by IdObj) AS ROWNUMBER FROM Tab1 RETURN

или вот

ALTER PROCEDURE spProssmOrganiz @IdOrg int AS DECLARE @KodRay int DECLARE @KodObl int SELECT @KodRay = TblSOATO.KodRn FROM TblSOATO INNER JOIN TblKlassOrgan ON TblSOATO.IdSOATO = TblKlassOrgan.IdSOATO WHERE TblKlassOrgan.IdKlassOrg = @IdOrg SELECT @KodObl = TblSOATO.KodObl FROM TblSOATO INNER JOIN TblKlassOrgan ON TblSOATO.IdSOATO = TblKlassOrgan.IdSOATO WHERE TblKlassOrgan.IdKlassOrg = @IdOrg SELECT dbo.TblKlassOrgan.UNPOrg, dbo.TblKlassOrgan.NaimOrg, dbo.TblKlassOrgan.Ind, dbo.TblKlassOrgan.IdBank, dbo.TblKlassOrgan.RShet, dbo.TblKlassOrgan.Terr, dbo.TblKlassOrgan.Ulica, dbo.TblKlassOrgan.DOMKV, dbo.TblKlassOrgan.TEFON, dbo.TblKlassOrgan.PRZAKAZ, dbo.TblKlassOrgan.PRPROEKT, dbo.TblKlassOrgan.PRPODRAD, dbo.TblKlassOrganUprav.NaimOrganUprav, dbo.TblSOATO.Name, (SELECT Name FROM TblSOATO WHERE (KodRn = @KodRay) AND (KodNasp = 0) AND KodObl = @KodObl ) AS NAIMRAY , (SELECT Name FROM TblSOATO AS TblSOATO_2 WHERE (KodObl = @KodObl) AND (KodNasp = 0) AND (KodRn = 0)) AS NAIMOBL FROM dbo.TblKlassOrgan INNER JOIN dbo.TblSOATO ON dbo.TblKlassOrgan.IdSOATO = dbo.TblSOATO.IdSOATO INNER JOIN dbo.TblKlassOrganUprav ON dbo.TblKlassOrgan.IdOrganUprav = dbo.TblKlassOrganUprav.IdOrganUprav WHERE TblKlassOrgan.IdKlassOrg = @IdOrg RETURN