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.
| Author |
Topic |
|
alph2004
Starting Member
7 Posts |
 Posted - 2004-11-19 : 06:13:53
|
| Hi,Does any one have any idea why when I run a SELECT stament in Query anaylser it returns 45 rows. But when I create the exact same SQL as a view in Enterprise manager it only returns 44 rows? Alph. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-11-19 : 06:28:24
|
post the query and create view script...Go with the flow & have fun! Else fight the flow  |
 |
|
|
alph2004
Starting Member
7 Posts |
Posted - 2004-11-19 : 06:41:16
|
| spirit1,the query is a union so its 'quite' big, here is the first select:Create View vBCWSCostCheck asSELECT dbo.tblWBS.PSWBS AS [PSWBS Code], ConcatenatedWBS AS [CWBS Code], case when CR is null then 'R' else 'C' end AS [Capital / Revenue], NDACost AS [Cost Element], SUM(dbo.udfBCWScost (NDACost,FiscalYear,Apr_Cost,dbo.tblWBS.PSWBS )) as Amount,'01-04-' + ltrim(rtrim(str(FiscalYear))) AS [Start Date], '30-04-' + ltrim(rtrim(str(FiscalYear))) AS [Finish Date],left(dbo.tblWBS.wbs,6) + Right(dbo.tblWBS.wbs,5) AS [Charge Code]FROM dbo.tblBCWSMonthly INNER JOIN dbo.tblBCWSYearly ON dbo.tblBCWSMonthly.RecordId = dbo.tblBCWSYearly.RecordUid INNER JOIN dbo.tblWBS ON dbo.tblBCWSYearly.WBSUId = dbo.tblWBS.WBSuidWHERE (dbo.tblWBS.EPSLvl4 = N'1.1.5.17') and dbo.tblWBS.PSWBS = '1.1.5.17.10.01.17001.00000.30 ' and dbo.tblWBS.PSWBS = '1.1.5.17.10.01.17001.00000.30 'GROUP BY dbo.tblWBS.PSWBS, ConcatenatedWBS, CR, NDACost,'01-04-' + ltrim(rtrim(str(FiscalYear))),'30-04-' + ltrim(rtrim(str(FiscalYear))),dbo.tblWBS.wbsHAVING SUM(dbo.udfBCWScost (NDACost,FiscalYear,Apr_Cost,dbo.tblWBS.PSWBS )) <> 0 Union All>>> then another 11 select statments |
|
|
|
|
|
|
|
|
Different no. of rows returned in SEM than QA