I would not call this an improvement by any means. I would call it bad coding practice. SQL should never let you include columns in aggregate functions that...

I like the method SQL King described. A few other options include creating a variable and making it an expression to the current date. This would work if...

Why dont you make it a job and not give it a schedule. That way you can run it whenever you want. Your other option is to run...

How do I copy the data from tables is one db to the same db on the test box?

I tried the import wizard and got an error about a primary...

** min and max

If you take the min and make from T, what happens if the client has two records?

Also, it would be helpful if you could provide some test data. I believe...

Sometimes the most simple things are the most difficult. 😉

This means you are using a user variable named Path. Select the variable named Path

from the list and drag it down...

Well, if you need the values in a sequential order then you have to use the row_number() function, as Matt suggested.

It does not make sense that you want to jeopardize...

U CAN UPDATE THAT WAY ONLY WHEN THERE ARE NO MORE ROWS TO BE INSERTED IF NOT EVERYTIME U INSERT SOME ROWS U NEED TO UPDATE THE COLUMN .....SO IT...

Your variable should look like this: \\myserver\e$\. You should not have to do any fancy manipulation here.

Make sure your variable is a string and in the scope of your current...

kurraraghu,

The output is not the same. The output for the query is 1,2,3,5,8. I am rkeeping the smallest id of the duplicate data, in this case id 2....

If you are still having a problems. You can also manually update the table. This will limit the problems you encounter in trying to change the column definition from...

This should help you, or at least point you in the right direction.

declare @t table(

id int,

name varchar(10)

)

insert into @t

select 1, 'abc' union all

select 2, 'def' union all

select 3, 'abcd'...

Add the constraint, I posted. Then alter the column to not null.