Viewing 15 posts - 6,271 through 6,285 (of 18,926 total)
dwill (5/10/2011)
It certainly does the job on my test data - i hope...
May 10, 2011 at 11:19 am
http://www.ssrstips.com (5/10/2011)
User "kkupchyk 4137" has 6 posts all recommending a third party non-SSRS software.
User "mikebally888" has 18...
May 10, 2011 at 10:43 am
David Burrows (5/10/2011)
Ninja's_RGR'us (5/10/2011)
I knew I had missed something ovbious...Tx for the assist.
No worries, I had to read the post a few times to spot it myself 🙂
My only concern...
May 10, 2011 at 10:40 am
geert.massa (5/10/2011)
Does somebody has a script to create a table from another...
May 10, 2011 at 10:33 am
I knew I had missed something ovbious...
Tx for the assist.
May 10, 2011 at 10:30 am
Here's how you get the count.
(DATALENGTH(REPLACE(text, product, '')) - DATALENGTH(text) ) / DATALENGTH(product) AS Occurences
Then SELECT Whatever, dtCNt.* FROM base OUTER APPLY (SELECT Product, count formula FROM Lookup) dtCNt
May 10, 2011 at 10:29 am
Nils Gustav Stråbø (5/10/2011)
Sorry, I must have missed a word or two when I read your post :blush:
No I miss-typed 1 word. Edited.
May 10, 2011 at 10:26 am
Nils Gustav Stråbø (5/10/2011)
MikeBlockhead (5/10/2011)
WITH ROLLBACK IMMEDIATE; << do I need this ??
No, but if there are any active sessions which are using the database, the ALTER DATABASE...
May 10, 2011 at 10:21 am
Nils Gustav Stråbø (5/10/2011)
What do you say? Is there an exception to where ORDER BY does not guarantee ordered results?
No I say that if you DON'T use order by in...
May 10, 2011 at 10:19 am
Yes, that will force all pending transactions to be cancelled and rolled back. Then you'll be able to run the restore.
May 10, 2011 at 10:18 am
Actually we're all missing the big picture (Except Kenneth).
The order of the table is NOT garanteed. The only way to garantee it is to use ORDER BY. There's...
May 10, 2011 at 10:09 am
set single user with rollback immediate
restore.
set multi-user
May 10, 2011 at 10:06 am
Is it possible that the file has been manually deleted, moved, locked, different permissions or something?
Hard to explain 2 years of working then failing only once daily.
Anything else accessing that...
May 10, 2011 at 9:15 am
That gives you the result you want but I'm not sure about the way I'm getting there. Test it on your full dataset to confirm plz.
SET IMPLICIT_TRANSACTIONS ON
CREATE TABLE...
May 10, 2011 at 9:10 am
I forgot who is the owner of this code... not mine but works great :
SELECT r.[session_id]
, c.[client_net_address]
, s.[host_name]
, c.[connect_time]
, ...
May 10, 2011 at 9:03 am
Viewing 15 posts - 6,271 through 6,285 (of 18,926 total)