I missed mentioning that the query can also be written by excluding the FROM clause

UPDATEdbo.tblCust

SETLAST_NAME = SUBSTRING( FIRST_NAME, CHARINDEX( ' ', FIRST_NAME ) + 1, 100 ) + LAST_NAME,

FIRST_NAME =...

Are you sure that the below assignment is correct?

SET tblCust.LAST_NAME = SUBSTRING(FIRST_NAME, CHARINDEX(' ', FIRST_NAME) + 1, 100) + LAST_NAME

You are appending the LAST_NAME value to the extracted substring which...

What value do you get in variable intCount? If it returns -1 then it means the recordset object is opened in dynamic mode. Change the CursorType property of...

Can you post the errors that you get while executing the package?

There can be many other ways, though you should have posted in the correct forum.

This solution assumes that there is only 1 row available for an...

shnex (4/30/2009)

---

I have a bit column(flag) and I want to select the records that don't have that column false, that means also the null ones

But when I run the query...

Double post, continue discussions here

I am not sure this can be done using simple methods, though can be achieved by using complex approaches such as application locks, system tables or ole automation objects. ...

Heard about ROW_NUMBER() function in 2005, that's what you require..

IF ( OBJECT_ID( 'tempdb..#Items' ) IS NOT NULL )

DROP TABLE #Items

CREATE TABLE #Items

(

ItemID INT NOT NULL IDENTITY(1,1) PRIMARY KEY CLUSTERED,

ItemName VARCHAR(10)...

The third option can be re-written as

SELECT * FROM table WHERE ( @A IS NULL OR Col1 = @A )

[/CODE]

You can use the reporting services functions such as LEFT & SUBSTRING to display few characters.

I am just posting this so it will get you started with some other better solutions than this one.

DECLARE @SomeDate DATETIME

SET @SomeDate = '1-Apr-1986'

; WITH Employees

AS

(

SELECT1 AS EmployeeID, CONVERT( DATETIME,...

Here is the script that I use to create linked servers...

DECLARE @strLinkedServer NVARCHAR(100)

SELECT @strLinkedServer = 'Prod2005Server'

EXECUTE master.dbo.sp_dropserver

@server = @strLinkedServer,

@droplogins = 'droplogins'

EXECUTE master.dbo.sp_addlinkedserver

@strLinkedServer,

...

Barry,

I've tested both of the solutions and unfortunately:doze:...

Here is sample for Books online that uses XQuery methods

DECLARE @x xml

-- Replace "!" with " ", as the code formatting eats up the XML

SET @x='!Root>

...