Can you explain the rules behind why ID 1 returns 1 value and ID 5 would return 2?

Check out the articles, they discuss pivot as well. 😛

First things first...I formatted this so myself and others can read it. You can help the legibility of your long code posts better by using IFCode shortcuts.

<-- They are...

Yes there is. Take a look at the cross tabs articles referenced in my signature.

Lowell (6/21/2012)

---

yeah but your answer is actually better; least amount of access is the best;

my example was...

This it totally untested because you didn't post any ddl or sample data but...

SELECT t.OriginCity

,t.Destination

,sum(case when t.FlightNumber IS not null and f.OriginAirportCode IS not null and c.BoardIndicator = 'Y' then...

L' Eomot Inversé (6/20/2012)

---

The thread seems very quiet. I've been away three days and there are only 62 new posts on it.

But I may not find...

Looks like Lowell and I were typing at the same time. 🙂

Why do you want to do this via triggers? Why not handle it with standard permissions? Only allow select to other users and allow insert/update/delete to the role these other...

Well I am not totally sure what this table holds. Is this answers to questionnaire or something along those lines?

I would create tables for Company, Organisation, Region, Contact (or person)...

You have a couple of serious issues going on here. First this table structure is a type of EAV which is absolutely horrible to work with. This is even worse...

OK so you open RDP and type in the server name...what error message do you get? This of course has absolutely nothing with sql server but we can try to...

Prasad.N (6/21/2012)

---

hi all ,

Regarding above issue I got a answer

declare @var1 varchar(5000)

declare @table table (ColNames varchar(5000))

insert into @table

----here i doesn't want COLUMN45,COLUMN46,COLUMN35(you need to write which columns doesn't want)

select...

ashuthinks (6/21/2012)

---

declare @AsOfDate DATETIME = '2012-06-20 00:00:00.000'

DECLARE @CSV NVARCHAR(4000) = ''

DECLARE @CurveFamily_Swap INT = dbo.GetConfigurationValue_Int('Fireball', 'CurveFamily -...

You are welcome. Glad the between us we were able to...