Look, you are creating a GLOBAL temp table (## = Golabal, # = Session-based).. this has visibility globally.. so there may be some other code in your PROD system that...

Chris Morris-439714 (9/6/2010)

---

It doesn't look right to me either. Check these out:

DECLARE @s1...

Chris Morris-439714 (9/6/2010)

---

ColdCoffee (9/6/2010)

---

Chris Morris-439714 (9/6/2010)

---

Try this, CC:

--SQL 3(use 2 variable together,the same results)

SELECT @s1 = '10_45', @s2 = '20_45'

SELECT @s1 = @s1 + NAME--, @s2 = @s2...

Chris Morris-439714 (9/6/2010)

---

Try this, CC:

--SQL 3(use 2 variable together,the same results)

SELECT @s1 = '10_45', @s2 = '20_45'

SELECT @s1 = @s1 + NAME--, @s2 = @s2 + NAME

FROM...

Bhuvnesh (9/6/2010)

---

ColdCoffee (9/6/2010)

---

Now if u see, the first and third uses @s1, which is VARCHAR(10) , but the first one truncates the result to only one values 10_jack, while the...

Duplicate post. No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic981041-392-1.aspx

Chris Morris-439714 (9/6/2010)

---

Must be monday...

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

DROP TABLE #TempTable

CREATE TABLE #TempTable

(

A INTEGER,

B VARCHAR(10) ,

C MONEY,

D XML

)

You can run this code many times, without the...

Chris, even in the first try i dint find anything strange.. Execute them, u will find it strange..

A small example:

;WITH Tens AS

(

SELECT 1 N UNION ALL

SELECT 1 UNION ALL

SELECT 1 UNION ALL

SELECT 1 UNION ALL

SELECT 1 UNION ALL

SELECT 1 UNION ALL

SELECT...

ROW_NUMBER Function will do the trick for you..

HEre are some articles on that

ROW_NUMBER(): An Efficient Alternative to Subqueries

Paging and Versioning Using ROW_NUMBER() [/url]

ROW_NUMBER MSDN link

How is this ?

IF OBJECT_ID('A') IS NOT NULL

DROP TABLE A

IF OBJECT_ID('B') IS NOT NULL

DROP TABLE B

IF OBJECT_ID('C') IS NOT NULL

DROP TABLE C

Create table A( ID INT IDENTITY(1,1) , A1...

Will tables A, B and C have only one row per table all the time?

Try this:

SELECT * FROM Coloum1 WHERE CHARINDEX( N'?????' , oldarabictext ) > 1

.value(varchar) handles the special characters like < or > or & etc.. please go thro this for further details:

http://sqlblog.com/blogs/rob_farley/archive/2010/04/15/handling-special-characters-with-for-xml-path.aspx