Priceless!! no pun intended :)

Nino

Thanks everyone!!

Nino

Hello CP, I've been out of the programming loop for around 4 years now and now want to get back to it. I'm guessing there are a lot of changes since the 2005 version of VS.NET. Looking for any recommendations on getting back to it. Thanks In Advance

Nino

Good choice!! My wife picked our LCD TV which was the Samsung 42", old DVD movies even look good on the TV. You'll really like the HDMI for TV and DVDs.

Nino

We have an LCD, like the HDMI resolution. 42" Samsung, great picture and good price.

Nino

Hi Joan, Did you use the 32bit or 64bit. I'm actually going to install this today (if I can find a way to save my Daughters "SIMS" game settings :doh: ).

Nino

Thinking of going to Vista 64bit ver. I've heard good and bad as far as apps running atop this version of the OS. How does this run with MS Office and other non-MS apps. Thanks In Advance.

Nino

JimmyRopes wrote:

My wife has a look I call the "Khmer Eye".

In my house, we call it the stink eye :omg:

Nino

modified on Sunday, December 21, 2008 9:31 PM

Yep, all is well now though. I think all us married guys have been down the dubious path and worked through it :-D

Nino

Yes, was humbling experience :omg:

Nino

I have been there a couple of times, it's Cold, Lonely. Also learned to like bread and water X|

Nino

JimmyRopes wrote:

Maybe Canada can take some of the illegal immigrants from the US?

Starting in California :|

Nino

Wow, a pre-req of religious preference? hard to believe.

Nino

My reasoning behind that was to get the values of two different fields. The second part is getting the values for the 'S' which is defined as a "New" escrow sale. The third part is getting the values for the 'R' which is defined as a "Refi" or refinance. After these two fields are retrieved they are then added based on the escrow field based on the join.

Nino

Hi, I have a query that needs to act as one single query: Here's the first part:

select distinct a.officer as Officer, count(distinct(j.fstatus))as Escrow_Type, count(distinct(j.amount))as Amount, count(distinct(d.open_date))as [Open], count(distinct(d.close_date)) as Closed, count(distinct(can_date))as Cancelled

from a10 a
inner join escrow d on a.escrow = d.escrow
inner join e120 j on j.escrow = d.escrow where j.id_scr = 'e21 ' and j.fstatus = 'PAID' group by a.officer

Here's the second part:

x.amount as New from escrow k inner join e120 x on k.escrow = x.escrow
inner join a10 g on x.escrow = g.escrow where k.ftype = 'S' group by x.amount, g.officer having x.amount <> 0.0

Here's the third part:

b.amount as Refi from escrow c inner join e120 b on c.escrow = b.escrow
inner join a10 f on c.escrow = f.escrow where c.ftype = 'R' group by b.amount, f.officer having b.amount <> 0.0

Is there a way to make this act as one single query? I have an application that reads only one cursor at a time. Thanks In Advance,

Nino

Hi Colin, here's what i came up with:

select distinct a.officer as Officer, d.close_date as [Date], count(d.open_date)as [Open], count(d.close_date) as Closed, count(can_date)as Cancelled
from a10 a inner join escrow d on a.escrow = d.escrow inner join e120 j on j.escrow = d.escrow where a.officer is not null group by a.officer, d.close_date

Nino

Thanks for your post, Actually i'm attempting to get the count for each individual row and display it through QA. Thanks, Nino

Hi, I'm trying to select the COUNT for individual rows within T-SQL while performing a join as follows:

select count(a.officer as officer, e.open_date as opened, e.close_date as closed, j.can_date as cancelled) from
escrow e inner join a10 a on e.escrow = a.escrow inner join e120 j on e.escrow = j.escrow group by a.officer, close_date, open_date, j.can_date

Getting the following error while atempting this query: Server: Msg 170, Level 15, State 1, Line 3 Line 3: Incorrect syntax near ','. Is this possible in T-SQL Thanks, Nino

Great! thanks so much. Nino

Ok, I should have posted the entire code block, I tried the method listed above with the rest of the SELECT statement and get an error message as follows. Server: Msg 141, Level 15, State 1, Line 4 A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations. Here is the entire code block:

declare @totalsum money

select @totalsum = (sum(d.amount + d.debit)), a.officer, d.amount,d.debit, e.fullesc as ESCROW_AND_CITY_CODE, e.open_date, e.close_date, e.ftype, a.street, a.city, a.state, a.zip
from escrow e inner join a10 a on e.escrow = a.escrow inner join e120 d on d.escrow = e.escrow and a.officer is not null order by e.open_date

Thanks Nino