Viewing 15 posts - 1,696 through 1,710 (of 2,894 total)
There are always ways to avoid CURSOR.....
Cannot agree with above.
There are cases when you cannot avoid using a CURSOR.
April 26, 2012 at 3:15 am
Lynn Pettis (4/25/2012)
Does anyone see anything wrong with this where clause?
Where PortfolioBaseCode = Replace(@Portfolios,'@','') as reportheading1
Let me try!
I think it is a sub-query (inner select) of the larger query.
Something inserting...
April 26, 2012 at 3:06 am
Again, the main aim of the vendor is not to produce good software but to sell any crap one for the profitable price to maximum possible number of customers.
I would...
April 24, 2012 at 9:52 am
There are no "reasonable threshold", as no-one in their right mind would keep cursors on the permanent tables opened for hours on every day...
They MUST change the design, or...
April 24, 2012 at 9:24 am
...
But your query does not return all data, as my query returns a few records with charge amount while yours only the first transaction and it ignores the rest...
The query...
April 24, 2012 at 9:14 am
...
It is amazing how often those of us in the field come up with far better solutions than the vendors come up with. Of course the stuff they come up...
April 24, 2012 at 8:59 am
What do you mean by "getting same value in qtd"?
You're setting and selecting single @qtd and you're getting the one selected!
You don't have any loop to expect "each value".
April 24, 2012 at 8:45 am
vahid.arr (4/24/2012)
i have userid pk and i want also make username and password field uniqe.how can i do that?
You can create unique index (or unique constraint) on username. Why do...
April 24, 2012 at 7:17 am
Grant Fritchey (4/24/2012)
April 24, 2012 at 7:13 am
The_Mo (4/24/2012)
just hypothetical representation of text
You need to explain your "match" and "no match" rules!
Are the match between data in tableOne and tableTwo is by DateValue only? By...
April 24, 2012 at 7:09 am
selecthA.orig_branch_no,
hA.acct_no,
hA.amt,
hA.description,
hA.create_dt,
hA.charge_code,
hA.tran_code,
hC.tran_code AS ChargeCode,
hC.amt AS ChargeAmount,
from history as hA
left join history as hC
on hC.tran_code = 157
and hC.orig_branch_no = hA.orig_branch_no
and hC.acct_no =...
April 24, 2012 at 7:05 am
cuirone-ServerCentral (4/24/2012)
April 24, 2012 at 6:59 am
If you only have maximum one "Charge" record per transaction and description always the same prefix with "FEE ON ", you can use:
selecthA.orig_branch_no,
hA.acct_no,
hA.amt,
hA.description,
hA.create_dt,
hA.charge_code,
hA.tran_code,
hC.tran_code AS ChargeCode,
hC.amt AS ChargeAmount,
from ...
April 24, 2012 at 6:54 am
Viewing 15 posts - 1,696 through 1,710 (of 2,894 total)