15,890,897 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 touseef4pk (Top 57 by date)
touseef4pk
19-Apr-16 11:43am
View
Chaa gay hen ap. Means you are great. Thanks for help.
touseef4pk
18-Jan-16 8:36am
View
Fiscal year means current financial year Yes we can derive it from RequestedOn like year(dateadd(M,-6,RequestedOn))
touseef4pk
18-Jan-16 8:30am
View
How can I show column of fiscal year along with the resultset so that each result should show data in each fiscal year?
touseef4pk
18-Jan-16 8:21am
View
Thanks. This is exactly what I require.
touseef4pk
18-Jan-16 6:57am
View
SELECT e.EmployeeId, e.FullName,ap.RequestedOn from Employee e join AdvancePayment ap on e.EmployeeId = ap.EmployeeId
WHERE ap.EmployeeID IN
(SELECT EmployeeId FROM AdvancePayment
GROUP BY EmployeeID HAVING COUNT (year(dateadd(M,-6,RequestedOn))) > 1)
This gives me records of all the employees who has taken advance twice in a fiscal year. But i am unable to get that how can I get records with following output
empId, Name, 1st advance date, 2nd advance date.
touseef4pk
8-Jan-16 9:16am
View
This is exactly what I was looking for. thanks Richard
touseef4pk
8-Jan-16 6:43am
View
with EmployeeAdvance
as
(
select year(dateadd(M,-6,RequestedOn)) as FiscalYear, EmployeeId
from AdvancePayment
where RequestedOn is not null
)
select e.FullName, FiscalYear, case when count(ea.EmployeeID) > 1 then 'Not Eligible' else 'Eligible' end as Status,
count(ea.EmployeeID)
from Employee e join EmployeeAdvance ea on
e.EmployeeID = ea.EmployeeID
group by ea.FiscalYear, ea.EmployeeID,e.FullName.
But its giving me duplicate records. I need records for current fiscal year only.
touseef4pk
23-Feb-15 13:30pm
View
We can't use database as well. It is mentioned in the question I posted :). However, I got the answer we can use http.context.cache.
touseef4pk
22-Feb-15 14:06pm
View
thanks actually I was interested in solution for multiple users across the application while your solution is perfect for accessing data across multiple pages for a single user
touseef4pk
20-Feb-15 15:03pm
View
I think u didn't read my question carefully. I said I just don't want to use Application variables
touseef4pk
20-Feb-15 12:13pm
View
Yes.. trying to fix it :D
touseef4pk
7-Feb-15 11:53am
View
I haven't said it is client side. What I want to ask is how will we use it in place of wcf where we generate proxies. What will do in this case ?
touseef4pk
2-May-14 1:07am
View
You need to use FTP in order to take backup to your local machine as remote and local machines are on different networks.
touseef4pk
26-Jan-14 7:28am
View
Karthik when I answered my question the cookies were exactly in my mind. So what I assume is even if we open new browser window the info will be available there unless you have removed cookies from your browser. But I am curious to digging it more to make sure I really have missed something crucial.
touseef4pk
3-Sep-13 1:25am
View
I am actualy tring ot get data from asp file in ajax success. Now with modification it is calling server but no data returns... parseerror i am receiving
touseef4pk
29-Aug-13 3:58am
View
Any help there ?
touseef4pk
18-Aug-13 16:11pm
View
sql servers.
touseef4pk
11-Jan-13 15:36pm
View
ProductId UserId Like
1 2 True
2 3 True
1 4 True
1 1 False
2 2 True
This is my my example data. Now for example productid 1 is liked by two users. I want that list/group of users for every product
touseef4pk
31-Dec-12 7:24am
View
I hadn't given this link. I am afraid it was automatically added due to viruse.
touseef4pk
27-Nov-12 4:02am
View
Thanks a lot Krunal. The answer was so simple.
touseef4pk
31-Oct-12 1:36am
View
My application is client side so I have to implement client side logic.. I am thinking of saving text string in difference js files corresponding to each culture
touseef4pk
19-Oct-12 7:24am
View
window.onerror is not working in any browser.. SO now ?
touseef4pk
4-Oct-12 10:53am
View
Thanks a lot Marcus
touseef4pk
3-Sep-12 17:13pm
View
this code does not make me any sense
touseef4pk
9-Aug-12 8:23am
View
Come on don't pretend to be a child.. He means how to know that a website is created in asp.net or something else php etc.
touseef4pk
6-Jul-12 7:29am
View
if there is no acceptable solution then what is point in saying no help :( There is no onfocus or gotfocus event in winforms C#.
touseef4pk
6-Jul-12 7:10am
View
Nobody has its answer ?
touseef4pk
28-Jun-12 4:05am
View
5+
touseef4pk
5-Jun-12 6:47am
View
thanks
touseef4pk
29-May-12 7:17am
View
thanks a lot
touseef4pk
4-May-12 6:51am
View
This forums is not for children who might be confused with a simple answer asking for verifying the solution being made by self effort :)
touseef4pk
21-Feb-12 12:16pm
View
extremply pooor and cheaaap ans..
touseef4pk
7-Feb-12 2:33am
View
I have checked this link but no help found there :(
touseef4pk
7-Feb-12 2:20am
View
I have checked WebServicex.net it does not provide sms fascility in Pakistan.. ??
touseef4pk
6-Feb-12 5:32am
View
yup ur ans is gr8
touseef4pk
20-Jan-12 11:35am
View
I am asking as a general guideline to display my mails in high priority and low priority panes. Any suitable method for it?
touseef4pk
9-Jan-12 7:29am
View
if someone asks you for help don't assume anything illogical considering yourself a programming psycheterist. Be ready to help others amicably
touseef4pk
6-Jan-12 7:02am
View
okay now keep exploring these links.. Will you find even a single topic on this ??
touseef4pk
6-Jan-12 7:01am
View
If you don't have answer about it then don't try to be scholar as you r father of Microsoft. Asking to someone about anything for learning is not as bad as is your answer.
touseef4pk
30-Dec-11 8:30am
View
I have already applied it but in vain as no profiling starts on IIS. To me surprisement, it works fine on Local IIS but not on server..?
touseef4pk
9-Dec-11 7:49am
View
@karthik
It is working somewhat and PageLoad of parent is being called when popup is closed but now it keeps executing PageLoad in a loop again and again. and giving this error "Microsoft JScript runtime error: Permission denied" and javascript message box appears of "Stack Overflow" ????
touseef4pk
15-Jul-11 0:32am
View
How Can i do this in MVC? What my model should pass to the View?
touseef4pk
13-Jul-11 4:54am
View
very poor answer...Please read my post thoroughly
touseef4pk
13-Jul-11 4:19am
View
Deleted
I am using edmx file.. Now the problem how to create my model class and what should i pass my view?
touseef4pk
12-Jul-11 7:32am
View
Thanks it helped... here my 5 :)
touseef4pk
5-Jul-11 1:46am
View
helpful tips..thanks it was problem due absence of primary key in the table.. My 5 here
touseef4pk
21-Jun-11 2:10am
View
The user control renders as ctl00_contentBody_DateControlLastExecDate_textBoxDate on the page....So my solution is I simply want that javascript function to be fired on this particular usercontrol(textbox) leave only..not on all the controls if they placed more than one..Ok if i add javascript function in usercontrol..Plz tell me how to handle that on contaning page?
touseef4pk
20-Jun-11 8:44am
View
If i add javascript in usercontrol then how will i fire javascript funcion on particular usercontrol(textbox) on onblur. The funciton will be fired on all textbox usercontrols placed more than one on the page?
touseef4pk
15-Jun-11 11:49am
View
thanks
touseef4pk
15-Jun-11 11:49am
View
thanks
touseef4pk
8-Jun-11 6:21am
View
this code did not work as Here I have an image which i have converted into thumbnail and then want to save that thumbnail to physical location
touseef4pk
6-Jun-11 9:47am
View
it is not working sir..it gives me.. D:\Touseef\Projects\HomeAlone\HomeAlone.Web\/Uploads/Chrysanthemum_3.jpeg..which is invalid path(having "\/") and image could not be found.
touseef4pk
1-Jun-11 8:06am
View
oh! i missed "()" of the close function..it is working fine now..
touseef4pk
31-May-11 8:40am
View
thanks it works now
touseef4pk
31-May-11 7:32am
View
Hi! i could not understand this code... what about the html which i have stored in variable(named html) of type string? How will i implement my logic in your code..?
touseef4pk
9-May-11 2:31am
View
I forgot to mention one thing that i am not allowed to use query string here. So i didn't go for that solution. Is there else pretty good secure solution?
touseef4pk
9-Mar-11 4:09am
View
Thanks sir
Show More