This is like taking your car to the shop and telling the mechanic, "My car doesn't work" and expecting them to know what...

I figured it was a stripped down version but yes you have to use if type logic for this. CASE is not used as a control block like a switch...

No that is not how case works in sql. You need to use an IF - ELSE construct.

And You should read up on sql injection. Your procedure is wide open.

Did you start launching pork chops at them immediately? Somebody really needs to educate that company on what...

You need to provide a few more details before anybody can be much help here. You will need to concatenate some strings but I couldn't begin to provide the syntax....

Here is an example based off the OP's criteria.

declare @GuidToFind uniqueidentifier = newid()

;with Derived (Line_GUID, Diameter, begin_measure, end_measure)

as

(

select @GuidToFind, 5, 108394, 24819570 union all

select @GuidToFind, 10, 45839290, 509589373

),

Guids(SomeValue, MyGuid)

as

(

select 1,...

--note about apply above--

If you wanted it to function more like a left join to either the function or the inline you could change the cross apply to an outer...

Here is another way that does your function logic inline.

SELECT PS.LineGUID AS LINE_GUID

,PS.PODSID

,PS.SystemName

,PS.LineNumber

,PS.LineName

,PS.RegulatoryTypes

,PS.OperatingStatus

,PS.Jurisdiction

,PS.Mileage

,PS.Operator

,PS.ProductTypes

,

--DerivedAsset.dbo.Get_PredominantDiameter(PS.LineGUID) as PredominantDiameter

d.Diameter

FROM DerivedAsset.dbo.PipelineSummaryMaster PS

CROSS APPLY (

SELECT TOP 1 Diameter

FROM DERIVEDASSET.DBO.EU_DIAMETER EU

WHERE EU.line_GUid = PS.LineGuid

GROUP BY Diameter

ORDER BY...

Robert.Sterbal (6/26/2012)

---

Professionally I help manage 500+ small SQL Server installations. We have 5 to 100 devices per install. I'm trying to automate manual processes and collect data for verification and...

What do you mean they work wrong??? The don't work wrong but each of them does...

I guess that depends on what you want to...

WOW that really stinks!!! Wish there was a way to recoup the poor influence. Maybe Amazon will be able to...

You will have to use dynamic sql for this and add the database to each object you are querying.

http://poorsql.com is a free online one that seems to work fairly well.

hiteshchouhan91 (6/26/2012)

---

Thank you for your help,

column import and issue values showing me 2200 and 600

but actual total of these column is 1100 and 300 respectively

i want that it should be...