rhunt,

with respect, i don't think this is the same as "the worst practices" series that was kicking around a while ago.  that was good.

it seems to me that this article...

nonononono!

the original article is a disgrace. 

it is my opinion that your approach is, perhaps, the only valid way to respond to such a bad design suggestion.  your "one table...

Disgraceful.

I used to have a great deal of respect for the guys started/maintain/edit this site but now i wonder what's gone wrong. 

is steve...

i've been using stuff like this recently

patindex('%,'  + @debt_type_cd     + ',%', pa.DebtType)            != 0

where @debt_type_cd is some value and pa.DebtType code is a comma delimited list like this

,something,somethingElse,morethings,

note the comma...

i've had pain with using DB2...

you should be able to get the data out via ODBC then datapump it into SQLServer

Good Luck!

I hadn't thought of a permanent date table (even though i swear by them for OLAP dimensions)...   what i'm doing in the rest of the proc is picking off an instrument...

yeah, why not? no-one will notice a couple of extra bytes per row 

identity fields can be great as alternate keys, if you have...

try using "union all" instead of "union".  union will strip out any duplicates in the result set.

here's one i use... (just a shade faster than Julian's method  )

declare @clientId int

select ClientId into #ClientList from ...

while 1=1

begin

  select @clientId...

one good trick i know of is related to validation of arguments...

let's say you have some procs which are called by the GUI, so you need to do some validation of...

surely the -n option would utterly ruin the data? 

I could be wrong as I've never used native option in anger (as it...

One example i came across this week was a lengthy, descriptive and very helpful comment, which related to an old version of the code and as a result was completely...

quote:

---

tablename disable trigger triggername

then fire the update query

and then again enable the trigger

alter table tablename enable trigger triggername

---

October 22, 2003 at 2:53 am