Viewing 15 posts - 2,251 through 2,265 (of 2,452 total)
The Dixie Flatline (8/2/2011)
I found a semi set based solution in a loop instead of using the cursor.
Would you mind posting your solution up here?
Don't forget the...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 7, 2011 at 2:16 pm
Hi
this article may help:
http://www.sqlservercentral.com/articles/tablediff+Utility/74261/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 7, 2011 at 6:27 am
From the MS site...(nothing more than Gail has already stated)
https://mvp.support.microsoft.com/gp/mvpbecoming
List of SQL MVPs.....dbl click on any name to give an idea of the committment these people make to the community.
https://mvp.support.microsoft.com/communities/mvp.aspx?product=1&competency=SQL+Server
I...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 6, 2011 at 9:02 am
Another possibility using quirky update.......thoughts anyone please?
regards gah
--=====
USE TempDB
;
--===== conditionally drop the test table
IF...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 5, 2011 at 3:19 pm
http://www.sqlservercentral.com/Forums/Topic1048093-391-1.aspx#bm1048213
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 1, 2011 at 2:48 pm
http://office.microsoft.com/en-us/templates/recipe-collection-database-TC001018635.aspx
simple...but maybe "food" for thought 😀
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 1, 2011 at 12:32 pm
Hi Scott
check out these articles below, maybe they will help.
http://www.databasejournal.com/features/mssql/article.php/3618061/MS-SQL-Joins---Part-1.htm
http://www.databasejournal.com/features/mssql/article.php/3623916/MS-SQL-Joins-Part-2.htm
http://www.databasejournal.com/features/mssql/article.php/3630381/MS-SQL-Joins-Part-3.htm
regards gah
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 31, 2010 at 8:22 am
CELKO (10/18/2010)
1) Learn the differences between rows and records, columns and fields; it will help.
Apologies for going off topic here, but I am confused by this statement above.
BOL states ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 19, 2010 at 2:21 pm
until we have some clarification and examples...here's an idea
suggest looking up "ROUND" in BOL
SELECT CAST(Round (1.434567, 1,1) AS DECIMAL (18, 1))
SELECT CAST(Round (1.4499999999, 1) AS DECIMAL (18, 1))
SELECT CAST(Round (1.450000000,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 21, 2010 at 2:19 pm
try the CASE statement (see BOL)
if you are still having problems please post back.
regards gah
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 21, 2010 at 12:19 pm
Q...is this a cube you have designed or one that someone else has designed and you are accessing?
how many records in the "market-media-region -agency " dimension?
assume you are trying to...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 20, 2010 at 2:02 pm
Jeff Moden (9/20/2010)
Thank you one an all for your help. 🙂
Jeff...you are more than welcome, it was the least I could do to repay you for the amount of help...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 20, 2010 at 1:36 pm
rohit07 (9/20/2010)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 20, 2010 at 1:22 pm
Hi
perhaps you can explain why you believe performance is slow?
some more information from you may assist others to help you
what version of AS?
How many data sources?
How many fact tables?
How many...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 20, 2010 at 12:55 pm
Jeff Moden (9/20/2010)
mazzz (9/20/2010)
I've just seen your update in the OP - do you need any more results?
My home setup is Win 7, Intel core duo CPU, 4GB RAM, 64bit,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 20, 2010 at 11:56 am
Viewing 15 posts - 2,251 through 2,265 (of 2,452 total)