cannot post in some forums -can't find server HELP

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

cannot post in some forums -can't find server HELP

Author

Topic

ashley.sql
Constraint Violating Yak Guru

299 Posts

Posted - 2007-08-10 : 17:29:44

Moderators help

I cannot post in some forums. For example I am trying to reply to this forum

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=87688

But it won't post and I get cannot find server and there are some other posts as well. What could be the problem

Here is my reply just in case somebody else can post it there.

CREATE TABLE #Table1 (C1 money)

INSERT INTO #Table1 VALUES(4.13)
INSERT INTO #Table1 VALUES(4.24)
INSERT INTO #Table1 VALUES(6.76)
INSERT INTO #Table1 VALUES(5.17)
INSERT INTO #Table1 VALUES(5.29)

select convert(varchar(20),C1) from #table1

Ashley Rhodes

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-08-10 : 17:33:00

I was able to reply to it.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-08-13 : 01:57:32

quote:
Originally posted by ashley.sql

Moderators help

I cannot post in some forums. For example I am trying to reply to this forum

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=87688

But it won't post and I get cannot find server and there are some other posts as well. What could be the problem

Here is my reply just in case somebody else can post it there.

CREATE TABLE #Table1 (C1 money)

INSERT INTO #Table1 VALUES(4.13)
INSERT INTO #Table1 VALUES(4.24)
INSERT INTO #Table1 VALUES(6.76)
INSERT INTO #Table1 VALUES(5.17)
INSERT INTO #Table1 VALUES(5.29)

select convert(varchar(20),C1) from #table1

Ashley Rhodes

You dont need to convert the NUMBERs to VARCHARs
See Dinakar's approach on the other thread

Madhivanan

Failing to plan is Planning to fail

ashley.sql
Constraint Violating Yak Guru

299 Posts

Posted - 2007-08-13 : 09:42:37

i don't know whats blocking me but I still cannot post reply to that post.

Ashley Rhodes

ashley.sql
Constraint Violating Yak Guru

299 Posts

Posted - 2007-08-13 : 11:31:05

still cannot post.
strange

Ashley Rhodes

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-08-13 : 11:44:16

quote:
Originally posted by ashley.sql

still cannot post.
strange

Ashley Rhodes

Perhaps sun Foster has blocked you

(j/k) .

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources