Maybe you can use a left join in your ImportTableData method.

If SelectSQL.Length = 0 Then

strSQL = "SELECT * FROM " & TableName

Else

strSQL = "SELECT " & SelectSQL & " FROM...

Mine is incredibly close to yours Lowell. Instead of stuffing with dept I stuff arrive and just concatenated dept to the derived column.

;WITH flight_tran_table (flight_tran_id , OtherData)

AS

(

SELECT 1234, '(Other Tran...

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.