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.
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...
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...
March 4, 2011 at 6:42 am
ColdCoffee (3/3/2011)
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...
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? ...
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...
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...
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...
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...
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...
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...
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...
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...
March 3, 2011 at 12:48 pm
Koen Verbeeck (3/3/2011)
GSquared (3/3/2011)
While you won't see my ETL and...
March 3, 2011 at 12:28 pm
Viewing 15 posts - 4,711 through 4,725 (of 14,953 total)