Carolyn Richardson (2/16/2009)

---

Just adapted a function I have to strip different characters, this won't give you a small int, but do you really need this to be a small int....

Why to loop around, when you really don't need to?

Matt Miller (2/16/2009)

---

Also - hedging your bet so that the CHARINDEX always returns a valid value to the LEFT function might make the error go away.

update tblDrawings

set TypeCode = (...

Dong Lee (2/16/2009)

---

Thank you for your reply.

I got the same error message that posted earlier.

Server: Msg 170, Level 15, State 1, Line 3

Line 3: Incorrect syntax near '<'.

I ran the...

Dong Lee (2/16/2009)

---

Thank you for your reply. The script you posted gave me an error message that I kept on getting. Here is the error message.

Server: Msg 170, Level 15,...

...Just need to replace GETDATE() with DATEADD( "Day", -1, GETDATE() ) in the expression

...You can do a REPLACE of such characters with an empty string.

REPLACE( REPLACE(TelephoneNo, "-",""), "/", "" )

...You missed the ELSE & END part of the CASE statement, it should be like...

UPDATEtblDrawings

SETTypeCode = ( CASE SheetNumber WHEN CHARINDEX( '-', SheetNumber ) <> 0 THEN LEFT( SheetNumber, CHARINDEX(...

...DATEADD( "Day", -1, GETDATE() )

Or you can do something like...

DECLARE @strSQL VARCHAR(MAX)

SELECT @strSQL = COALESCE( @strSQL + '; ', '' ) + Query FROM Table1

PRINT @strSQL

--EXECUTE( @strSQL )

Since you cannot upgrade to a higher edition, you are choices are limited of using T-SQL functions such as BULK INSERT, OPENROWSET, OPENXML etc...

...Database Mail is not available in SQL Server 2005 Express Edition

Nikhil (2/15/2009)

---

Ramesh (2/14/2009)

---

I don't know why it's not working in EXCEL, but I know this task can be done without cursors. Well, in fact, it is just a simple...

There are lot of articles on SSC on running totals. See the below articles..

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

http://www.sqlteam.com/article/calculating-running-totals

http://www.sqlservercentral.com/articles/T-SQL/65522/

And also, with SQL 2005, you can do the same using recursive CTE method....

First, I would like to know why would you need to have a separate tables for the same entity? From this, may be we can help you eliminate incorrect...