Or just remove the subquery as it really isn't needed.

SELECT

ESO_PORT,

sum(case when ONTIME_S = 'On Time' then 1 else 0 end) as Ontime_s,

...

One of the important elements in deciding on a natural key vs a surrogate key is to determine if the value you pick is going to change. In the first...

R.P.Rozema (8/16/2011)

---

Sean Lange, I hadn't yet seen the additional requirement of skipping 0's when I wrote my reply. That is why yours looked over complicated to me. Sorry about that.

Of...

troe_atl (8/15/2011)

---

Thanks Sean. I will look at a better way to code this. I actually inherited this database and I’m trying to modify it the best way possible without reinventing...

No worries. 🙂 Happens all the time. Good luck. 😉

Theknee (8/15/2011)

---

Thanks SSCrazy

This is not the way I expect to see the problem to be resolved, But this will work.

I'm not the DB designer for this project, but from...

Like the previous poster said, you only have two inserts.

that being said I would start with "what am I doing wrong"? You are managing your own identity type data.

...

Are you looking for a way to have sql server pop an input box to capture this email? If so, there is no visual component of SQL server. That would...

The ALL operator is interesting. Seems to make this awfully complicated though. Try this.

DECLARE @a int = 102733019,

@b-2 int = 102733019 ,

@c int = 0

select case when

(@a = @b-2 and...

I hope you are not using a UniqueIdentifier as your primary key. There are a zillion reasons that is not a great idea. But you can "roll your own" UniqueIdentifier...

With the huge amount of variance in the size of the fields you are facing a slow search process no matter how you slice and dice this. At first I...

tomperson349 (8/12/2011)

---

I know. I am brand new employee at this company. Its only my 2nd week. I havent been given SQL Server 2005 access yet. So for the past week...

This isn't quite 100% but it is very close...just a little tweaking on the substring math and you should be there.

create table #Test

(

Label varchar(101)

)

insert #Test

select 'Lorem ipsum dolor sit amet,...

Just a suggestion but you should build you sql in ssms and then move you query to your code. You are fighting too many battles at the same time. Get...

You do not need a variable to hold Result1. You do however need to convert your date to a varchar of some type if you are going to put 'N/A'...