What kind of book is this? If it presents a query like this without a detailed description of the table and some sample data it is impossible understand what it...

johnsql,

I thought Sergiy was pretty helpful. He saved you a trip to BOL by saying that JOIN is the same as INNER JOIN. In fact, BOL shows [INNER] JOIN which...

I developed a very simple empirical approach for one of my clients.

It consisted of a Windows scheduled task which fires up from one server (not the SQL Server)

every even hour...

What a waste to fire a trigger when nothing has really happened. What could you possibly want to do? You have pretty much no information to do anything with.

Why feel 'vulnerable' when posting real code? Vulnerable to what? Without being cynical, show me an example.

To automatically get the dbo prefix when creating a table, the login must not be a user of the database. You must also use a system administrator login and run...

Without your DDL there will not be much forthcoming.

My best guess, about the parameter not working is that in the example above you use a nice clean date (without a...

I have read this post 3 times now and still don't understand what a fiscal period is.

Must be too early in the morning.

And why no subqueries?

I have never 'ripped up' a blob like you want to do. I would stay away from doing

this in a stored procedure - as it would be very slow. Neither...

So you have

null     fid1    fid2    fid3  ...

date1  val11  val12  val13 ...

date2  val21  val22  val23 ...

date3  val31  val32  val33 ...

.      .      .      .

.      .      .      .

.      .      .      .

I presume...

You need to have a better idea of that 1000x700 matrix. Besides the dimensions changing you need to ask yourself:

How sparse is it?

How many entries change between one day...

My eyes pop up whenever my where clause uses an OR. It can be a real performance killer.

This works: 'select * from [sheet1$]'

This doesn't work: 'select * from sheet1'

This doesn't work: 'select * from [sheet 1$]'

Neither does this: 'select * from [sheet$1]'

Using the true name of the...

BOL (SQL Server 2000) states that the last parameter of OPENROWSET is 'query'.

But the only example for Excel demonstrates that the last parameter must be a named range (without quotes). And...

Just a question. Looking at your syntax where it says [Sheet 1$], is this the way to refer to an entiry sheet? If so, is it the name of the...