ROFL thanks Lynn!!! 😛

You know the one phrase I will always remember from my father is "Do you know where your best helping hand is located? At the end of your arm."

Nobody here...

asranantha (4/11/2012)

---

everything is avilable in google.at this time why maintaing this site.if any ;body know .simply sameif u know anserr tell why give this type of discussion.if u give...

Actually you are not waiting for answers. You keep asking the same things over and over.

The following link will provide you an answer to your first question.

http://bit.ly/HL9AKI

Look up ROW_NUMBER() in bol.

Basic syntax is:

select * from

(

select ROW_NUMBER() over (partion by SomeColumn order by SomeOtherColumn) as RowNum

from SomeTable

) x

where x.RowNum = 1

Gotcha. So you are actually in the process of making this a better already. I certainly understand being stuck with horrible decisions by vendors, it seems that is the only...

Once again Lowell shares another great time saving utility. Thanks!! Now if I can just remember that I have that. 🙂

I agree with ColdCoffee on the vagueness of the questions.

To the OP - you simple don't provide enough information to even begin answering your posts. Take a look at...

I don't think there is a "right" or "wrong" answer here. There are benefits to both sides. The biggest benefit to doing this in the front end (since the URL...

Looks like Jack was posting pretty much the same response at the same time as me. 😛

Pretty sparse on details.

Do you have error messages?

Can you post the trigger code?

It looked like it would do something...nothing good...but something....

create table march_2012

(

first_in numeric(20),

last_in numeric(20)

)

--create some dummy data

insert march_2012

select...

This article explains why we need the ddl and sample data.

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx

In short, you have not provided the entire question.

Is there a question here? And why do you need a loop for this?

Try this one. http://bit.ly/IsUkqa