Viewing 15 posts - 7,726 through 7,740 (of 8,760 total)
lambrache.theodor (7/26/2014)
select database >task> export....select source DB>select target ...>select table ..
Had this problem few times in the passed when I needed a dataset from SQL Server in a local Access...
July 26, 2014 at 3:10 am
Koen Verbeeck (7/26/2014)
Sean Lange (7/25/2014)
Eirikur Eiriksson (7/25/2014)
Sean Lange (7/25/2014)
Eirikur Eiriksson (7/25/2014)
Jeff Moden (7/25/2014)
Sean Lange (7/25/2014)
July 26, 2014 at 3:05 am
Here is a little snippet to play around with, mind you one cannot blindly read the statistics output;-)
😎
USE tempdb;
GO
SET NOCOUNT ON;
DECLARE @SET_SIZE INT = 1000000;
DECLARE @BUCKET INT =...
July 26, 2014 at 2:52 am
Here is a quick demonstration of a dynamic SQL solution, in case there is no option of changing/adding any tables in the database.
😎
USE tempdb;
GO
/* TEST DATA */
CREATE TABLE dbo.Planner(
[Name] [nvarchar](255)...
July 26, 2014 at 2:06 am
rodeliorodriguez 26453 (7/26/2014)
July 26, 2014 at 1:24 am
A quick thougt, any difference in the select if you add the DISTINCT directive?
😎
July 26, 2014 at 1:17 am
Jeff Moden (7/25/2014)
ken.stoner (7/25/2014)
The cross tab works exactly the way I want it too!Thank you for all your help!
Until you get a 5th row. 😉 Then, you'd need to...
July 25, 2014 at 11:41 pm
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
Viewing 15 posts - 7,726 through 7,740 (of 8,760 total)