Viewing 15 posts - 7,696 through 7,710 (of 11,677 total)
The question is a bit vague, so the only thing I can add is that you will also need a GROUP BY clause to make your query work.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 2:05 pm
They are just different providers. ADO.NET is the ActiveX Data Object for .NET, OLE DB is implemented using the COM model.
Important points are:
* OLE DB is most of the times...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 2:03 pm
How did you do the import exactly?
What is the datatype of the column that stored the date and time information?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 1:56 pm
The problem is that the JET OLE DB provider - used to read Excel files - tries to "guess" the datatype.
It scans the first 8 lines of the column and...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 1:38 pm
david.alcock (3/8/2012)
Its OK, found I could use a table, just assumed that was for data only!
SSRS thinks it does, because you (unfortunately) still have to assign a dataset to it...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 1:34 pm
Phil Parkin (3/8/2012)
The File System task does not have the required horsepower.
The File System Task doesn't even have the horsepower to decently move a file, let alone do something more...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 1:24 pm
Jack Corbett (3/8/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 1:20 pm
Then why not create a stored procedure instead of trying to bypass security to execute a .sql file?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 1:06 pm
FunkyDexter (3/8/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 1:05 pm
Ken Davis (3/8/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 10:10 am
Daniel Bowlin (3/8/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 9:59 am
Do you know upfront how many little files you need to create?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 9:57 am
Jack Corbett (3/8/2012)
Has anyone gotten the newsletter today? I have not and I keep getting a notification email for the same post.
Got mine a bit late, but...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 9:55 am
Phil Parkin (3/8/2012)
Just modify your proc to UNION the two result sets and you're good to go.
+1
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 9:54 am
Is it possible to modify the stored procedure?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 7:25 am
Viewing 15 posts - 7,696 through 7,710 (of 11,677 total)