ironically, it's easy...you just wrap the whole thing to be a sub query:

SELECT ISNULL(CTTitle1,CTTitle) As TheTitle

From

(

SELECT

[CTTitle] =(SELECT TOP 1 TITLE FROM mms.dbo.vwcommitteetermmembers WHERE ID =

...

the REPLACE function is pretty straight forward;

here's an example:

with myAddresses As (

SELECT '164 N. Daves Street,Madisonville,FL 42431' AS ADDR1 UNION ALL

SELECT '1333 Weller Ave,Miami,FL 40208' AS ADDR1 UNION ALL

SELECT...

and here's how you'd use your function in an update statement:

UPDATE MyTable

Set MyColumn = dbo.InitCap(MyColumn)

Chandu's got you going in the right direction; If you downloaded SQL Express and installed it, you might not have SQL Server Management Studio. You'll want to download SQL Server...

your sql statement should not have GO statements, that's all.

this worked fine for me.

note that since i'm quoting the whole thing as a multiline statement, i didn't need the @newline...

Lynn's point on security is a good one; I would think it might be possible with CLR, but I'm not sure; there are a lot of objects that you cannot...

shouldn't that be DBCC SHRINKDATABASE(N'YourDataBaseName' ) instead of shrinkfile? I'm thinking that if you deleted a lot of data, the space is reserved in the MDF, and not in the...

tough call; i'm guessing that you really need to join the the data you are testing to the same two tables Rate_table

and Rate_price_table;

with 6 conditions in the WHERE statement, I'd...

deleting records so there are only 50 left does not shrink the size of the database....the database will keep it's original size, so that it is ready to insert more...

looks like you've already fixed the issue where the multiple single quotes; that was fast.

I still see the issue in my example where a less-than-symbol was assumed to start an...

While I'm thinking about it, can you give us some metrics as well? how many total rows in the table? how many rows are affected in that 15 minute update?

how...

i would guess that you are looking at it wrong; an identity, if you are not searching by that now, would not help performance in the slightest.

I'd like to see...

you might want to consider getting SQL 2008 Developer Edition; it is the latest and greatest and all that.

I just got one earlier last week; I'd been running 2005 forever,...

am i missing something? it looks like a comma delimited string, so you could replace the comma with CrLf (Char(13) + CHAR(10) ) for display purposes, or did you want...

you need to explicitly start a transaction, because SQL server assumes by default that every command is auto-committed unless there is a BEGIN TRAN command;but other than that it is...