15,899,014 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 krishnaraosan (Top 10 by date)
krishnaraosan
7-Mar-19 2:15am
View
Hi i havent tried iam new to c#.
krishnaraosan
7-Mar-19 2:14am
View
Hi i havent tried iam new to c#.
krishnaraosan
8-May-18 2:38am
View
i need to join with master table for all accounts not only for one account
krishnaraosan
13-Dec-17 2:41am
View
In table i have rows
AccountNo Remarks Month
Q49457 Abandoned 10
Q49457 Abandoned 11
Q49457 Locked-2 9
Q49458 Locked 11
Q49458 Abandoned 10
Now i want Output based on accountno month wise as below
AccountNo 11 Month 10 Month Remarks 9 Month Remarks
Q49457 Abandoned Abandoned Locked-2
Q49458 Locked Abandoned
krishnaraosan
13-Dec-17 2:06am
View
I have not used any query i am expecting query from you
krishnaraosan
24-Nov-17 0:23am
View
SO HOW CAN I GET RECORDS FOR NULL VALUES AND QUARTERLY IN ONE QUERY
krishnaraosan
24-Nov-17 0:13am
View
Iam using same query in the where condition it's not getting records for null values.I can fetch records when frequency is quarterly but not for null values.
select * from MASTER
where FREQUENCY=(CASE WHEN FREQUENCY IS NULL THEN 'MONTHLY' ELSE 'Quarterly' END)
krishnaraosan
23-Nov-17 23:52pm
View
I have column name frequency where it consists value null and Quarterly
FREQUENCY--Column Name
NULL
Quarterly
Please find the query below.
I want to fetch records for both null value and quarterly.With the below query only null values records are fetched not quaterly
select * from MASTER
where FREQUENCY=(CASE WHEN FREQUENCY IS NULL THEN 'MONTHLY' ELSE 'Quarterly' END)
krishnaraosan
23-Nov-17 6:49am
View
I have column name frequency where it consists value null and Quarterly
FREQUENCY--Column Name
NULL
Quarterly
Please find the query below.
I want to fetch records for both null value and quarterly.With the below query only null values records are fetched not quaterly
select * from MASTER
where FREQUENCY=(CASE WHEN FREQUENCY IS NULL THEN 'MONTHLY' ELSE 'Quarterly' END)
krishnaraosan
23-Nov-17 6:06am
View
YES NULL VALUES ARE THERE .
I WANT QUERY WHEN VALUE IS NULL IT SHOULD SHOW AS mONTHLY or Quarterly in where condition to flter
Show More