Viewing 14 posts - 1 through 15 (of 15 total)
AHHHHHHHHHHHHH ... was skeptical at first, but did what you said and it worked...made other adjustments ,,,but dude..seriously thanks..i just found out plan b today if it didnt..and you saved...
April 16, 2012 at 10:14 am
ah..ok..i will read up on it...thanks
April 16, 2012 at 7:56 am
ok, never seen that structure before haha..so would i just form the query around everything you pasted? and whats with the ";" at the beginning
April 16, 2012 at 7:28 am
i have 3 i'm playing with atm..trying to get 1 to work
1
select 'a' + convert(nvarchar, B.risk_rating) as cat,
(select count(distinct orderfindings.prnt_id) as stat
from orderheader, orderaudits, orderfindings
where orderheader.id = orderaudits.orderheader_id...
April 13, 2012 at 3:18 pm
cat stat
------------------------------- -----------
a1 5
a2 4
April 13, 2012 at 3:16 pm
i think my biggest problem atm is i'm not sure how to get it to go through each order individually ..like if i take group by out..for order 1 through...
April 13, 2012 at 3:07 pm
pretty much what i am trying to get out of it..is a1 to say 5..and a2 to say 4.....the pic http://imgur.com/Ot3GO ...the big table sorta shows the query minus investor...."if...
April 13, 2012 at 2:58 pm
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 )
and...
April 13, 2012 at 2:42 pm
ok..i think this will work..hoping at least ..this is a very scaled down version of what i'm dealing with..but all the essentials are there
April 13, 2012 at 1:13 pm
umm..i suppose i could create something..give me a couple hours..i'm literally about to have to goto lunch..and when i get back..that will be the first thing i do..unless someone solves...
April 13, 2012 at 10:45 am
been working more with it..my big problem now is tallying up the scores..i can only get one column 🙁 ..anyone know of a trick to get the right numbers out...
April 13, 2012 at 10:13 am
awesome!!! works like a charm!!
January 31, 2012 at 10:13 am
i will look at this tonight..and try it out tomorrow..thank you for you quick replies!
update 1: The sql server manager thing is ridiculously easy..cant wait to play with tomorrow!
January 30, 2012 at 4:08 pm
to be honest.. havent really tested anything..i really have no clue as to how to do this...from old posts i've seen..some people use windows task scheduler....and i saw one person...
January 30, 2012 at 3:48 pm
Viewing 14 posts - 1 through 15 (of 15 total)