Viewing 15 posts - 526 through 540 (of 1,189 total)
Cool question. Thanks.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
April 17, 2014 at 12:24 pm
This is great! Thanks for your help.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
April 15, 2014 at 8:15 am
Mostly we're on SQL 2008 R2 with a couple of SQL 2005 and only one remaining legacy server at SQL 2000. But our main issue is having databases that are...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
April 11, 2014 at 12:56 pm
Thanks for the great article!
I just want to make one small comment. I ran the code below:
[font="Courier New"]SELECT OrderAmt,
IIF(OrderAmt > 200,
'High $ Order',
'Low $...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
April 10, 2014 at 3:35 pm
Wow, I didn't know that.
Thanks for the question.
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
April 3, 2014 at 1:29 pm
Ha ha ha. Nice.
I was scared for a moment that this was a real script, until I checked the comments.
Thanks,
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
April 2, 2014 at 9:45 am
Just want to say, your tag line is truly inspirational:
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
Simple but really, truer words were never spoken....
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
March 31, 2014 at 8:15 am
I think the advice about using queries makes the most sense.
But look at this to synchronize reports if needed.
Good luck.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
March 28, 2014 at 11:37 am
Thanks, everyone, for your replies!!
Lowell, I didn't know about sp_refreshview - that sounds like a huge help.
Thanks again,
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
March 27, 2014 at 3:02 pm
Great question even with the caveats posted in the comments. Thanks!
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
March 27, 2014 at 9:23 am
GilaMonster (3/21/2014)
SELECT col1, col1 FROM SomeTable ORDER BY col1
It's the order by, it doesn't know which col1 to sort by. Wasn't caught by...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
March 21, 2014 at 4:20 pm
patrickmcginnis59 10839 (3/21/2014)
Also, you...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
March 21, 2014 at 3:18 pm
Luis Cazares (3/21/2014)
That has always been like that. It's not new to 2008, it already existed on 2000. The query might have been changed.
Thanks, but it is the same exact...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
March 21, 2014 at 1:44 pm
Sorry, I did see one other difference, but this was in the html source of the reports.
In the working report I see this bit of code:
</div><div id="ctl31_ctl09_ReportArea">
<div NewContentType="Microsoft.Reporting.WebFormsClient.ReportAreaContent.None" ForNonReportContentArea="false" id="ctl31_ctl09_VisibilityState"...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
March 18, 2014 at 9:53 am
MyDoggieJessie (3/17/2014)
Go to the same report that's...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
March 18, 2014 at 9:42 am
Viewing 15 posts - 526 through 540 (of 1,189 total)