Viewing 15 posts - 3,361 through 3,375 (of 14,953 total)
forsqlserver (9/13/2011)
As you know on servers excel doesn't exist.I have tried it option (Save to file) and saved in .rpt,.csv,.xls,.txt still finally it was opening on my system...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 14, 2011 at 5:18 am
How far have you gotten in SSIS? Connections established and tested? Dataset from the source table created?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 13, 2011 at 9:31 am
Is it possible the stored procedure has multiple result sets, or that the remote server has MARS enabled? (Multiple Active Result Sets = MARS)
In either case, it will work...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 13, 2011 at 9:29 am
This is an SQL Server site, so I'm not sure advice about DB2 will be fully accurate.
Are you using SSIS to do the update? (Asking because that's the specific...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 13, 2011 at 9:25 am
Row_Number() is the most likely solution, as already mentioned.
However, it won't be deterministic if you don't have something in the table that it can Order By. You might get...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 13, 2011 at 9:09 am
NJ-DBA (9/13/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 13, 2011 at 9:06 am
With that Charindex call in the Where clause, it's always going to be a scan, not a seek. If you have any significant number of rows, it's going to...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 13, 2011 at 6:59 am
I usually just copy-and-paste into Excel for that kind of thing.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 13, 2011 at 6:33 am
jagat.patel (9/12/2011)
This is not Homwork.
I I have similar Business rqeuirement . and to get answer from foram readers I just simplify my xml.
My original XML is really...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 13, 2011 at 6:29 am
You've got a bit of a problem in that Node2 should either have a direct value or sub-values, but it can be compensated for with an IsNull/Coalesce function call.
The query...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 12, 2011 at 1:31 pm
In the data flow, between the source and the destination, you can put a Derived Columns object, and you can map variable values into columns in that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 12, 2011 at 11:39 am
SELECT *
FROM OPENROWSET(BULK 'MyFilePathAndName', FORMATFILE='MyFormatFile', LASTROW=4) AS MyFileImport ;
That's a sample. You'll need an actual file and an actual format file. There are samples of format files that...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 12, 2011 at 11:37 am
meichner (9/12/2011)
Welsh Corgi (9/12/2011)
@meichner,I meant that you were not going to get shot. :hehe:
I feel for you for you are in a tough situation. Been there done that.
Regards
Can I take...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 12, 2011 at 11:34 am
The OpenRowset function (details here: http://msdn.microsoft.com/en-us/library/ms190312.aspx) allows you to assign first and last rows for imports using it.
Will it always be four dates in every file, or does it vary?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 12, 2011 at 11:27 am
Welsh Corgi (9/12/2011)
Ninja's_RGR'us (9/12/2011)
Welsh Corgi (9/12/2011)
It is so obvious that they are not real world problems. They are...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 12, 2011 at 8:42 am
Viewing 15 posts - 3,361 through 3,375 (of 14,953 total)