smknox,

I use a lot of words that show up as keyword, but I'm careful to use "[" and "]" around each word.  Some words I use that come up as...

Rick,

The easiest way to set this up would be a view that joins the two tables.  Then query the view within OLAP instead of the table.

cl

Quote:

Also looming is the announced end of mainstream support of SQL Server 2000, which will end on December 31^st 2005. If SQL Server 2005 doesn’t release until the second quarter...

Tom,

NO problem there are all; I do it all the time.  The trick is to use the "Dynamic Properties Task". 

1st, use VB or SQL to concatenate the file string,...

"worked a treat" ...  ??  Is that Australian?  I love slang...

You can use whatever scheduling mechanism you want, really, all it has to do is make a database connection and execute a proc.  Personally, I usually use SQL jobs and...

Great article.  Writing a follow up - about how to "stage" the data and then scheduling external processing- would be awesome.  I've implemented it here but would love to here...

Yeah, they covered this exact issue at PASS.  Using parameters instead of building a string was significantly faster, specifically due to execution plan re-use.

Another bit of advice:  When doing a...

Heres a loop that will grab everything between the "*" rows, no matter how many rows of data there are (the query above assumes 3 + delimiter).

declare @YOurOrigTable table (ID...

Here's another example

/*-----------------------------------------------------------------------------------------------

This script tracks the rows in a database over time.

The base table used is #TempRowCount, which has new records added everytime the script is run.

A dynamic query based...

Excellent Idea, Tony.  I've starting using parameterless procs for a number of reason's, the main being performance.  In fact, I'm working on a generic Parameter table to deal with this. ...

Steve,

How 'bout the problems when trying to edit a post?

No offense, but the new site is really buggy, although the most annoying issue is no "Code" formatting option (probably "as...

I don't think that's going to work, as the derived table will still only return 10 rows.  You can't use correlated subqueries either, as they must return only one value.

In...

Gary's statement removes duplicates, but not triplicates or higher.  It was unclear from your statement which behavior you wanted, but this will remove all but the record with the lowest...

OK, a , ) is not a wink, it's syntax!  What the heck happened to the Code option on this website?  I love it when new tech doesn't do everything...