Viewing 15 posts - 7,081 through 7,095 (of 8,753 total)
martinghale (9/12/2014)
Thanks! That is definitely looking to be the one to use. Wasn't sure if there were any other options that were as complete as their list.Thanks again!
Martin
I've...
September 13, 2014 at 12:10 pm
Mr.Sahand (9/13/2014)
Thanks. MSDn says the ref can only be SQL table. Does not it suck??!!
Feel your pain mate, and be prepared, this may not be your last stumbling block using...
September 13, 2014 at 12:01 pm
g_rose42 (9/13/2014)
i...
September 13, 2014 at 11:41 am
...and if you select substring([column],1,2) from the table?
😎
September 13, 2014 at 11:26 am
Mr.Sahand (9/13/2014)
We are using SSIS 2012. No we don't have a plan to dump data in SQL.I know that it can be used in MS Excel.
Almost any consumable data...
September 13, 2014 at 11:16 am
Assume you are using SSIS and CDC components, have you checked the credentials, expired password?
😎
September 13, 2014 at 10:10 am
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
Viewing 15 posts - 7,081 through 7,095 (of 8,753 total)