update t1 set

t1.Asa = t2.asa

From phone

Inner join table2 on t2.phone=t1.phone

Where t1.asa is null

Should do it.

Of course!

I would look at PatIndex http://msdn.microsoft.com/en-us/library/ms188395%28v=sql.100%29.aspx

and SubString http://msdn.microsoft.com/en-us/library/ms187748%28v=sql.105%29.aspx

and CharIndex http://msdn.microsoft.com/en-us/library/ms186323%28v=sql.105%29.aspx

That should get you started with some basic string parsing functions.

For any future questions, you may also want to...

I took and modified the solution from Chris and came up with this:

update a set

Flagb1 = case when b1 in (A1, A2, A3, A4) then 'Y' else...

Glad it is working for you!

Thanks for letting us know the result.

This is just stab in the dark, but I am guessing that 40511 is some Julian type date. With a little date math, I came up with:

select cast(DATEADD(dd, 40511, '1899-12-30')...

I just thought I would share what I have found so far.

The main issue is that the app seems to be locked up. It is not. Something in SQL...

Thanks for the suggestions. I will be looking at this and a number of other suggestions I have found while researching this!

I'm not entirely sure what you are trying to accomplish, but I think this is...

Try this:

;with cte as

(

select *, ROW_NUMBER() over(order by old_ind_id) as RowNum

from #audit_Person

)

select 'old', old_ind_id, old_login, first_name, last_name, email_addr, created_dt, updated_dt,RowNum

from cte

union ...

Try this:

SELECT tag_date

, SUM(close_total)

, ISNULL(SUM(CASE id WHEN 1 THEN close_total ELSE 0 END), 0) AS col1

, ISNULL(SUM(CASE id WHEN 2 THEN close_total ELSE 0 END), 0) AS col2

,...

I would make 1 change to the proposed solution.

You need to take the time portion into consideration when doing ranges.

So this:

where d.dutydate >= v.vacation_start

and d.dutydate <= v.vacation_end

Becomes:

where d.dutydate >= v.vacation_start

and...

drew.georgopulos (12/23/2013)

---

My doctor advised ditching the laptop for a more ergonomic environment.

I code at home now for four clients, and was wondering if it makes any sense to divide the...

Thanks!

I...

I ran both solutions on your sample data and Luis' solution was WAY faster, almost double. But the solution provided by Alan uses so many different methods to arrive at...