Viewing 15 posts - 1 through 15 (of 25 total)
I receive the same error, which I presume is an artifact of the dynamic SQL when not blocks are found?
February 4, 2021 at 2:24 pm
Absolutely and all fair points, but until SQL Server finally supports the "occurence" argument as Oracle has for a while in its INSTR function, I'll use this as a "good...
November 1, 2019 at 7:55 pm
No. Not even close. Usually less than 50 characters.
October 22, 2019 at 3:06 pm
Fair points. I've updated the function to return a "0, No value" record if a NULL value is passed to the function. An empty string within the function returns an...
October 22, 2019 at 2:15 pm
I have limited experience with INCLUDEs, but I would add that they are particularly relevant for table-valued functions that are accessed via CROSS or OUTER APPLY operators. The performance implications...
October 10, 2019 at 2:41 pm
Yeah. I guess the question is if you have cubes but haven't invested the time in learning the requirements to implement or constraints/limitations of the SSAS data mining models, are...
December 15, 2015 at 12:50 pm
Great article and timely as I am currently in the process of explaining the power of R relative to what is currently in the MSBI stack. I might add the...
December 15, 2015 at 8:01 am
Sorry. I couldn't release the package outside of our organization.
December 4, 2015 at 11:47 am
It would appear so. The last run populated PackageXML for the 60 rows that were generated.
November 30, 2015 at 11:44 am
I'm not sure how you determine this. We're using the VS 2010 shell distributed with SQL Server 2012.
November 30, 2015 at 7:22 am
Thanks. I received messages indicating issues with the variable and constraint sections (below). Also, it didn't appear to find any of the scripts in our packages.
...
------------------------Get all variable details-------------------------------------
Msg 8152,...
November 25, 2015 at 11:24 am
Testing now. Admittedly, I'm just executing this to see how the results look after one pass. How are subsequent executions managed? Do you have to DELETE rows from the tables...
November 24, 2015 at 10:29 am
Even stranger, I copied the comments out and pasted them back in and the syntax checked out. Subsequently, I was able to build the cube. Go figure.
November 26, 2013 at 6:20 am
I will preface my response by saying that this is for SQL Server 2008, noting that this is a SQL Server 2005 posting.
I have had luck editing the query as...
August 23, 2011 at 8:28 am
Honestly, I believe I reinstalled either the sample files or SSIS, but it was a while ago.
August 18, 2010 at 7:13 pm
Viewing 15 posts - 1 through 15 (of 25 total)