Something like this.

Update MyTable

set MyField = b.Value

from MyTable mt

join OtherTable b on mt.KeyField = b.KeyField

--optional where clause or whatever filtering here

If you want to return a varchar value you have to use an output parameter or make your last statement in the procedure a select statement. SQL returns an integer...

SQL Guy 1 (9/12/2011)

---

Hi Sean, first it was a problem and than it appears strange. I was tasked to write two scripts: to compare stored procedures, views, triggers between...

Are you looking into something that is a problem or just finding something that appears strange? What are you trying to accomplish or what are you looking for?

Fairly simple to do with ROW_NUMBER and the partition by by clause. If you can't figure it out and want some help post your ddl and I can give you...

select top 1 [my field here]

from Mytable

join MyHistoryTable on [my join criteria]

order by [My field that tells me which record is the latest].

You really should be using a datetime field...

Try this on a TEST server. The code below has the recompile hints. It might help the optimizer with a better execution plan. I make no promise as to the...

Meaning it is taking a LONG time?

Here is a post from Lynn with some common datetime routines. http://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/3/25/some-common-date-routines.aspx Very good resource.

Are the row counts on the base tables and the temp table similar? Rowcounts can adversely affect the execution plan especially with large temptables. I have the suggestion to use...

OK I tossed some quick sample data together.

CREATE TABLE [dbo].[EmailTemplateFieldsP](

[FieldPID] [int] IDENTITY(1,1) NOT NULL,

[ProjectID]...

See if this article [/url] will get you pointed in the right direction.

The table parameter sounds like a perfect fit. However, I don't think you need a cursor or any kind of looping at that point. You would want to update the...

ash0550 (9/9/2011)

---

I want to retrive data from a table dynamically.

Say it contains 3 rows name,age and gender

I want to retrieve name and gender through age.

Instead of using Select Name,gender from...

No need to close SSMS. You just need to refresh the local intellisense cache. ctrl - shift - R or use the menu Edit -> Intellisense -> Refresh Local Cache....