Viewing 15 posts - 31 through 45 (of 45 total)
John Mitchell-245523 (5/16/2012)
There must be another database that's using the same physical file names. Use the WITH MOVE clause as the error message suggests, and it should work.John
John the...
May 16, 2012 at 8:28 am
Wow, you taught me something new, though its been there and never used it before.
But your query does not return all data, as my query returns a few records with...
April 24, 2012 at 8:55 am
If by SSMS you referring to Sql Server Management Studio than follow this.
On the tool bar point to Query --> Results To --> Result to Text
Than your result will be...
April 24, 2012 at 8:06 am
Eugene Elutin,
Just out Curiosity, what’s the difference between the two queries as they return the exact same set of results?
selectt1.orig_branch_no,
t1.acct_no,
t1.amt as 'Transaction Amount',
RoutingNo = NULL,
t1.description,
t1.tran_code, (select t2.tran_code from history as...
April 24, 2012 at 7:48 am
CREATE TABLE History
(
branch int,
acct_no int,
amt double,
description varchar(255),
Create_dt date,
charge_code int,
tran_code int
)
INSERT INTO History
VALUES (410,1234567890,6000000.00,'DDACC IFO KAWASAKI','2011-08-02 00:00:00',756,262)
INSERT...
April 24, 2012 at 7:00 am
Please post your results once more. I don't think what you posted was the right result.
Ya its giving me weird results but I'm working around it, i will also appreciate...
April 24, 2012 at 6:42 am
Sorry Guys i got it right
Here is the query
selectorig_branch_no,
acct_no,
amt,
description,
create_dt,
charge_code,
tran_code, (select t2.tran_code from history as t2
where t2.tran_code in (157)
and t2.description like '%DDAC%'
and t2.create_dt = '20110802'
and t2.acct_no = t1.acct_no) as 'Charge Code',
(select...
April 24, 2012 at 4:51 am
Stewart "Arturius" Campbell (4/20/2012)
shani19831 (4/20/2012)
if you look closely you can see that some sums are computed for avg,...
Yes, this would be a case of a single transaction meeting the...
April 20, 2012 at 6:43 am
Wow Wow,
I have made a few changes and added few things to your code and the results are amazing, cant ask for better than this.
Thank you so much and wish...
April 20, 2012 at 6:21 am
Ok im busy modifying it to accomandate the actual tables, i see you have missed the filter in terms of tran codes but i will add it and get back...
April 20, 2012 at 5:16 am
Thanks Stewart "Arturius" Campbell
My brain is frozen at the moment and cant think any further but will have a look at the code and see if does guide, nevertheless thanks...
April 20, 2012 at 5:06 am
Hi guruprasad1987
Thank you, your help is very appriciated and thats really what i wanted.. i will just have to do the same the EFT and I will the other...
February 13, 2012 at 7:45 am
Hi Ramkumar.K
Your query works fine and did 60% of what i want or needed.
There are transactions missing or not retrieved by the query.
I noted Rim_no 30734 which has only...
February 13, 2012 at 7:30 am
Hi Ramkumar.K,
Yes im trying to write a query than save it a stored proc, than i will use management to create a DRL report wich calls the store proc.
This is...
February 13, 2012 at 6:11 am
Dude your table is missing a unique column, but you could try a distinct fucntion. that should help you
select distinct(*)
from employees
or you can use
the 'IN' function
February 13, 2012 at 5:28 am
Viewing 15 posts - 31 through 45 (of 45 total)