Posts
 
Reputation
Joined
Last Seen
Ranked #237
Strength to Increase Rep
+10
Strength to Decrease Rep
-2
99% Quality Score
Upvotes Received
67
Posts with Upvotes
62
Upvoting Members
50
Downvotes Received
1
Posts with Downvotes
1
Downvoting Members
1
28 Commented Posts
~224.16K People Reached
Interests
Woodworking
Favorite Tags
mysql x 236
c++ x 157
mssql x 120
c x 46
Member Avatar for kutta_vin

Hello friends, I am new to this site, this is my first post, My question is.. How to calculate the one rows value for next row value? [code=sql]select @rownum:=@rownum+1 "sl.no", b.bus_activity_desc "Type",r.trn_no, o.Office_name,o.Address,o.Address2,o.Address3, DATE_FORMAT(r.trn_date,GET_FORMAT(DATE,'EUR')) as trn_date, l.Account_id , if(r.trn_type=6,r.total_trn_value,0) "Credit", if(r.trn_type=7,r.total_trn_value,0) "Debit", if(r.trn_type=6 ,@cbal:=(r.total_trn_value+@cbal),@cbal:=(@cbal-r.total_trn_value)) "Closing Balance" from(select @rownum:=0) s, office_master …

Member Avatar for Mukoro
0
2K
Member Avatar for JoBe

Hello ladies and gents, Chapter 3 exercise 3-1: [quote]Suppose we wish to find the median of a collection of values. Assume that the we have read some values so far, and that we have no idea how many values remain to be read. Prove that we cannot afford to discard …

Member Avatar for Alfonso_4
0
845
Member Avatar for GFXtm

I have the following table: my_contacts which contains the following columns: [CODE]contact_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, frist_name VARCHAR(20), interest VARCHAR(20)[/CODE] [CODE]-----------+-----------+---------- contact_id | fisrt_name | interest + ---------------------------------- 1 | smith | swim + 2 | mark | dance + ----------------------------------[/CODE] I need to move the interests column …

Member Avatar for Asish_2
0
2K
Member Avatar for darren110690

can i ask something whats the used of [B].org 100h[/B] in assembly language..., and why it is 100h why can/t it be 60,70,80 or 90h? tnx :)

Member Avatar for Reverend Jim
0
24K
Member Avatar for Noxes

I am currently using Dev C++ program for the program I write in. I was wondering if there are any free download programs out there that are a text editor? I mean by giving it a black background, certain key words are highlighted to different colors? I know there is …

Member Avatar for ChampRocks
0
2K
Member Avatar for rythreion

hi!im new in c++ i need help how to make a software that convert any number that the user will enter and convert it in any base that the user will enter. It will convert it and show the result.

Member Avatar for NathanOliver
0
4K
Member Avatar for dany12

What do you think about PL/SQL ? Is this a language worth learning for the feature along with SAP?

Member Avatar for user123454321
0
209
Member Avatar for hermanSA

Hi, I need to retrieve only 1 row for each 'message_id', with the Latest Date('sent_date'): ------------------------------------- message_id | sent_date | ------------------------------------- 805 | 2010-08-04 17:48:24 | <--- 805 | 2010-08-03 17:48:24 | 1007 | 2010-08-07 17:48:24 | 1007 | 2010-08-09 17:48:24 | <--- 1007 | 2010-08-08 17:48:24 | ------------------------------------- The …

Member Avatar for guruparthi
0
624
Member Avatar for rayborn66

Hi I need some help. I am trying to write a program that will search a file for numbers of type int and write the largest and the smallest numbers to the screen. This is how far I got but when I it came to writing the code that would …

Member Avatar for Emran__
0
2K
Member Avatar for somename

Hello. I am trying to find out how to write a function to replace a string in a text file. So far i got this: find -> is a word i am looking for replace, rep -> new word, f1 -> my file. And i'm stuck with that piece of …

Member Avatar for deceptikon
0
3K
Member Avatar for scapu

Hello, Can anybody help me in this program. [B]Write a C program to find the square root of a given number?[/B] I can understand only C and please i need answer in C only. In this question i should not use function and i have to write a code for …

Member Avatar for goyalPriya
0
3K
Member Avatar for mjuni

I am tasked with designing a dating site in asp.net with VB using sql server 2005 as the database platform. I have not had a lot of advanced database design experience so I am hoping someone can help me out with this one.... For each user there is a profile …

Member Avatar for atifcomputerz
0
4K
Member Avatar for arbazpathan

i have two tables in my sql database one is "vendor" and other "purchase_order" they both have one common attribute "vendor_name" my problem is that i want vendor name in my "purchase_order" table to be same as that in "vendor" table but vendor_name is not a primary key in "vendor" …

Member Avatar for adam_k
0
173
Member Avatar for shankhs

can anybody suggest me whats wrong with the code?? [code] #include<iostream> #include<string> using namespace std; void rev_str(string str,int n) { while(str[n]!='\0') rev_str(str,++n); cout<<str[n-1]; } int main() { string str="shankhs"; rev_str(str,0); return 0; } [/code] thanks

Member Avatar for venugopal.somu
0
500
Member Avatar for WithnoMute

Hey, i am learning from Programming from the ground up. I am having a bit of trouble with the pushl and popl commands. I'm a newbie with ASM and really just starting out on it, i am on a x86-64 im presuming it will run the x86 32bit code. I …

Member Avatar for jmarbas
0
773
Member Avatar for mithunp

This version1 of the code is a recursive function to print n to 0 values, but there is no return statement, is it using the return value of printf The version 2 of the code prints from 0 to n,and it worked even if we remove the return keyword as …

Member Avatar for Smileydog
0
168
Member Avatar for cl2020

I have a palindrome set up in the system, and running fine. However, when I type "never odd or even" or "A Man, A Plan, A Canal, Panama", it didn't run properly as if these words in quotation marks are considered palindromes. Where is the loophole on my code re: …

Member Avatar for youjean
0
327
Member Avatar for tuse

I need to check if a databse user exists and if not, create that user. However, I do not know the statement to check if a user already exits. How to check if a user already exists in MySQL?

Member Avatar for Offirmo
0
1K
Member Avatar for tanha

Hi, I would like to track students activities by the teacher and this is visible by the students parents "dependents" and therefore the parents could give comments to the activity issued by the teacher and the teacher could respond to parents comment too. So I designed the ER Diagram, but …

Member Avatar for tanha
0
145
Member Avatar for network18

what;s wrong with this mysql trigger logically?? [CODE] DELIMITER | CREATE TRIGGER comment_count AFTER INSERT ON comments FOR EACH ROW BEGIN UPDATE sub_sections as t1 SET t1.published_comment_count = (select count(id) as cnt from comments where article_id=t1.id and published=0 and status=0) WHERE id= (select article_id from comments order by date_modified desc …

Member Avatar for Morta
0
214
Member Avatar for mertucci
Member Avatar for JerieLsky

Hi, I'm having a problem on how to query from the following tables. Here are the tables. PATIENT: PK - PatientNo - FirstName - LastName - MiddleName - Address - Age FK - PageNo PAGE PK - PageNo BOOK PK - BookNo BOOKPAGE 'Junction Table PK - BookNo PK - …

Member Avatar for pratik_garg
0
144
Member Avatar for valeriy_zf

How to start using the GNU Octave libraries for Visual C++? I've read carefully the site but couldn't find any info how to start working with it in details. Especially I'm interested in this example: [url]http://www.gnu.org/software/octave/doc/interpreter/Nonlinear-Equations.html[/url] Starting from words: "Here is a complete example..." I wanna see this in C++ …

Member Avatar for Manlin86
0
3K
Member Avatar for jakesee

Hi, I have a table `Categories` with fields (category_id, category, parent_category_id) I want to write in a single query to replace the parent_category_id with the corresponding category_name. [CODE] // OBJECTIVE: To return all category names and parent category names // if category is root (no parent), parent category name is …

Member Avatar for OVOVO
0
375
Member Avatar for macausite

I want to create a social website which people can share their photos with friends and I don’t know if it is correct or there is something wrong with it. I would be very grateful if someone could have a look at it and give me some feedback on it. …

Member Avatar for babannasd
0
92
Member Avatar for peanutz

I need a query that will find for example in the given table Distinct Col1, with highest Col3 [CODE]A X 1 A Y 2 A X 3 B Y 2 B Z 4[/CODE] So the result should be: [CODE]A X 3 B Z 4[/CODE]

Member Avatar for 1stDAN
0
123
Member Avatar for kartheeee

Hi, I have oracle table for Leave LeaveNo FromDt ToDt 1 01/01/2010 31/03/2010 2 01/02/2010 31/05/2010 3 01/04/2010 30/04/2010 4 25/04/2010 15/05/2010 5 01/05/2010 31/05/2010 I want find out who was leave on 01/04/2010 to 30/04/2010. how to write oracle sql? tks in advance kartheeee

Member Avatar for NeverLift
0
135
Member Avatar for jwebbo

Hi everyone,i am seeking your help. I am trying to program the PIC 16f877 microcontroller to accept multiple analog inputs and give readouts on the 7-seg display. the conversion is of a 10 bit resolution. my problems are that i cannot seem to get the pic to correctly display the …

Member Avatar for 3ak
0
109
Member Avatar for usman6062

Hello guys, I am having a weird problem. I cant understand and i have spent almost 2 hours in finding the problem. Well,Actually I have a table of id,date,comment. id and date are composite primary key. so id always starts with 1 everyday. now i want to find the max …

Member Avatar for naveedanjum
0
137
Member Avatar for lewashby

I just got postgresql & pgAdmin III up and running. I'M trying to start the book "Simply SQL" so how do I go about getting to .sql files for the book into pgAdmin? Thanks for any and all replies.

Member Avatar for lewashby
0
149