Viewing 15 posts - 61 through 75 (of 167 total)
PS: I’m surprised Celko hasn’t jumped on this thread screeching for even broaching the subject of dynamic sql much less enabling it. I hope he’s okay.:-)
July 14, 2014 at 12:18 pm
1. The outside 2 single quotes delimit the string.
2. On the inside of the string you must have 2 single quotes for each single quote you are representing.
I...
July 14, 2014 at 12:13 pm
Thank you, Luis. You are the only one to respond so far so I am pretty sure I have posed a "toughie" to the team. Yes, a dynamic...
May 15, 2014 at 7:15 am
Worry as a virtue? Guess that qualifies me as a saint.
Seriously, these comments about worry as an asset from this group of posters is like...
May 5, 2014 at 4:32 pm
You could hire her as long as you put on the contract that she couldn't fight or break up with her boyfriend for the time that she worked with you....
February 20, 2014 at 2:18 pm
We developed a test that required applicants to write queries against our proprietary database that would answer a list of specific questions we provided along with which tables to use...
February 20, 2014 at 2:08 pm
Something like this?
Design the spark line as a sub report with the second data set in it and use a parameter for the metricname and it should work and a...
February 20, 2014 at 1:26 pm
The first point I want to make is that I am amazed at the number of contributors to SSC and Simple Talk that are not only technically brilliant but also...
January 21, 2014 at 3:30 pm
Well done. I much appreciated the review questions at the bottom. I would like to see review questions as a standard for the Stairway and other technical articles.
January 15, 2014 at 8:33 am
Also, there is an excellent exercise in Covey's "Seven Habits of Highly Effective People" that I would highly recommend to put you in touch with things that are important to...
January 9, 2014 at 2:53 pm
Do the inward journey. Start with something like Siddhartha (the book by Hermann Hesse). Check out some of Joseph Campbell's work (Power of Myth, Hero With a Thousand...
January 9, 2014 at 2:48 pm
Don't we celebrate JC's birthday on the 25th regardless of when it actually is?
December 12, 2013 at 2:14 pm
Where's Celko? I thought he'd be in here administering some kind of beat down based on the title alone. 🙂
December 12, 2013 at 12:28 pm
You can also query information_schema.columns.
select * from information_schema.columns where table_name = 'YourTableName'
December 12, 2013 at 11:24 am
Viewing 15 posts - 61 through 75 (of 167 total)