If the value you are trying to replace is exactly the same right now you could just use a replace.

update @Table set FileFolder = REPLACE(FileFolder, 'D:\fsaATLAS\YourUniversityName\', 'E:\fsaATLAS\BostonUniversity\')

The version ColdCoffee posted...

njdevils39 (3/30/2012)

One problem with your query is that its giving me:

Msg 208, Level...

The query I provided should be a good starting point. Show me what you have tried.

What do you have so far?

Well you have been handed 99% of this. Why don't give it a try to go the last 10 feet? Pretty sure you can the columns you want. It seems...

What does that mean? How about if you post what you...

Like this?

select * from

(

SELECT

ROW_NUMBER() over(partition by e.EMP_ID order by x.r.value('@date_changed','DATETIME') desc) as RowNum,

e.EMP_ID,

e.EMP_NAME,

e.EMP_ORGANIZATION,

e.EMP_DEPARTMENT,

e.EMP_DT_TERMINATION,

...

Good points Matt!!! Tracking for me is pretty simple because it is all in house promotions. As a result we don't need to worry about collecting money from manufacturers.

You are grouping by string literals which will not work.

Try this.

select sh.SalesPersonID,YEAR(sh.OrderDate)as 'OrderYear', SUM(sd.OrderQty*sd.UnitPrice)as 'CostOfOrder'

from sales.SalesOrderHeader as sh

inner join Sales.SalesOrderDetail as sd

on sh.SalesOrderID = sd.SalesOrderID

group by sh.SalesPersonID

having sh.SalesPersonID is not...

OK we are finally getting somewhere...

I cleaned up your sample data so that other can actually use it. Your columns didn't quite match in the first set of queries and...

To allow for the multiple discounts/coupons you might need to have an OrderDetailCouponDiscount and OrderDetailCouponSKU tables or something along those lines so you know which coupon(s) were applied to the...

It will only update the changes to the foreign key value. If you want to track all changes to the table you are looking at a trigger, or possibly CDC.

I just did an online coupon project not long ago and what Eugene described is very similar to what I did.

The main difference for me was I created a...

dwain.c (3/29/2012)

Actually after ColdCoffee's prior post, I was no longer confused. I...

Of course your join also has nothing to actually join tableA and tableB. :w00t:

Here is an example of what is happening.

declare @variable varchar(20) = 'col1 desc'

create table #tableA

(

SomeValue varchar(10)

)

create table...