July 31, 2015 at 12:25 pm
The Dixie Flatline (7/31/2015)
Alvin Ramard (7/31/2015)
Luis Cazares (7/31/2015)
WayneS (7/31/2015)
Looks like Luis is answering Oracle questions now.That wasn't the only attempt on that day. Here's a completely lost Oracle user.
But hey, as long as I can help.
I had to walk away from that last one. I expected that one to go one forever.
Here's another one.... I noticed the USING, instead of WITH for the cte.
http://www.sqlservercentral.com/Forums/Topic1706970-3077-1.aspx
I'm not sure that's Oracle. AFAIK, Oracle uses WITH just like SQL Server or PostgreSQL. I can't find the RDBMS that uses USING.
July 31, 2015 at 12:34 pm
Luis Cazares (7/31/2015)
The Dixie Flatline (7/31/2015)
Alvin Ramard (7/31/2015)
Luis Cazares (7/31/2015)
WayneS (7/31/2015)
Looks like Luis is answering Oracle questions now.That wasn't the only attempt on that day. Here's a completely lost Oracle user.
But hey, as long as I can help.
I had to walk away from that last one. I expected that one to go one forever.
Here's another one.... I noticed the USING, instead of WITH for the cte.
http://www.sqlservercentral.com/Forums/Topic1706970-3077-1.aspx
I'm not sure that's Oracle. AFAIK, Oracle uses WITH just like SQL Server or PostgreSQL. I can't find the RDBMS that uses USING.
Yeah, that particular post was just an isolated snippet of a MERGE statement the OP had asked about in another thread.
July 31, 2015 at 12:58 pm
I guess I've had enough of this forum for this week.
http://www.sqlservercentral.com/Forums/Topic1707595-2799-1.aspx
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 31, 2015 at 1:04 pm
Alvin Ramard (7/31/2015)
I guess I've had enough of this forum for this week.http://www.sqlservercentral.com/Forums/Topic1707595-2799-1.aspx
LOL. And why should they do the research themselves if they can just come around here and we spoon feed them the answer. They can then turn around and charge 8-10 consulting time for "analysis of changes between the version to ensure the migration goes smoothly". Meanwhile they are sitting on the beach slurping down umbrella drinks while the people who actually know the information are typing in the answer.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 31, 2015 at 1:11 pm
By the way all...
Happy SysAdmin day!
:hehe::cool::w00t::-D
July 31, 2015 at 1:16 pm
jasona.work (7/31/2015)
By the way all...Happy SysAdmin day!
:hehe::cool::w00t::-D
Thanks, but when's the SQL Dev day? 😎
😀
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 31, 2015 at 1:24 pm
Alvin Ramard (7/31/2015)
SQLRNNR (7/31/2015)
Alvin Ramard (7/31/2015)
Ladies and gentlemen, take my advice - pull down your pants and slide on the ice.screeeeeeeeeeeeeeeeeeeeeeeeeeech
What?
You're not familiar with the saying?
Neither literally nor figuratively (or is that literally?).
In either case, I haven't heard that saying.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 31, 2015 at 1:29 pm
Luis Cazares (7/31/2015)
The Dixie Flatline (7/31/2015)
Alvin Ramard (7/31/2015)
Luis Cazares (7/31/2015)
WayneS (7/31/2015)
Looks like Luis is answering Oracle questions now.That wasn't the only attempt on that day. Here's a completely lost Oracle user.
But hey, as long as I can help.
I had to walk away from that last one. I expected that one to go one forever.
Here's another one.... I noticed the USING, instead of WITH for the cte.
http://www.sqlservercentral.com/Forums/Topic1706970-3077-1.aspx
I'm not sure that's Oracle. AFAIK, Oracle uses WITH just like SQL Server or PostgreSQL. I can't find the RDBMS that uses USING.
Maybe they meant "connect by"?
There are some nuances in the Oracle CTE, but I don't see USING as being in the syntax. Then again, I am not a power Oracle DBA.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 31, 2015 at 1:30 pm
Alvin Ramard (7/31/2015)
jasona.work (7/31/2015)
By the way all...Happy SysAdmin day!
:hehe::cool::w00t::-D
Thanks, but when's the SQL Dev day? 😎
😀
March 14
But technically it is June 20.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 31, 2015 at 1:36 pm
SQLRNNR (7/31/2015)
Alvin Ramard (7/31/2015)
SQLRNNR (7/31/2015)
Alvin Ramard (7/31/2015)
Ladies and gentlemen, take my advice - pull down your pants and slide on the ice.screeeeeeeeeeeeeeeeeeeeeeeeeeech
What?
You're not familiar with the saying?
Neither literally nor figuratively (or is that literally?).
In either case, I haven't heard that saying.
It's a quote from MASH, from Major Sidney Freedman.
http://www.imdb.com/character/ch0009467/quotes
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 31, 2015 at 2:11 pm
Alvin Ramard (7/31/2015)
I guess I've had enough of this forum for this week.http://www.sqlservercentral.com/Forums/Topic1707595-2799-1.aspx
That's one nice thing about working away from home and on site all week. I haven't had enough free time to have had enough of the forums.
Though if my reply there's too snarky, let me know and I'll make it go away.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 31, 2015 at 2:54 pm
GilaMonster (7/31/2015)
Alvin Ramard (7/31/2015)
I guess I've had enough of this forum for this week.http://www.sqlservercentral.com/Forums/Topic1707595-2799-1.aspx
That's one nice thing about working away from home and on site all week. I haven't had enough free time to have had enough of the forums.
Though if my reply there's too snarky, let me know and I'll make it go away.
Well said. Nothing snarky there. 🙂
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 31, 2015 at 3:28 pm
Alvin Ramard (7/31/2015)
GilaMonster (7/31/2015)
Alvin Ramard (7/31/2015)
I guess I've had enough of this forum for this week.http://www.sqlservercentral.com/Forums/Topic1707595-2799-1.aspx
That's one nice thing about working away from home and on site all week. I haven't had enough free time to have had enough of the forums.
Though if my reply there's too snarky, let me know and I'll make it go away.
Well said. Nothing snarky there. 🙂
Silver spoons
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 31, 2015 at 7:21 pm
Alvin Ramard (7/31/2015)
I guess I've had enough of this forum for this week.http://www.sqlservercentral.com/Forums/Topic1707595-2799-1.aspx
You did fine and you're absolutely spot on. You've said what we're all thinking. Well, except maybe for me. I've not responded at all because I would not have been nearly as kind as you were. I have a very strong dislike for such JackHoles that rope a client in hook, line, and sinker and then they can't even spell SQL.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2015 at 9:13 am
Jeff Moden (7/31/2015)
Alvin Ramard (7/31/2015)
I guess I've had enough of this forum for this week.http://www.sqlservercentral.com/Forums/Topic1707595-2799-1.aspx
You did fine and you're absolutely spot on. You've said what we're all thinking. Well, except maybe for me. I've not responded at all because I would not have been nearly as kind as you were. I have a very strong dislike for such JackHoles that rope a client in hook, line, and sinker and then they can't even spell SQL.
I admit it wasn't the most polite answer. I feel a lot better about having said it when I see people like Gail and Jason posting something that more or less backs up my comment. 🙂
Jeff, it wouldn't have been as fine if I had said what I was really thinking. 😎
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 15 posts - 49,801 through 49,815 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply