You should open a new thread !!!

My view when on interviews as interviewee I try ussually to turn the table around to try to Identify the purpose of the questions being asked and assess the skills...

Definitely costly but is the best way to count the distinct values Good I/O needed for speed

In regards with the text datatype the only possible way is to splitt the...

Somehow sushila's link does not works for me

-- Temptable

SELECT c.code, p.id, p.name, SUM(c.paid) TotalPaid

into #T1

FROM table1 AS c

INNER JOIN table2 AS p ON c.id = p.id

WHERE c.code > ' '

GROUP BY c.code,p.id.p.name

HAVING SUM(p.paid) > 0

-- Use it...

Oracle's CEO

Yeah I meant He makes. True money is not everything but it makes life a lot easier ... most of the time

I don't really like him but wouldn't mind to make one half of what i makes

Ok if it works, that's fine!  I just don't like the variables because triggers are meant to be always multirow (front end can and most of the time will change)...

Another warning here: you can't have more than 256 columns in an XL worksheet

Let me try to dissect a bit what I posted to see if it makes sense for you:

tblReport(    PicID  --Picture

     , 100

  , 110  -- Line

  , 120  -- Line

  , 121 ...

1. You don't need that distintc in the inner query

2. I am going to guess:

select    a.editor

 , a.softname

 , a.version

 , count(a.hostname) total

 , case when suite = 0 then 'NO' ELSE 'YES' END...

Some more stuff:

On very rare occation nested triggers are usefull and even in that case I still try to go for other non-recursive method of accomplishing the same thing! Therefore...

This is a classic scenario of:

Fast,Cheap,Good --> Pick Two

I have been in that possiton quite a bit and even after my recommendation...

There IS an advantage to put a single select statement in stored procedures!!

Reasons:

1. if that statement is has parameters The previously compiled plan can be reused on the contrary ad-hoc is...