what query are you using to generate the table of data (the id risk rating...)

not really can you put the output you would like to see? something like this:

cat ...

ewhitaker (4/13/2012)

---

small edit..mistyped something

--------------------new sql statement--------------

select 'a' + convert(nvarchar, risk_rating) as cat,

count(distinct orderfindings.prnt_id) as stat

from orderheader, orderaudits, orderfindings, orderagencies

where orderheader.id = orderaudits.orderheader_id and (orderaudits.ID = orderfindings.prnt_id or orderaudits.ID = orderagencies.prnt_id...

you need to add the missing dates to the data source. if the dates are...

urgal

SQLRNNR (4/13/2012)

---

L' Eomot Inversé (4/13/2012)

---

Jeff Moden (4/13/2012)

---

capn.hector (4/13/2012)

---

ok on topic: http://www.sqlservercentral.com/Forums/Topic1283271-392-1.aspx how do you long time posters keep going when you run into people like this. (one...

Lynn Pettis (4/13/2012)

---

You can performance tune a proc but can't trouble shoot this error? Pretend it is an interview question and show us what you would do to solve...

here it is posted here

CREATE TABLE orderheader

(id int)

CREATE TABLE orderaudits

(id int,

OrderHeader_ID int,

Risk_Rating int,

Investor_Name nvarchar(50))

CREATE TABLE orderfindings

(id int,

Prnt_ID int,

Finding_nbr char(10)

)

CREATE TABLE orderagencies

(id int,

Prnt_ID int,

Agency_nbr char(10)

)

insert into orderheader

values (1)

--------------------------------------------------

insert into orderaudits

values (1,1,1,...

also from the specific times there was probably a query in the company some one tuned from 20 min to 2 seconds and the interviewer knows exactly what was done...

hbtkp (4/13/2012)

---

OK,

BASICALLY PITEM AND PITEM4 Calling function fitem and fitem4

now this two function item has data for some fromdate and to date and values

item4 has fromdate,todate and vales,but for all...

jitendra.padhiyar (4/13/2012)

---

Yes, I am asking question. I have not observe it before but i attended an interview and inverviewer asked me this question " What is update state?"

So i want...

Wow. um no. considering i still dont have all the info i requested in a nice readable format and now you seem to be...

i was looking at this and seeing your code just made me realize how much i need to learn to think about problems better.

hbtkp (4/13/2012)

---

i dont need to change field, i have filed

CREATE FUNCTION item1(@Data [varbinary](max))

RETURNS TABLE (

item2 varchar,

item3 int)

now i need to...

hbtkp (4/13/2012)

---

i think i will lost my job , i am on dead line

i m trying to help u as much as possible.

there is nothing in sp, sp calling...