If the text only has one period you could use the following:

DECLARE @Col VARCHAR(35)

SET @Col = 'ABCDEFGHIJKLMNOPQRST.0987654321'

SELECT left(@Col,charindex('.',@Col)-1),

right(@Col,len(@Col) - charindex('.',@Col))

glad to hear it. Good luck with everything.

Adam

If you chose mix mode authentication, you should have been prompted to create a password.

login using sa and the password.

If you chose windows authentication, the sa is disabled by default.

Someone...

Lowell,

andrewbrinker stated that he used surface area config. to allow remote connections via tcp. Shouldn't surface area conf update this setting when it implements the change to allows remote connections?

small squares like this ? represent carriage returns

you created an SA account when you setup the instance. Login using sa and setup a sql login for yourself.

sp2 cannot be removed via add/remove programs, when the SQL Instance in unistalled sp2 is removed.

There is more documentation/instruction on uninstalling sp2 here

http://download.microsoft.com/download/2/b/5/2b5e5d37-9b17-423d-bc8f-b11ecd4195b4/ReadmeSQL2005SP2.htm#_1463_uninstalling_sql_server_2005_SP2_fzpy

Adam

When you create a named instance you should connect as as servername\instancename, so you should try servername\WINSERV1

Additionally, have you tried to connect to the server with the specified port?

ie. ...

Alanz and Grant, I would agree with your solution, the query plans speak for themselves. The proposed solution is much more efficient and logically cleaner.

jpack23,

I previously posted a solution; however, I had a mistake in it. I had forgotten to put a where clause in the subqueries, thus the result set would throw...

according to this article, upon shutdown and restart of SQL Server another port is selected

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1638388&SiteID=1

Yes, I would say that the database engine has not been installed.

This should do the trick.

UPDATE TableA

SET Col3 = (select ColC from TableB t2 inner join TableA t1 on t1.Col1 = t2.ColA where ColA = TableA.Col1),

Col4 = (select ColD from TableB...

SQL 2005 Developer edition uses sqlwb.exe. SQL Server express edition uses ssmsee.exe to execute. If SQL 2005 has been installed correctly you should be able to Start -->...

Yes, restore from a production database backup to bring the test database to a consistent state with the production database.

It is always beneficial to start a new project from a...