Viewing 15 posts - 2,551 through 2,565 (of 5,393 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...
-- Gianluca Sartori
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.
-- Gianluca Sartori
October 4, 2011 at 2:52 am
Duplicate post.
Replies here please: http://www.sqlservercentral.com/Forums/FindPost1184998.aspx
-- Gianluca Sartori
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...
-- Gianluca Sartori
October 4, 2011 at 2:34 am
I guess you're looking for this:
Viewing Another Session’s Temporary Table
Hope this helps
Gianluca
-- Gianluca Sartori
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...
-- Gianluca Sartori
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....
-- Gianluca Sartori
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...
-- Gianluca Sartori
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.
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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!
-- Gianluca Sartori
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),'...
-- Gianluca Sartori
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.
-- Gianluca Sartori
October 3, 2011 at 6:49 am
Viewing 15 posts - 2,551 through 2,565 (of 5,393 total)