Viewing 15 posts - 1 through 15 (of 24 total)
I agree, this is the most readable, AND it works
April 26, 2013 at 3:56 am
@Lynn, indeed, I have read it, I also did a test and concatenated 'Value' with 'e0', and still the IsNumeric evaluates too 1, so it really always is...
April 25, 2013 at 12:07 am
Thanks Chris.
But if I leave out the where-clause, both 'IsNumeric' checks in the select always return 1, which means in my oppinion that all data can be converted to numeric...
April 24, 2013 at 8:44 am
Chris, I can see the little differences in the plan.
However, I am not a dba-expert, and not that good at analysing query plans.
Can you please explain me a bit what...
April 24, 2013 at 7:56 am
Thanks for the suggestion, but I already tried it, same error...
April 24, 2013 at 7:29 am
Since there are no new messages, may I conclude that no-one can find an answer for this very annoying problem ?
If there is anyone who has any ideas, or who...
July 9, 2012 at 1:26 am
Here is the complete syntax for the partitioning on this FactRights table :
-- FileGroups
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_001;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_002;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_003;
ALTER DATABASE...
June 27, 2012 at 12:24 am
Thanks for all the replies yet, I'm glad to see that people are willing to help me on this strange one
DDL: the DDL I provided is correct, there is...
June 27, 2012 at 12:23 am
We have had some issues with calling packages from our control package too.
Can you tell us what the value of the property 'ProtectionLevel' is for the package you are calling...
June 26, 2012 at 2:00 am
Can't you try with the visibility of the row, and instead of recalculating the values, refer to the textboxes which contain the values needed?
For example:
= Iif((ReportItems!MarketTextbox.Value / ReportItems!SumMarketTextbox.Value) *...
June 26, 2012 at 1:55 am
You want to sort your tablix.
Sorting means you need to tell the desginer on what column(s) he needs to sort.
You expression will either return true or false, which isn't the...
June 26, 2012 at 1:51 am
Maybe an interesting fact too: everything worked fine for about 1 ร 2 weeks, but then, suddenly out of nowhere, without any changes to the table, the error appeared.
My colleague...
June 26, 2012 at 1:31 am
Hereby my sql code to create the table (as you can see, a lot of columns, I've left out the foreign key statements, as they don't seem to be usefull...
June 26, 2012 at 12:51 am
tim.kay (4/2/2012)
April 2, 2012 at 6:32 am
I would suggest to migrate to SQL Server 2008 R2.
First of all, your databases will be in the newer environment, which has lots of improvements compared to SQL Server 2005.
Second,...
April 2, 2012 at 12:06 am
Viewing 15 posts - 1 through 15 (of 24 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy