Viewing 15 posts - 2,566 through 2,580 (of 18,926 total)
TST1 (9/20/2011)
September 20, 2011 at 6:56 am
Roy Ernest (9/20/2011)
Ninja's_RGR'us (9/20/2011)
Brandie Tarvin (9/20/2011)
Whoot! So, who wants to go to Curacoa?http://www.sqlsaturday.com/eventhome.aspx - SQL Saturday 103
I'm registered!
Did you register already?
YES!
I never said I was going, but I'm definitely registered...
September 20, 2011 at 6:38 am
SQL Kiwi (9/20/2011)
Brandie Tarvin (9/20/2011)
And yet the engine complains if I don't have any previous statement that have a ';' and don't put one before the WITH.
I was going to...
September 20, 2011 at 6:23 am
Gianluca Sartori (9/20/2011)
Brandie Tarvin (9/20/2011)
GilaMonster (9/20/2011)
Brandie Tarvin (9/20/2011)
CTEs (i.e. ;WIth () ... SELECT ) are single statements in this context, yes?
<pedantic>
CTEs don't start with a ';', no more than...
September 20, 2011 at 6:19 am
SQL Kiwi (9/20/2011)
Ninja's_RGR'us (9/20/2011)
I was going more for select or dml.
MERGE will be very upset to hear it's not DML :pinch:
But yes, I know what you had in mind -...
September 20, 2011 at 6:16 am
SQL Kiwi (9/20/2011)
Ninja's_RGR'us (9/20/2011)
Try doing ;with () Without any select after the with and you'll see if the engine thinks the statement is complete ;-).
Ok:
WITH CHANGE_TRACKING_CONTEXT (0x)
MERGE master.dbo.spt_values AS...
September 20, 2011 at 6:06 am
GilaMonster (9/20/2011)
Ninja's_RGR'us (9/20/2011)
That's true only for the first phrase in any documents / books :-D.And then again, the last thing you read ended with a period.
/pedantic :hehe:.
.Really?
.So this would...
September 20, 2011 at 6:02 am
GilaMonster (9/20/2011)
Brandie Tarvin (9/20/2011)
CTEs (i.e. ;WIth () ... SELECT ) are single statements in this context, yes?
<pedantic>
CTEs don't start with a ';', no more than an english sentence starts...
September 20, 2011 at 5:55 am
SQL Kiwi (9/20/2011)
Brandie Tarvin (9/20/2011)
CTEs (i.e. ;WIth () ... SELECT ) are single statements in this context, yes?
Yes - most solutions to past challenges use CTEs extensively. Some would...
September 20, 2011 at 5:45 am
Brandie Tarvin (9/20/2011)
LutzM (9/19/2011)
WayneS (9/19/2011)
Gianluca Sartori (9/19/2011)
WayneS (9/19/2011)
Opinions wanted: Is it fair to post a Denali solution?Fair but slow, based on your performance tests.
Slow compared to QU, but still faster...
September 20, 2011 at 5:44 am
Brandie Tarvin (9/20/2011)
Whoot! So, who wants to go to Curacoa?http://www.sqlsaturday.com/eventhome.aspx - SQL Saturday 103
I'm registered!
September 20, 2011 at 5:43 am
I've never tried it but it could work.
Make a master report with 5 subreports and export to pdf there. It should all be in a single file.
September 19, 2011 at 6:23 pm
What's wrong with the pdf export of ssrs?
September 19, 2011 at 3:02 pm
September 19, 2011 at 5:35 am
I see what you need but I don't know how to do it (at all). So I can't offer better alternatives.
September 19, 2011 at 5:34 am
Viewing 15 posts - 2,566 through 2,580 (of 18,926 total)