Viewing 15 posts - 9,421 through 9,435 (of 13,874 total)
Have a look here for an example of importing multiple files with the same format.
January 18, 2014 at 5:33 am
But I was actually looking for a multi-tab csv since I am able to add worksheets/ tabs to a csv file manually
Please post an example of one of these.
January 16, 2014 at 1:22 am
kenneth.mofokeng (1/16/2014)
sp_msForEachDB to loop around all databases SELECT sc.name +'.'+ ta.name TableName
,SUM(pa.rows) RowCnt
FROM sys.tables ta
INNER JOIN sys.partitions pa
...
January 16, 2014 at 1:20 am
It's quite advanced, especially given your experience with the product, but this article is relevant.
Also, as others have mentioned, please stop referring to multi-tab CSV files: they do not and...
January 16, 2014 at 12:20 am
mpradeep23 (1/15/2014)
hii want to find count of rows in all tables in database based on created
thanks in advance,
Pradeep
OK, please provide some sample data, DDL and desired results in...
January 16, 2014 at 12:10 am
polkadot (1/14/2014)
January 15, 2014 at 12:28 am
polkadot (1/14/2014)
For now I've removed the EID...
January 14, 2014 at 10:24 am
DaveDB (1/14/2014)
Please refrain from patronizing people. Not everyone is an expert and we are all trying to learn at our own...
January 14, 2014 at 8:21 am
DaveDB (1/13/2014)
Nice to see you again 🙂
I just need to know what the syntax is to include weekends based on a simple date range. Not sure why you would...
January 13, 2014 at 10:43 pm
ducon (1/13/2014)
I was commenting on the old post about the need to troubleshoot and debut packages...
January 13, 2014 at 10:03 pm
You've been a member of this forum long enough to know that you need to provide DDL, sample data and desired results in a consumable format in order to get...
January 13, 2014 at 2:27 pm
Lempster (1/13/2014)
Phil Parkin (1/12/2014)
Your error message suggests that you do not have the correct (or any) version of SQL Server Data Tools (SSDT) installed - please check that. It's not...
January 13, 2014 at 10:05 am
ducon (1/13/2014)
January 13, 2014 at 8:42 am
polkadot (1/12/2014)
January 12, 2014 at 10:43 pm
Thanks for getting into deeper
Few of the rows , first column coming as empty . But do you think in SSIS or Excel this will be a issue as there...
January 12, 2014 at 11:47 am
Viewing 15 posts - 9,421 through 9,435 (of 13,874 total)