SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 Twit List		  New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 88

X002548
Not Just a Number

15586 Posts
Posted - 04/26/2011 :  14:43:03  Show Profile  Reply with Quote
I expect I did not know that

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
6997 Posts
Posted - 04/27/2011 :  23:21:31  Show Profile  Reply with Quote
It's not using SQL! Why won't anyone believe me?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=159951




CODO ERGO SUM
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts
Posted - 04/28/2011 :  01:22:02  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
quote:
Originally posted by Michael Valentine Jones

It's not using SQL! Why won't anyone believe me?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=159951


And over at SSC (I have no link), probably because we're all such idiots.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29138 Posts
Posted - 04/28/2011 :  04:42:57  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Pretty much same answers there
http://www.sqlservercentral.com/Forums/Topic1099185-149-1.aspx


N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts
Posted - 04/28/2011 :  06:15:28  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
quote:
Originally posted by Peso

Pretty much same answers there
http://www.sqlservercentral.com/Forums/Topic1099185-149-1.aspx


Gee, what a surprise.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

jimf
Flowing Fount of Yak Knowledge

USA
2866 Posts
Posted - 04/28/2011 :  09:57:00  Show Profile  Reply with Quote
I think we all deserver a JOORJie award for promoting literacy.

Jim

Everyday I learn something that somebody else already knew
Go to Top of Page

X002548
Not Just a Number

15586 Posts
Posted - 04/28/2011 :  21:37:42  Show Profile  Reply with Quote
Don't you just love it when ignorance and arrogance come together...



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/
Go to Top of Page

DonAtWork
Flowing Fount of Yak Knowledge

2111 Posts
Posted - 05/03/2011 :  07:07:58  Show Profile  Reply with Quote
quote:
Originally posted by X002548

Don't you just love it when ignorance and arrogance come together...


Leave White Fang out of this!

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page

nigelrivett
Flowing Fount of Yak Knowledge

United Kingdom
3328 Posts
Posted - 05/03/2011 :  16:39:53  Show Profile  Visit nigelrivett's Homepage  Reply with Quote
Is it my imagination or have we had a lot of incomprehensible questions in the last couple of days?
More than usual?
Or maybe old age is getting to me.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Edited by - nigelrivett on 05/03/2011 16:40:46
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts
Posted - 05/03/2011 :  17:49:49  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Am noticing that at SSC too, plus more incomprehensible and wrong answers.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

DonAtWork
Flowing Fount of Yak Knowledge

2111 Posts
Posted - 05/04/2011 :  09:55:21  Show Profile  Reply with Quote
quote:
Originally posted by Michael Valentine Jones

It's not using SQL! Why won't anyone believe me?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=159951




CODO ERGO SUM


Just re-read that one with some more replies.
The double tool shed says he gets no helpful replies, yet there was one sending him to the help forums for the FREAKING PRODUCT HE IS USING!

Our data is in MS SQL SERVER. We do not use T-SQL. You cannot use queries in T_SQL! It isn't a real language and it has no structure!!

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page

jimf
Flowing Fount of Yak Knowledge

USA
2866 Posts
Posted - 05/04/2011 :  10:39:56  Show Profile  Reply with Quote
Moved to here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=139011&whichpage=3

Jim
Edited by - jimf on 05/04/2011 11:24:21
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
6997 Posts
Posted - 05/04/2011 :  10:52:44  Show Profile  Reply with Quote
Obviously, you would want this information on each policy, instead of storing it in a different table.
...
[AgencyPrefix] [nvarchar](10) NULL,
...
[Agency] [nvarchar](80) NULL,
[AgencyDetailAddress1] [nvarchar](255) NULL,
[AgencyDetailAddress2] [nvarchar](255) NULL,
[AgencyDetailCity] [nvarchar](30) NULL,
[AgencyDetailFax] [nvarchar](12) NULL,
[AgencyDetailName] [nvarchar](80) NULL,
[AgencyDetailPhone] [nvarchar](12) NULL,
[AgencyDetailState] [nvarchar](2) NULL,
[AgencyDetailZip] [nvarchar](10) NULL,
...
[AgencyName] [nvarchar](80) NULL,
[AgencyCode] [nvarchar](80) NULL,
...




May be a better post fot this thread:
That Darn Vendor
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=139011




CODO ERGO SUM
Go to Top of Page

jimf
Flowing Fount of Yak Knowledge

USA
2866 Posts
Posted - 05/04/2011 :  11:27:48  Show Profile  Reply with Quote
And our agency "Prefixes" are exactly 2 chars long, never used without the code that is always 4 chars long,e.g., AA1234, but it's good to know we have to room grow!

Jim

Everyday I learn something that somebody else already knew
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
4965 Posts
Posted - 05/05/2011 :  14:30:00  Show Profile  Visit russell's Homepage  Reply with Quote
quote:
Originally posted by DonAtWork

quote:
Originally posted by Michael Valentine Jones

It's not using SQL! Why won't anyone believe me?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=159951




CODO ERGO SUM


Just re-read that one with some more replies.
The double tool shed says he gets no helpful replies, yet there was one sending him to the help forums for the FREAKING PRODUCT HE IS USING!

Our data is in MS SQL SERVER. We do not use T-SQL. You cannot use queries in T_SQL! It isn't a real language and it has no structure!!

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp


Then he went and posted the same question on SQL Mag the next day. Guess he didn't like the answer there either. Hasn't been back lol.
Go to Top of Page

robvolk
Most Valuable Yak

USA
15558 Posts
Posted - 05/05/2011 :  14:42:11  Show Profile  Visit robvolk's Homepage  Reply with Quote
Have you got a link to the SQLMag post?
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
4965 Posts
Posted - 05/05/2011 :  22:33:03  Show Profile  Visit russell's Homepage  Reply with Quote
http://www.sqlmag.com/community/forums/aft/96742
Go to Top of Page

robvolk
Most Valuable Yak

USA
15558 Posts
Posted - 05/05/2011 :  22:44:43  Show Profile  Visit robvolk's Homepage  Reply with Quote
Well, you gotta give him an A for persistence.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29138 Posts
Posted - 05/06/2011 :  00:11:30  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Also see http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=159951
and http://www.sqlservercentral.com/Forums/Topic1099185-149-1.aspx
and http://www.sswug.org/forums/tm.aspx?m=8125
and http://social.msdn.microsoft.com/Forums/en-CA/sqldatabaseengine/thread/4394fb01-070f-4034-887f-5d9c9c7da36b
and http://www.sqlmag.com/community/forums/aft/96742

Everyone tells the same thing; You must specify an ORDER BY in the outermost query.

N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
6997 Posts
Posted - 05/06/2011 :  01:20:59  Show Profile  Reply with Quote
Doesn't look like he ever posted a question on any of the Visual DataFlex support forums:
http://support.dataaccess.com/Forums/forum.php



CODO ERGO SUM
Go to Top of Page
Page: of 88 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000