Want a cool sig (2/5/2013)

---

Welcome... it would help if you provided DDL and sample data and what you expect to see as a result. There's a link to a...

Just add this as a column in your select

CASE WHEN ImportDays <= DATEADD(day,-30,getdate()) THEN 'NEW' ELSE 'Older than 30 days' END AS ImportDate

And be careful with NOLOCK it has a...

anthony.green (2/5/2013)

---

Well then as long as you have a linked server from ServerA to ServerB you will be ok.

But I seriously would recommend changing the connection string and not using...

The code I posted will accomplish this.

adonetok (2/5/2013)

---

Below is statement for a table

select * from myserver.mydatabase.dbo.order

I want to declare a path to modify above statement but got an error.

declare @mypath varchar(50)

set @mypath = 'myserver.mydatabase.dbo.'

select * from...

Hi and welcome to SSC! You will find this forum is full of helpful and knowledgeable people.

It is impossible from your description to offer much advice because there just aren't...

You can...

I think the biggest challenge to getting an answer is that this code is really...

Duplicate post. Direct all replies here. http://www.sqlservercentral.com/Forums/Topic1415756-1633-1.aspx

That doesn't accomplish the running total like the OP is looking for.

They have the potential of being overwritten...

Great question Tom. My only complaint is that it was so well written there is no room for ambiguity or misinterpretation. 😉

Do you have any applications that use this database? If so, look at the connection string. 😛

If not, wouldn't it be easier to just uninstall and reinstall?

I know you are trying here but you have got to test these scripts if you want help. At this point your ddl is string across a number of posts...

And be VERY careful with all those NOLOCK hints. Do you know the dangers that hints brings along? Missing and/or duplicate data? It may be fast but accuracy is impossible...