dva2007 (11/6/2008)

---

Then how about this?

declare @b1 nchar(10)

declare @b2 char(10)

set @b1 = 'B'

set @b2 = 'B'

select @b1 + 'a', @b2 + 'a'

--------------------

B a...

meichner (11/6/2008)

---

Jeff Moden (11/6/2008)

---

No problem... could you provide some test data in a readily consumable format like I asked in my previous post? See the link in my signature...

You need to explain your intentions better if you want an answer

nchar uses 2bytes ber character (unicode) ; char is not unicode and uses one byte per character.

FTP

Good old days... Thanks for the reminiscing!

You should make sure that the "reports" are not scanning ( appropriate indexes in place)

You "can" use with nolock but it should be treated as last resort.

And yes you can...

meichner (11/5/2008)

---

Unfortunately my boss rejected the idea of using a pivot table (I can't really explain why). Is there another way to do this?

Thanks. I really appreciate...

You can use init with backup option...

By the way try to use FOR ATTACH option instead of sp_attach_db

DECLARE @test-2 TABLE (yr CHAR(2))

INSERT INTO @test-2

SELECT '99' UNION ALL

SELECT '00' UNION ALL

SELECT '01' UNION ALL

SELECT '02'

SELECT *

,yr + '-' + RIGHT('00'+ cast((cast(yr as tinyint)+1)%100 as varchar(2)),2) as New

FROM...

bhavnabakshi (10/17/2008)

---

I have to pull new changes in last one month. If there is a duplicate pull the last one. For e.g.

...

Are you running this in the "right" database ?

sure you can.

stricknyn (10/17/2008)

---

Hi all thanks for your response. Unfortunately I can't insert '' into DB since null and '' are not the same thing. Destination would need to be...