Viewing 15 posts - 4,711 through 4,725 (of 14,953 total)
I've been avoiding ident_current and scope_identity since SQL 2005 came out with the Output clause. Avoids the problem completely and has a number of other benefits as well.
- 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
March 4, 2011 at 9:00 am
Tom.Thomson (3/3/2011)
GSquared (3/3/2011)
Tom.Thomson (3/3/2011)
GSquared (3/3/2011)
While you won't see my ETL...
- 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
March 4, 2011 at 8:16 am
Jeff Moden (3/3/2011)
Heh... or just do it all in T-SQL stored procedures. :-D:-P;-)
That doesn't work as well when you're processing some types of data.
For example, I built an SSIS solution...
- 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
March 4, 2011 at 6:42 am
ColdCoffee (3/3/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
March 4, 2011 at 6:35 am
Just keep in mind that, no matter how well you search locally on your server, you can't be sure you've got everything. That's where a trace is critical.
Other servers...
- 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
March 4, 2011 at 6:32 am
I guess I'd have to see what you're talking about. I can't visualize it well enough to suggest anything at this point.
Would a separate file per e-mail 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
March 4, 2011 at 6:28 am
Just be glad he goes by ColdCoffee. Think how much worse it would be if you had to say the day was saved by FlatRootbeer, or SpoiledMilk.... WarmBeer might...
- 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
March 3, 2011 at 2:22 pm
What object type are you using for the query to Oracle? If it's an ODBC/OLE DB data source, the query can contain variables, which can be assigned values elsewhere...
- 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
March 3, 2011 at 1:53 pm
lee rite (3/3/2011)
ColdCoffee (3/3/2011)
lee rite (3/3/2011)
Thanks again! I think I'm done! I really appreciate all the help!Will i be getting a Samsung Focus for this help , mate ?? :hehe:
I...
- 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
March 3, 2011 at 1:51 pm
I'm not sure if you can, but I have to ask why you would.
Couldn't you have those three steps in one package, and have each of the three call 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
March 3, 2011 at 1:49 pm
Tom.Thomson (3/3/2011)
GSquared (3/3/2011)
While you won't see my ETL and database...
- 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
March 3, 2011 at 1:47 pm
ColdCoffee (3/3/2011)
SELECT GUIDFROM #T
GROUP BY GUID
HAVING COUNT( DISTINCT CompanyName) = 1
That'll get the ones that haven't changed. Change it from equals 1 to greater than 1 and...
- 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
March 3, 2011 at 1:03 pm
Tom.Thomson (3/3/2011)
GSquared (3/3/2011)
While you won't see my ETL and database...
- 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
March 3, 2011 at 12:54 pm
lee rite (3/3/2011)
Craig Farrell (3/3/2011)
lee rite (3/3/2011)
Let me explain exactly what I'm working with, so you will see...
- 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
March 3, 2011 at 12:48 pm
Koen Verbeeck (3/3/2011)
GSquared (3/3/2011)
While you won't see my ETL and...
- 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
March 3, 2011 at 12:28 pm
Viewing 15 posts - 4,711 through 4,725 (of 14,953 total)