Viewing 15 posts - 9,391 through 9,405 (of 15,381 total)
Want a cool sig (2/5/2013)
February 5, 2013 at 10:10 am
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...
February 5, 2013 at 9:34 am
anthony.green (2/5/2013)
But I seriously would recommend changing the connection string and not using...
February 5, 2013 at 9:21 am
adonetok (2/5/2013)
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...
February 5, 2013 at 8:22 am
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...
February 5, 2013 at 8:16 am
Jeff Moden (2/4/2013)
Not even close... I'm trying to quit smoking, again, and my jokes are really going to such for about the next 6 months because of it. 😛
You can...
February 5, 2013 at 8:02 am
Abu Dina (2/5/2013)
So many views and no replies?! Where are the clever guys these days?! :crying:
I think the biggest challenge to getting an answer is that this code is really...
February 5, 2013 at 7:59 am
Duplicate post. Direct all replies here. http://www.sqlservercentral.com/Forums/Topic1415756-1633-1.aspx
February 5, 2013 at 7:41 am
HildaJ (2/5/2013)
Maybe you could use the sql statement below:update tablename set column3 = column1 + column2
That doesn't accomplish the running total like the OP is looking for.
February 5, 2013 at 7:25 am
ian.hewitt 52640 (2/5/2013)
If you were to use the standard MS Stored Procs? At what point would they get overwritten? Setting up replication again?
They have the potential of being overwritten...
February 5, 2013 at 7:21 am
Great question Tom. My only complaint is that it was so well written there is no room for ambiguity or misinterpretation. 😉
February 5, 2013 at 7:08 am
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?
February 4, 2013 at 12:23 pm
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...
February 4, 2013 at 12:22 pm
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...
February 4, 2013 at 12:11 pm
Viewing 15 posts - 9,391 through 9,405 (of 15,381 total)