Viewing 15 posts - 7,726 through 7,740 (of 8,753 total)
Quick question, how are you exporting it?
I normally find importing to access faster than exporting to access.
😎
July 25, 2014 at 3:18 pm
Jeff Moden (7/25/2014)
Eirikur Eiriksson (7/25/2014)
Jeff Moden (7/25/2014)
Chand00 (7/25/2014)
Hi,Thank you. Below one worked for me.
$QueryResults[0].Table.Columns.Count
Apologies. I tried to post but I was unable to post somehow. Once again Thankyou
Still, why does...
July 25, 2014 at 2:15 pm
First a quick question, where are you based (country)?
It depends but in my opinion it is more or less a waste of time unless the client is seeking something like...
July 25, 2014 at 1:34 pm
Thank you Dwain for this very good article!
😎
July 25, 2014 at 1:28 pm
Sean Lange (7/25/2014)
Eirikur Eiriksson (7/25/2014)
Jeff Moden (7/25/2014)
Sean Lange (7/25/2014)
July 25, 2014 at 1:25 pm
John Mihalko (7/25/2014)
Jeff Moden (7/25/2014)
John Mihalko (7/25/2014)
Why does SELECT CONVERT(varchar(4),263000) or SELECT CAST( 263000 AS varchar(4)) return * ?You would think '3000' to be return. :unsure:
Because SQL Server does not...
July 25, 2014 at 1:01 pm
Jeff Moden (7/25/2014)
Sean Lange (7/25/2014)
July 25, 2014 at 12:53 pm
Jeff Moden (7/25/2014)
Chand00 (7/25/2014)
Hi,Thank you. Below one worked for me.
$QueryResults[0].Table.Columns.Count
Apologies. I tried to post but I was unable to post somehow. Once again Thankyou
Still, why does this need to be...
July 25, 2014 at 11:59 am
GBeezy (7/25/2014)
I took just the UPDATE statement you provided, took out the variables, input what I needed, and I was able to update my column...
July 25, 2014 at 11:49 am
Quick question, can you post the execution plans?
😎
July 25, 2014 at 8:41 am
Quick suggestion using mickyT's data, mind you, as I posted before, that this is not accurate when using geometry.
😎
SELECT
*
FROM dbo.Location L
OUTER APPLY #Events E
WHERE L.coordinates.STBuffer(10000).STIntersects(E.coordinates) =...
July 25, 2014 at 2:09 am
Here is a quick solution, should get you passed this hurdle.
😎
USE tempdb;
GO
DECLARE @XML_ID INT;
DECLARE @FILE_NAME VARCHAR(255);
SET @XML_ID = 2;
SET @FILE_NAME = 'text_file.txt';
DECLARE @TXML XML ;
DECLARE @XML_TABLE TABLE (XML_ID INT IDENTITY(1,1)...
July 25, 2014 at 1:43 am
Not certain what the purpose of the RANK is there as it is not needed in the solution. Also, writing the code took a lot less time than formatting the...
July 24, 2014 at 10:52 pm
vobinh2401 (7/24/2014)
Hi there, I have installed SQL. But i can't see SQL Server Surface Area Configuration. Please help me !!
It was removed after SQL Server 2005, this article might help
July 24, 2014 at 10:08 pm
Quick and simple
😎
USE tempdb;
GO
/* LETS PRETEND THIS IS THE TABLE */
;WITH BASE_DATA AS
(
SELECT
ItemId
...
July 24, 2014 at 1:53 pm
Viewing 15 posts - 7,726 through 7,740 (of 8,753 total)