Viewing 15 posts - 4,486 through 4,500 (of 9,712 total)
Forgot about the variable option. I retract the "the only way" part of my earlier post.
April 13, 2012 at 5:05 am
What you do then is to create two report variables, one for EXP and one for IMP. Then have the variables subtract from each other.
FYI: It's been a while since...
April 13, 2012 at 5:02 am
SQL won't let you do that. The only way to guarantee order is to have two different UPDATE statements, or to fix your current one to pass in the hard...
April 13, 2012 at 5:00 am
How is full text searching a limitation if you are allowed to use it?
April 13, 2012 at 4:57 am
So I'm using Display Estimated Execution Plan for the first time in SQL 2008 and fun, fun, it displays "missing indexes" across the top.
Then I find an index suggestion where...
April 13, 2012 at 4:47 am
Per Books Online (Top clause):
Specifies that only the first set of rows will be returned from the query result. The set of rows can be either a number or a...
April 13, 2012 at 4:40 am
Sounds like a homework question to me. Have you Googled your questions yet? Or read SQL Server Books Online?
April 13, 2012 at 4:37 am
Look up Common Table Expressions and Google spforeachTable (First link is here: http://www.databasejournal.com/features/mssql/article.php/3441031/SQL-Server-Undocumented-Stored-Procedures-spMSforeachtable-and-spMSforeachdb.htm). See if that helps.
April 13, 2012 at 4:35 am
I don't use data collection, but if these are two separate jobs, shouldn't you be able to schedule them so they run one after the other instead of at the...
April 13, 2012 at 4:33 am
You have to pull the EXP and the IMP fields into the expression for Imbalance.
=SUM(Fields!IMP.Value) - SUM(Fields!EXP.Value)
I probably have the field names wrong, but it's really not that hard. Make...
April 13, 2012 at 4:32 am
This is the newbies guide to installing the patch:
Go to Microsoft's download pages, download the patch to a good drive location that does not contain your SQL files or your...
April 12, 2012 at 6:07 pm
Steve Jones - SSC Editor (4/12/2012)
April 12, 2012 at 1:53 pm
Jack Corbett (4/12/2012)
GilaMonster (4/12/2012)
April 12, 2012 at 1:51 pm
Larry Page(Ehs_Akb) (4/12/2012)
Have you been given pre-generated data or are you entering it in? Because if you're doing the later, you can determine the data pattern by what you insert....
April 12, 2012 at 11:22 am
Larry Page(Ehs_Akb) (4/12/2012)
you are right.but i mean i want to find the pattern in my data and so implement this pattern in my algorithm
Have you been given pre-generated data or...
April 12, 2012 at 10:54 am
Viewing 15 posts - 4,486 through 4,500 (of 9,712 total)