Please can you elaborate a bit more, not clear to myself what your asking?

Might be best asking that on a Sharepoint forum or the Sharepoint technet/msdn areas

Also try to post in the right version of SQL servers forums. As you posted in the 2012 forum I gave you a 2012 answer.

Alternatively, detail what version of...

kevaburg (8/8/2014)

Thanks for the answer but...

Code works fine for me.

The code box only shows so much and is scrollable, so you need to ensure you select everything from within the code box, not just what...

Sorry just re-read the post again, as your changing the name and IP of the server, it should create a new record in DNS which will not have been cached,...

Yes, as with anything networking it needs an IP address not a hostname, so your DNS servers handle the hostname to IP address lookup for you.

If your laptop is using...

So with nolock and without nolock, you can get still get different results depending when they where executed.

You will want to use format 121 to get the time in the conversion.

Something like this

select 'plan_werte_'+

REPLACE(

REPLACE(

REPLACE(

left(

CONVERT(VARCHAR(26),getdate(),121)

,16)

,':','')

,'-','')

,' ','')

+'.csv'

And if you remove the "NOLOCK" do you get consistent result?

With uploading nulls and wanting it to be sort of dynamic, the below will work

create table temp

(

unitid int,

[1/2/2011] int,

[1/9/2011] int

)

insert into temp

values

(3,null, 0),

(7,null, 0),

(8,null, 0),

(9,0, 0),

(15, 1696, 1202),

(22, 2769, 1914),

(23,...

You really need to give your data in a consumable format. Please take a moment to look through the "how to post code and data for the best help"...

Not AD, but DNS could.

If your machine uses one set of DNS servers and the QA server uses another set, then yes you could potentially have a mismatch of DNS...

The full backup isn't a copy only backup is it?

Can you check the server where the backup was done from, in its msdb.dbo.backupset there is a is_copy_only column, if its...

A little dirty but works

create table #emp

(

sn int,

code varchar(10),

sal int

)

insert into #emp values

(1,'1100F-',100),

(2,'',200),

(3,'97535-GO',300),

(4,'97530-GO',300),

(5,'',600)

select * from #emp

select

sn,

isnull(

nullif(

replace(

left(code,

charindex('-',code)

),

'-','')

,'')

,'0') as code,

isnull(

nullif(

right(code,

len(code)

-

charindex('-',code)

)

,'')

,'NA') as changed,

Sal

FROM

#emp

drop table #emp