Viewing 15 posts - 7,096 through 7,110 (of 8,760 total)
Quick questions, was this working before and you just br:w00t:ke it or is this the first implementation?
😎
September 13, 2014 at 9:27 am
Good stuff you figured this out;-) and yes it is getting quieter, which is probably not a bad thing. I for one don't miss 2K although every now and a...
September 13, 2014 at 9:23 am
rajnidas.y (9/11/2014)
SELECT debit.ACCOUNT_NO, debit.Serviced_Amt,credit.Tran_Amt,credit.Serviced_Flag
FROM tbl_Interest_Debit as debit
inner join
tbl_Credit as credit
on debit.ACCOUNT_NO=credit.Account_No
order by credit.TRANSACTION_VALUE_DATE
getting result
-------------------
ACCOUNT_NO Serviced_Amt Tran_Amt Serviced_Flag
------------ --------------- ------------ ------------
455050006611013088.0019157467.000
455050006611013088.0018988.960
33105126375286533.00171084.000
33105126375286533.00500000.000
33105126375286533.001000000.000
33105126375286533.00800000.000
33105126375286533.001000000.000
33105126375286533.001000000.000
I want that service_amount should be subtracted from tran_amt...
September 13, 2014 at 9:16 am
Mr.Sahand (9/13/2014)
Has anyone used Fuzzy Lookup with ms access tables here?
I am tring to connect two Access tables as the source and lookup using Fuzzy Lookup. After choosing...
September 13, 2014 at 8:46 am
G-Force (9/12/2014)
September 13, 2014 at 8:30 am
Jeff Moden (9/12/2014)
This sounds an aweful lot like an interview question.
Yep, sure smells like one
😎
September 13, 2014 at 5:51 am
Here is a quick solution, should help get you passed this hurdle. It demonstrates that you can use INNER JOIN and retain the full details of the set by using...
September 13, 2014 at 5:14 am
Hi and welcome to the forum.
Could you post the DDL (create table script) and possibly some sample data, makes it easier to provide an accurate answer, for more information,...
September 13, 2014 at 3:44 am
Quick thoughts, there is quite some room for improvements such as using a single variable instead of the getdate function, a case statement can be replaced by simple arithmetic "12...
September 13, 2014 at 12:16 am
Quick thought, there is no need for a self-join as this is an elementary set problem which is easily solved using the window functions in SQL Server 2005 or later.
USE...
September 12, 2014 at 11:17 pm
karunakar2351 (9/12/2014)
Hi,I have two tables
Table1 Table2
1 5
2 6
3 7
4 8
How to swap table2 values in Table1 & Table1 to Table2...?
It depends on what exactly you want to do, you can...
September 12, 2014 at 2:18 pm
abhas (9/11/2014)
Hi all,in addition above.
Hi,
put varchar datatype, why because actual data is like: Sorry for not mentioning earlier.
99.87%, 99.96%, 8.67%
and out put want as
99.8%
99.9%
8.6%
Thanks,
Abhas.
Here is a quick solution, should...
September 12, 2014 at 1:30 pm
SQLRNNR (9/12/2014)
Ed Wagner (9/12/2014)
GilaMonster (9/12/2014)
Lynn Pettis (9/12/2014)
SQLRNNR (9/12/2014)
GilaMonster (9/12/2014)
Um... http://www.sqlservercentral.com/Forums/Topic1612868-3411-1.aspx ????I invoke the barge pole rule.
2nd that. Does the motion pass??
Motion passes with no objections.
Without objection, it is so...
September 12, 2014 at 10:40 am
Viewing 15 posts - 7,096 through 7,110 (of 8,760 total)