Viewing 15 posts - 466 through 480 (of 3,666 total)
jasona.work (7/31/2015)
By the way all...Happy SysAdmin day!
:hehe::cool::w00t::-D
Thanks, but when's the SQL Dev day? 😎
😀
July 31, 2015 at 1:16 pm
I guess I've had enough of this forum for this week.
http://www.sqlservercentral.com/Forums/Topic1707595-2799-1.aspx
July 31, 2015 at 12:58 pm
newbieuser (7/31/2015)
Our customer is moving to SQL 2012 and they have installed SQL Server 2012 instance a new db server. I have a list of new...
July 31, 2015 at 12:54 pm
SQLRNNR (7/31/2015)
Alvin Ramard (7/31/2015)
Ladies and gentlemen, take my advice - pull down your pants and slide on the ice.screeeeeeeeeeeeeeeeeeeeeeeeeeech
What?
You're not familiar with the saying?
July 31, 2015 at 12:19 pm
Ladies and gentlemen, take my advice - pull down your pants and slide on the ice.
July 31, 2015 at 10:32 am
You could look into the possibility of using snapshots or synonyms.
Snapshots would essential hold a static copy of your data while you're ding your updates.
Synonyms could be used to switch...
July 31, 2015 at 10:30 am
ben.brugman (7/31/2015)
Is there is 'fairly' simple query to delete duplicate rows from ANY table ?A script which removes duplicates from a table, when a table_name is supplied.
Ben
To answer the original...
July 31, 2015 at 10:24 am
Luis Cazares (7/31/2015)
WayneS (7/31/2015)
Looks like Luis is answering Oracle questions now.
That wasn't the only attempt on that day. Here's a completely lost Oracle user.
But hey, as long as I can...
July 31, 2015 at 9:58 am
Sean Lange (7/31/2015)
Alvin Ramard (7/31/2015)
Lynn Pettis (7/31/2015)
July 31, 2015 at 9:53 am
Phil Parkin (7/31/2015)
sgmunson (7/31/2015)
Naina_11 (7/27/2015)
it's done. I added a Level column with 0 and 1 and ordered accordingly.Thanks
Another alternative:
DECLARE @testing AS TABLE (
DepDate datetime,
val int
);
INSERT INTO @testing VALUES ('2014-01-10 00:00:00.000',...
July 31, 2015 at 9:40 am
Lynn Pettis (7/31/2015)
July 31, 2015 at 9:38 am
Do you have access to the connection string?
July 30, 2015 at 2:28 pm
kennyhuang0108 (7/30/2015)
here is an error msg :ORA-00933: SQL command not properly endedthanks
WAIT!!!!!
Error message: ORA-00933???
Is this an Oracle query? FYI, this is not an Oracle forum.
July 30, 2015 at 12:48 pm
kennyhuang0108 (7/30/2015)
Thanks Alvin.The erros msg I got is :ORA-00923: FROM keyword not found where expected
Maybe adding the word FROM after
select distinct b.lev5 AS "LEVEL 1",b.lev5NAME, C.lev7 "FUND", C.lev7NAME,round...
July 30, 2015 at 12:37 pm
Brandie Tarvin (7/30/2015)
Alvin Ramard (7/30/2015)
Need more magic crystals.I am writing code for an automagical solution to all coding problems.
Try starting all procedures with:
DROP DATABASE ...
July 30, 2015 at 12:35 pm
Viewing 15 posts - 466 through 480 (of 3,666 total)