Viewing 15 posts - 151 through 165 (of 726 total)
But you're definitely over the river.
It appears that your inner FETCH is out of place. You're doing two fetches before the first insert. Typically, when the first fetch is outside...
August 29, 2007 at 10:56 pm
If you're looking for matches, just index them and do an INNER JOIN between the two tables on that single column. If that's not what you're looking for, then more...
August 29, 2007 at 10:48 pm
Without any sample data to work with, at a glance it certainly looks like you can get your numbers by simply grouping by QuoteTypeID and TransTypeID. I'm not sure where...
August 28, 2007 at 1:08 pm
Since I didn't even notice that the columns were static (I have a tendency to miss stuff when awake, and more so when half-asleep), I'll add to what Matt Miller said....
August 28, 2007 at 1:02 pm
I should probably not just give the answer without the obligatory Dynamic SQL disclaimer: The Curse and Blessings of Dynamic SQL.
August 28, 2007 at 6:59 am
A few things. First, you need dynamic SQL to do what you are trying to do, and I'm not sure that's something I'd recommend for your first ever SP.
Second, with...
August 28, 2007 at 5:16 am
Based on that description, the two "Visibility" properties, "Hidden" and "Toggle" are what you need to work with. Read up on them in BOL and you should find it fairly...
August 27, 2007 at 7:16 pm
I'd personally use the rs.exe utility to run scripts that do the moves for you. I've seen tools that will create the scripts for you, but they don't seem to...
August 27, 2007 at 10:57 am
This is sweet. No more DBCC Page commands for me!
As an aside, does Kalen Delaney know about this tool yet? She might find it quite interesting, since she's person that...
August 27, 2007 at 10:07 am
Put parentheses around the @sql in the EXEC statement.
August 26, 2007 at 1:26 pm
The file doesn't contain headers and the first four rows are filled with Null values. You really can't see the rows? I bet you're one of those people who can't...
August 23, 2007 at 9:13 am
Assuming you're using the Execute method of the Command object, is it possible that you've added the parameter to make the execution asynchronous? If so, removing that should take care...
August 22, 2007 at 10:58 pm
I'm not Peter, but that looks a lot like QA to me, based on the colors.
August 21, 2007 at 10:12 am
And once you code for those, invariably someone in the company will bring up that you need to deal with "O'", "von" (sometimes there is no space between that and the rest of...
August 21, 2007 at 10:08 am
Actually, I skipped over the first part and the prizes and went straight to Rex's letter, as I was most interested in how she's holding up. In fact, when I...
August 20, 2007 at 3:45 pm
Viewing 15 posts - 151 through 165 (of 726 total)