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...

I don't see any need for dynamic sql here. What about just using IN?

where ITEMMAST.STYLE in (Select STYLE from TEST)

Lynn Pettis (6/20/2012)

---

That's fine, but I helped with the code so I am just curious...

OK so I posted some of your last post for reference. I commented out a number of lines and replaced from there to the end of your code.

--DECLARE @TABLE ...

I got it Lynn. Should have the solution in just a couple minutes. 😀