Comments by kirthiga S (Top 38 by date)

the month

That's what how can I do

My requirement is how to specify the conditions for monday of third week and other weeks

Ya It's working

It is a space

Yes Right

If ARR=0 RN becomes 0.When ARR again starts RN has to start again from 1

User Month Lmonth ARR RN
A1 200906 200902 1 4
A1 200907 200902 2 5

Thank you.
For above rows RN updated as 4 & 5. I need RN as 1 & 2.

Both questions are different

RN column is my expected output. For each User Month should be unique.
Ex. For User A1 Month starts from 200810 to 200907.

Thanks for your suggestion.. I post this as new query

Thank you.. It works.
I need one additional query. If ARR=0 then RN again starts from 1

Is there any posible way using cte

@Thava Rajan

Thank u. Your query is simple and working for my scenario. We can use this for limited case.

Hi need this for a requirement

Declare @Var1 Varchar(10),
@M201304 numeric(12,2),@M201305 numeric(12,2),@mth varchar(6)
Set @M201305 = 2000
Set @M201304 = 1000

Set @mth='201305'
Set @Var1= '@M'+@mth
Select @Var1

I have to get the numeric data as output for @var1
How to modify my query to achieve this

Its 365 only not 36525

It is consistent only. C3 should be (prev C4 * current C2) /365.

C4 should be prev C4 + current C3

Thank u Pallini.. The Eqivalent SQL 2008 query is

select Loan,InsNo,InsAmount,ROW_NUMBER() over(partition by Loan order by InsAmount )Rn into #1
from vary where InsNo<>0 order by Loan,InsAmount

select distinct Loan into #2 from #1 where InsNo-Rn<>0

select distinct a.Loan into #3 from a left join #2 b on a.Loan=b.Loan where b.Loan is null

I dont need data in descending order. I want the list of Loan Numbers where the Instalment amount in descending order.

Date format is not my query. My requirement is to calculate the amount on day basis.

How to modify this one to get my result..

select * from A join B on a.code=b.code where Address like '%Add1%'

Im having more than 4000 tables in my database. It is not easy to use select * into for all the tables. One more thing i want all constraints and indexes as it is.

Hi Karruksen,
Here positions are given manually. For single row its ok.. For multiple rows with varying position of delimiter i need a query.

Hi Prabhu,

If I have some internal grouping how to proceed the same.

My query's output is
Nos MyDate
1 2012-01-30
2 2012-02-29
3 2012-03-29
4 2012-04-29 and so on

My required output is
Nos MyDate
1 2012-01-30
2 2012-02-29
3 2012-03-30
4 2012-04-30 and so on

How to acheieve this??

Hi Aarti,
My query is working its not a problem but my question is how can i acheive my required result.. Just go through the examples i gave.

MS Excel 2003

Thank you..
I need this as a sql function. Is it possible

Thank u santhosh.. Its clear

Hi Santhosh,

Can you give any example for this scenario

Ya its working..