Viewing 15 posts - 20,311 through 20,325 (of 22,202 total)
I'm not a hard-core programmer, so forgive me if I say something more stupid than I usually do...
You'll get the number of units that should be displayed and you'll get...
May 23, 2008 at 12:26 pm
You can go into the Advanced Properties of a step and set up a number of retry attempts and a retry interval. That ought to do what you need.
May 23, 2008 at 12:15 pm
Check the code to see if it added the COLLATE key word after the parameter definition. That would cause the problem.
May 23, 2008 at 12:12 pm
fshguo (5/23/2008)
After I compared the execute...
May 23, 2008 at 12:08 pm
Before I try to solve that, you might want to rethink the approach. If you fill out the rows for the user, even though there's no data, you either go...
May 23, 2008 at 10:30 am
dp (5/23/2008)
May 23, 2008 at 8:56 am
Oooh. Excellent. I've got a lot of respect for Aikido. Very useful techniques. We've had people teach seminars on it so that we at least have a level of understanding...
May 23, 2008 at 6:56 am
I'd start with Itzik Ben-Gan's two books, Inside T-SQL Querying and Inside T-SQL Programming.
May 23, 2008 at 6:51 am
That's only one insert every 5.76 seconds. Even if you assume that all the records will come in over a 12 hour period that's only one every 2.5 seconds. Even...
May 23, 2008 at 6:49 am
It's just guesses without some code and structure.
If you step through the process, running the steps manually, can you see the data move appropriately? That's where I'd start.
May 23, 2008 at 6:44 am
You can certainly update from an inner join. That's easy. The trick is to get the join right to start with.
Instead of doing an update, write the whole thing as...
May 23, 2008 at 6:14 am
Since these are all pulling from the same table (except one of the queries) have you looked at either using an OUTER join or even an INNER join to pull...
May 23, 2008 at 6:05 am
I started in Seido in NYC where I got to green. Then I moved and restarted in Goju Ryu where I got to green. That dojo imploded. So I looked...
May 23, 2008 at 5:57 am
I'll go one further, use Matt's solution. That looks good from where I sit.
May 22, 2008 at 3:01 pm
GilaMonster (5/22/2008)
Steve Jones - Editor (5/22/2008)
May 22, 2008 at 12:54 pm
Viewing 15 posts - 20,311 through 20,325 (of 22,202 total)