Viewing 15 posts - 3,556 through 3,570 (of 3,666 total)
Arthur.Lorenzini (10/6/2008)
That sounds right where I want to go with this. Do have any examples of how this could be done. I really don't want to re-invent the wheel.
I do...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 7, 2008 at 8:52 am
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 6, 2008 at 3:47 pm
Try casting token as a decimal before taking the average.
Example:
select avg(cast(token as decimal)) from table
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 6, 2008 at 3:11 pm
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.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 6, 2008 at 2:16 pm
Someone slap me please! All I keep thing about is using a ...... cursor.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 6, 2008 at 9:01 am
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
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 6, 2008 at 8:34 am
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 3, 2008 at 6:45 am
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 2, 2008 at 4:21 pm
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"...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 1, 2008 at 5:17 pm
Maybe someday telecommuting will become so common that we can start working for companies in India.
(Sorry, I just couldn't resist.)
:hehe:
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 1, 2008 at 5:06 pm
Well, that depends ....
Can you provide more details about what you mean?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 1, 2008 at 4:58 pm
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 1, 2008 at 4:21 pm
How can you tell which file maps to which table?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 1, 2008 at 4:02 pm
Somehow my first link disappeared.
http://www.devx.com/dbzone/Article/21410/1954%5D
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 28, 2008 at 8:43 am
I Googled sql 2005 olap cube tutorial
and got:
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 28, 2008 at 8:16 am
Viewing 15 posts - 3,556 through 3,570 (of 3,666 total)