I do...

One thing I would recommend is to automate regular reports to check which tables are fragmented beyond what you would call a reasonable limit. Store these table names in...

Try casting token as a decimal before taking the average.

Example:

select avg(cast(token as decimal)) from table

I'm pretty sure that will mess up your relationships since they use the table ID, not the name.

The stored procedures use the name so they should be ok.

Someone slap me please! All I keep thing about is using a ...... cursor.

John, if all you want is year, month, and sal, would this not work for you?

SELECT MIN(year) as [year], MIN(month) as [month], sal

FROM YourTable

GROUP BY sal

ORDER BY sal

Thank Penelope.

I found almost 250 IT jobs posted since Sept 1st. Unfortunately they're not all SQL related and not only in NS but that was a higher number than...

There's not a whole lot on Monster.ca right now, but that does not mean a whole lot.

I agree, the NS summers are nice, especially compared to midsouth USA, but they're...

I'm sure that could be made to work in SSIS with the help of a Script task.

You could use VB.NET to read the first row and build a "create table"...

Maybe someday telecommuting will become so common that we can start working for companies in India.

(Sorry, I just couldn't resist.)

:hehe:

Well, that depends ....

Can you provide more details about what you mean?

Yes there is a way, using dynamic SQL.

I once did something similar. I had a SQL query that would assign to a variable the name of the first file...

How can you tell which file maps to which table?

Somehow my first link disappeared.

http://www.devx.com/dbzone/Article/21410/1954%5D

I Googled sql 2005 olap cube tutorial

and got: