Viewing 15 posts - 11,116 through 11,130 (of 13,872 total)
Are you saying that the columns themselves are the same, but just that the column names are different?
Or that you want to dynamically select which columns are exported and that...
September 28, 2011 at 9:29 am
Your sample data is a bit confusing.
Looks like you have a field in the format
<span [text] MM/DD/YYYY</span>
is that correct?
If it is, would it be fair to say that extracting the...
September 28, 2011 at 4:07 am
Shriram R C (9/28/2011)
Hi all,i have three databases in my server.i wanna synchronize all the three db's. is it possible to achieve through ssis?
SSIS is not a mirroring tool per...
September 28, 2011 at 3:25 am
Use SSIS and Excel 2007+.
Now please answer the 'TOP' question. I'll spell it out.
Assume you have 10 companies
Company1, Company2, ..., Company10
The first time you run
SELECT TOP 3 Company from Company
you...
September 26, 2011 at 7:16 am
engrshafiq4 (9/26/2011)
i have more than 100000 records in company table...i want to export in excel and then do some correction and then import again.....i have a...
September 26, 2011 at 6:57 am
Not enough detail here.
Please follow the link in my signature for details on how to post questions such as this.
September 25, 2011 at 4:28 am
I think you can code round this using IsNull():
avg(DATEDIFF(DAY, o.ocDateOpened, IsNull(o.ocDateClosed,GETDATE())))
September 23, 2011 at 7:58 am
You'll be able to do it with an asynchronous Script Component - will take a bit of coding but if you're familiar with VB or C# it's nothing too onerous.
September 22, 2011 at 10:54 am
steveb is correct. Ignore Kramaswamy's post.
September 22, 2011 at 10:01 am
palash.gorai (9/22/2011)
Hi,Try the following syntax:-
select convert(varchar(12),getdate(),101)Result:-
9/19/2007
regards
Palash Gorai
How is this relevant?
September 22, 2011 at 1:52 am
I see - that's probably down to good luck in terms of timing. Much better to order things properly and then you shouldn't have these issues at all.
September 21, 2011 at 10:04 am
Koen Verbeeck (9/14/2011)
Phil Parkin (9/14/2011)
September 21, 2011 at 7:58 am
Sudhir's idea seems the least cumbersome to me ...
Or (and I am not sure whether this is even possible, because I have not tried importing from Access for ages...) use...
September 21, 2011 at 7:51 am
Viewing 15 posts - 11,116 through 11,130 (of 13,872 total)