Viewing 15 posts - 2,551 through 2,565 (of 5,394 total)
You can't do this. A linked server table is not a valid target for SELECT ... INTO.
You will have to create the table and the insert data with INSERT INTO.
Hope...
October 4, 2011 at 3:38 am
Read this article on how to post performance problems: http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post the required information and I'm sure lots of people will try to help.
October 4, 2011 at 2:52 am
Duplicate post.
Replies here please: http://www.sqlservercentral.com/Forums/FindPost1184998.aspx
October 4, 2011 at 2:50 am
serr4no (10/3/2011)
A partitioned database got wiped and then block-restored (no other backup available), it's now attached but wont go online since the...
October 4, 2011 at 2:34 am
October 4, 2011 at 2:29 am
L' Eomot Inversé (10/3/2011)
If we had a mechanism for plus votes I would be using it!
I think I've seen this exact conversation recently with quoter and quoted inversed.
I...
October 3, 2011 at 1:47 pm
That was a great question!
Got it wrong, as usual.
However, I think the reason behind the slowness of the table variable is the poor cardinality estimation more than the recompile itself....
October 3, 2011 at 10:07 am
SQL Kiwi (10/3/2011)
Gianluca Sartori (10/3/2011)
Uh! Thank goodness! I was afraid he couldn't.
Nah I think SSC is pretty good overall at not censoring questions. Very polite of Chad to...
October 3, 2011 at 9:47 am
SQL Kiwi (10/3/2011)
Chad Crawford (10/3/2011)
Really? Can I ask you both why?Yes you can.
Uh! Thank goodness!
I was afraid he couldn't.
October 3, 2011 at 9:32 am
Patrick Womack (10/3/2011)
I have a named instance that is scheduled to reboot once a month.
May I ask why?
Can anyone tell me how to prevent this from happening again?
Looks like the...
October 3, 2011 at 8:55 am
drew.allen (10/3/2011)
Prasanthi Reddy (10/2/2011)
Hi,I have a table which contains on and off status of a meter. Feederstatus = 0 means On and feederstatus=1 means Off.
You do realize that this is...
October 3, 2011 at 8:46 am
J Livingston SQL (10/3/2011)
select convert(varchar,getdate(), 120) + ' ' + CASE WHEN DATEPART(hour,GETDATE()) > 12 THEN 'PM' ELSE 'AM' END
Please note that the "hour" datepart does...
October 3, 2011 at 7:42 am
ChrisM@Work (10/3/2011)
:blush: shucks it's just a copy of yours Luca!
I don't think so!
October 3, 2011 at 7:35 am
If you insist doing it on the DB side, here's the code:
--yyyy-mm-dd hh:mi:ss AM/PM
DECLARE @dt datetime
SET @dt = GETDATE()
SELECT
CAST(YEAR(@dt) as char(4)) + '-' +
REPLACE(STR(MONTH(@dt),2),' ','0') + '-' +
REPLACE(STR(DAY(@dt),2),'...
October 3, 2011 at 6:57 am
You can do it manually concatenating the single dateparts.
However, IMHO this kind of things does not belong to the database layer and should be coded on the application side.
October 3, 2011 at 6:49 am
Viewing 15 posts - 2,551 through 2,565 (of 5,394 total)