stored Proc - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

stored Proc

Author

Topic

rds207
Posting Yak Master

198 Posts

Posted - 2009-08-16 : 03:54:25

Can somebody help me writing a stored procedure for the below query?

select b.PhoneBuild,b.VERS,a.JobName,a.ApplicationName,a.Site,A.StartTime,a.EndTime,A.UserName,A.JobID,b.BuildID,b.MakeType,b.CLIENT,b.Built_DT,b.TYPE,b.BuildSize

From ASWProductionDatabase.dbo.BatchRecords a,ASWProductionDatabase.dbo.PHONE_VERSIONS b

Where B.PhoneBuild=(select distinct(b.PhoneBuild)from ASWProductionDatabase.dbo.PHONE_VERSIONS )

AND b.PhoneBuild LIKE 'M6%'
And left(B.phonebuild,2)=left(a.jobname,2)
And YEAR(built_DT)='2009' AND MONTH(BUILT_DT)='07'

ORDER BY Built_DT

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-08-16 : 04:25:33

[code]CREATE PROCEDURE dbo.usp_MyProcedureNameHere
AS

SET NOCOUNT ON

SELECT DISTINCT b.PhoneBuild,
b.VERS,
a.JobName,
a.ApplicationName,
a.Site,
A.StartTime,
a.EndTime,
A.UserName,
A.JobID,
b.BuildID,
b.MakeType,
b.CLIENT,
b.Built_DT,
b.TYPE,
b.BuildSize
FROM ASWProductionDatabase.dbo.BatchRecords AS a
INNER JOIN SWProductionDatabase.dbo.PHONE_VERSIONS AS b ON B.PhoneBuild = a.PhoneBuild
AND LEFT(b.PhoneBuild, 2) = LEFT(a.JobName, 2)
WHERE b.PhoneBuild LIKE 'M6%'
AND b.Built_DT >= '20090701'
AND b.Built_DT < '20090801'
ORDER BY b.Built_DT[/code]

N 56°04'39.26"
E 12°55'05.63"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources