Viewing 15 posts - 106 through 120 (of 123 total)
Yep, took a copy, did the one way upgrade and worked on that 😉 after what you said, I wanted to see what happened using a SSDT project and keeping everything...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
October 6, 2017 at 7:35 am
Thanks for the reply Thom.
In what way(s) is it incompatible? I took a copy of one of my current 2008 BIDS projects, migrated it to SSDT and all...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
October 6, 2017 at 6:06 am
I love this idea. I can immediately see a potential use for this that warrants some further research. I work in the legal sector and can see that this might be...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
August 7, 2017 at 9:59 am
Thanks Eirikur
I had tried using SQLCHAR 0... instead of SQLNCHAR 2... previously, I didn't get errors but did get 0 rows. ...Thinking back I might have been using a...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
July 12, 2017 at 4:16 am
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
July 11, 2017 at 8:17 am
Eirikur Eiriksson - Tuesday, July 11, 2017 7:08 AMQuick suggestion, change the "\r\n" to "\n"
😎
Nope, sorry. Same message 🙁 I had previously tried...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
July 11, 2017 at 7:41 am
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
March 6, 2017 at 10:04 am
Anyone else unable to access this article? Tried from two locations:
ERR_TOO_MANY_REDIRECTS
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
February 16, 2017 at 3:47 am
Looks like you're using optional parameters, have you tried using OPTION(RECOMPILE)?
have been caught out with that before:
http://www.sommarskog.se/dyn-search-2008.html#static
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
September 9, 2016 at 9:01 am
I have used the method here, with a bit of modification to achieve what I think you are trying to do:
https://www.simple-talk.com/sql/database-administration/pop-rivetts-sql-server-faq-no.5-pop-on-the-audit-trail/%5B/url%5D
Edit: sorry re-read your post and probably not entirely suitable!
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
September 9, 2016 at 8:43 am
It's definitely given me food for thought.
Not that I can change it in this case, but I am doing some reading on the arguments over lookup tables.
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
April 17, 2015 at 5:06 am
Thank you Ken. Spot on.
I used
INNER JOIN Folders AS f
ON dcl.cdType = f.cdCode
AND f.CodeType = 'Folder'
rather than a LIKE though.
I had got so close to that...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
April 17, 2015 at 4:17 am
Celko: thanks for your reply. I think I probably didn't explain things as well as I could have.
First, this has not been developed in house, it is part of an...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
April 17, 2015 at 3:49 am
Duran: Have you managed to get any further?
It looks like you read the same article as me before coming here. Typical Microsoft response "It's broken, we're not going to...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
February 25, 2015 at 6:23 am
What a complete idiot I am.
I previewed this 4 times checking code and spelling etc. When reading it through one final time after posting I found the reason, a silly...
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
January 30, 2015 at 5:35 am
Viewing 15 posts - 106 through 120 (of 123 total)