15,881,882 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by kankeyan (Top 26 by date)
kankeyan
13-Feb-15 0:17am
View
For Example i given that same query.
I need to screenshot the query and result in two different location based on the condition.
kankeyan
12-Feb-15 12:47pm
View
But in a else part it's running everytime. if cnt > 0
kankeyan
18-Dec-13 3:02am
View
Use Trigger
kankeyan
7-Nov-13 7:26am
View
not in group by i said in inner table
ex
select* from
(
select *
CASE When EarlyPayment.Amount=NULL or EarlyPayment.Amount='' then 0 else EarlyPayment.Amount END
from tblname (is inner table)
)a (is outer table)
kankeyan
7-Nov-13 6:25am
View
use
select @date= urstoreddate
Select * From TableName Where convert(datetime, myDate, 103) >= convert(datetime, @date, 103)
--'03/09/2013'
kankeyan
7-Nov-13 6:11am
View
case when EarlyPayment.Amount='' then 0 else EarlyPayment.Amount END as Amount
use in inner table
kankeyan
7-Nov-13 6:05am
View
Most Welcome
kankeyan
7-Nov-13 5:52am
View
use derived tables
kankeyan
7-Nov-13 5:35am
View
use self join
kankeyan
1-Nov-13 3:28am
View
use where condition for update and delete, for particular record
kankeyan
1-Nov-13 3:26am
View
http://w3schools.com/sql/default.asp
kankeyan
22-Oct-13 6:44am
View
Use Top 1 or distinct. If sal is 1000,999,999,998. If you use RowNumber third highest salary is 999 is it correct?
kankeyan
22-Oct-13 4:23am
View
This case we need to use dense_rank not row_number. If rate is equal row_number will not work properly dense_rank is right solution.
kankeyan
21-Oct-13 8:07am
View
Copied solution only for this case we need to use dense_rank not row_number. If rate is equal row_number will not work properly dense_rank is right solution.
kankeyan
14-Aug-13 3:58am
View
Concat the two columns
kankeyan
4-Jan-13 8:31am
View
I worked on this query it will work fine.
kankeyan
4-Jan-13 6:58am
View
Then use a Begin transaction and Rollback Transaction in two different Sp's you can try to insert a multiple rows by calling multiple times, once error found in particular record call rollback Sp if not then Call Commit Sp.
kankeyan
4-Jan-13 6:53am
View
BY using the above procedure u need to call multiple times to Insert the record
kankeyan
4-Jan-13 6:07am
View
If your logic will change in future what will you do? you will create or alter query in .net and the code begin larger and larger. Then surely it make u distortions. If in Stored procedure means you can just input the param and get the result set and display it. Make this as a practice for your career growth. Good luck to you my Friend.
kankeyan
4-Jan-13 4:27am
View
Hi ,
I think he forgot to compare with Where clause in Select Statement and i think there must be a input param.
kankeyan
19-Dec-12 4:50am
View
Whether the table contains NULL values.
kankeyan
7-Nov-12 7:09am
View
Once the transaction is commiteed it not possible while transaction only we can do. Otherwise if u have Log Files try to Rollback from that With the help of DB Admin
kankeyan
7-Nov-12 2:39am
View
You need to execute every statement
kankeyan
7-Nov-12 2:23am
View
We have written a function for this case in our project. Hope this will help.
kankeyan
2-Nov-12 9:05am
View
Deleted
above query will work
kankeyan
27-Oct-12 1:47am
View
Deleted
select order1, order2
from transaction_Master tm
Join ordering_master om ON tm.group_1= om.group1 and tm.group_2=om.group2
order by order1, order2
Show More