Monday, November 14, 2011
DECLARE @sqlStatement nvarchar(max)
Declare @ErrNo Int
SET NOCOUNT ON
Declare @RowCounter int
Declare @Rec_count int
Declare @Rec_start int, @Rec_End int
set @Rec_End = @Rec_start + @PageSize -1
SELECT ROW_NUMBER() OVER (order by tblCustomers.CustomerId asc ) AS RowNumber,
CONVERT(varchar(9), @RowCounter) as 'RowCounter' ,
isNull((Select Sum(isNull(Amount,0)) from tblCustomerCommission where tblCustomerCommission.CustomerId=tblCustomers.CustomerId),0) as 'TotalCommission'
Where RowNumber between @Rec_start and @Rec_End
Wednesday, November 9, 2011
NextResult() function is used for handle m results by using the DataReader
SqlDataReader reader = cmd.ExecuteReader();
for (int field = 0; field < reader.FieldCount; field++)
} while (reader.NextResult());
Tuesday, November 8, 2011
public Object Compute(
expression (The expression parameter requires an aggregate function. )
The expression to compute.
filter (filter, determines which rows are used in the expression)
The filter to limit the rows that evaluate in the expression.
private void ComputeBySalesSalesID(DataSet dataSet)
// Presumes a DataTable named "Orders" that has a column named "Total."
table = dataSet.Tables["Orders"];
// Declare an object variable.
sumObject = table.Compute("Sum(Total)", "EmpID = 5");
Thursday, October 8, 2009
Tuesday, July 7, 2009
Tuesday, April 15, 2008
Tell me something about yourself?
I believe in characters, values, vision and action. I am quick learner. I learn from my mistakes and others. I try to get a creative solution to problem.
Why do you want to job?
To survive my life, we need income source. For that there are two ways, one is business and second is job. For business, we need big place, much money and deep knowledge of business that I don’t have. For job, I have interest, qualification and working attitude. I have, that’s why I want to do job.
Why we should give you this job?
What is the required qualification, I have. Everybody has some qualifications that are waiting for his turn. I can say only myself because I know my knowledge and quality which will fulfill your requirement. I will not give u chance to repent on my selection that’s why I should be given a chance to work with this dynamic organization.
How can you say “you are best deserving candidate”?
What I am saying to you by words, it can’t be prove by the words. For that, a person should be chance to work. I assure you if I get a chance I will live up to your expectation.
What is your strength or positive point?
What is your weakness or negative point?
Sometimes I get nervous when I talk to my seniors.
I am workaholic.
More time to get decision
How do you overcome your workaholic nature?
I have some good friends, when they see me in this condition, they come to me and they make me aware. Because of my friends, I overcome this my weakness.
Define yourself in one word?
Chirpy or Amiable
How long will work with us?
As much as possible, I will work with this company.
If we reject you, how would you react?
I will congratulate that person, who got select their. I will say u to thanks to get me a chance to prepare myself for a good job, because you give me a chance to observe my demerits.
What is ideal job according to you?
Ideal job is that where we can use an education and professional qualification, where we can get a chance to explore our knowledge.