An nvarchar column can store any Unicode data. A varchar column is restricted to an 8-bit codepage

among many here are a few of the same question:

http://www.sqlservercentral.com/Forums/Topic101964-9-1.aspx

Hi all,

As I suspected the problem was the compatibility level. Although it showed 100, it was not really converted. by downgrading it to 90 and pressing OK (It...

More development for your info...

I think I might have put my finger on the problem...

When I restored the database in my lab, the database restored with a compatibility...

so I connected to the client...

took all the info down and even took a backup of his DB.

compared everything with my lab and all is the same... My...

we received calls from clients that are using SQL2005 SP2 - I even had them upgrade their service Pack. didn't work

another client, had the same issue with SQL 2008 R2...

we need sample data to be able to help you.

Create table ...

insert into ...

and select statement that you're trying and the wanted result.

thanks

JG

Is this what you are trying to achieve?

SELECT

U.EPDIVI AS DIV

,U.EPSUNO AS 'Supplier No'

,U.EPSINO AS 'Suppier Inv No'

,CONVERT(DATE,CAST(U.EPDUDT AS VARCHAR(8)),112) AS 'Invoice Due Date'

,U.EPTRCD AS 'Transaction Code'

,U.EPRECO 'Reconcile Code'

,DATEDIFF(DAY, GETDATE(),CONVERT(DATE,...

Since I work for a Software development company, I have the issue where all development has to work for all versions of SQL Server with different OS's...

What I have...

As far as I know, I think you won't have a choice to go this route...

create table test (mydates varchar(10))

Insert into test values (20110905),(20110901),(20111003)

select mydates,

convert(varchar(10),convert(datetime,substring(mydates,1,4) + '-' +...

Hi,

Not sure if I'm the only one but really hard to understand what you are trying to accomplish and what the question is.

thanks

JG

Using DMVs

you can use something Like this

SELECT session_id as SPID, command, a.text AS Query, start_time, percent_complete, dateadd(second,estimated_completion_time/1000, getdate()) as estimated_completion_time

FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) a

WHERE r.command...

If I understand your question properly,

Here's what I came up with...

SELECT t.FromUserID, t.ToUserID, t.msg, FromU.UserName AS UserFrom,

FromU.GroupID AS FromGroup, ToU.UserName AS UserTo, ToU.GroupID AS...

Hi Jeff,

I'm sorry to bother you but I'm still trying to get this running properly and had to turn to you for help since you seem to be the best...

:pinch::crazy::pinch::crazy::pinch::crazy::pinch::crazy::pinch::crazy:

I'm speachless... I thought you were pulling my leg!!!

I have been learning a lot lately which is something that didn't have time to do in past jobs due to...

You can change the collation at the DB Level but, If I'm not mistaken, it will not change your data.

the columns will stay in the old collation.

you will...