This line, "WHERE DECODER_ID = DECODER_ID" will make it update every row. I think you want the second one to be a variable. Not sure which variable it's...

I try to make my maintenance plans as lazy as possible. I set them up to do the minimum necessary to make sure everything works well. That means...

You seem to have deleted the original question and all its specifications.

If it has a createddate field in the table, it should be a matter of using something like this:

select...

Sounds like it's not the shark tank it originally sounded like. Cool biz.

Good luck on getting the guy trained up. That's always a good thing.

Glad we could help.

Are you in a position where you can either add columns to the table or create an indexed view on the table?

If you add some calculated columns and index them,...

SQL 2000:

Query Analyzer:

drop table YourTableName

Enterprise Manager:

Right-click table, select Delete

SQL 2005

Management Studio:

Right-click table, select Delete

drop table YourTableName

That'll get rid of the table completely.

Management Studio/Query Analyzer:

truncate table YourTableName

That'll empty the table out...

You can issue a drop command on a table or view (or any other database object). That'll actually get rid of it. Is that what you want? ...

skjoldtc (3/11/2009)

---

Unknown... that's how I feel sometimes when trying to figure out my wife.

SELECT Response FROM dbo.Husband

WHERE Question = 'Honey, do I look fat in this?"

AND ...

Here's how I'd handle that:

;with CTE

(Row, LookupCode, LookupID)

as

(select

row_number() over (partition by LookupCode order by othercode),

LookupCode,

LookupID

from

dbo.LookupTable)

UPDATE TempFactTable

SET CodeID = LookupID

FROM TempFactTable t

inner join CTE

on t.LookupCode = CTE.LookupCode

and Row...

mhaskins (3/11/2009)

---

I love the way it sounds much more official when...

Are there a maximum of three tests? If so, this should do what you need:

CREATE TABLE #Table_3(

[Patient] [nchar](10) NULL,

...

Boolean humor! Yep! (Too bad it's...

Does the table in question have a column in it that holds the creation date?

Have you tried to write a query for this? If so, what problem are you...

SQL Server will end up using as much RAM as you allow it, in most cases, not just to cache common data, but also hold execution plans, for execution space,...