Viewing 15 posts - 8,611 through 8,625 (of 9,399 total)
Lynn Pettis (12/9/2013)
Dominic Gagné (12/9/2013)
thanks a lot everyone for your replies.I'll see if I can do something with the indexes on the tables
That still will not guarantee the order of...
December 9, 2013 at 1:48 pm
jasona.work (12/9/2013)
On #1, absolutely! This is why there's a QA environment as well. I've actually been developing the code against the QA DB / table.
On #2, I'd forgotten...
December 9, 2013 at 12:51 pm
By chance, is the query being run a view? I know when we upgraded from SQL 2000 to 2005 there were problems because people included an ORDER BY in...
December 9, 2013 at 12:36 pm
I don't think you can say "delete *" - it's just "delete from" but I'm a little uneasy about the approach of deleting with an inner join. Then again,...
December 9, 2013 at 12:28 pm
opc.three (12/9/2013)
JAZZ Master (12/9/2013)
Ed Wagner (12/9/2013)
Revenant (12/9/2013)
Kurt W. Zimmerman (12/9/2013)
Ed Wagner (12/9/2013)
BWFC (12/9/2013)
whereisSQL? (12/9/2013)
Ed Wagner (12/9/2013)
crookj (12/9/2013)Snow (8 inches of it!)
Driving
Skid
Row
Column
pillar
fire
Migration
Route
root
administrator
December 9, 2013 at 11:30 am
I don't have your table structures, but I'd like to present an alternate way. Instead of relying on the data that's there, create a table of months you want...
December 9, 2013 at 10:51 am
First, see the notes above about Ola Hallengren's work. Second, you could also use the QUOTENAME function like this:
select QUOTENAME(name) from sys.indexes;
Another thing to keep in mind is that...
December 9, 2013 at 10:31 am
Revenant (12/9/2013)
Kurt W. Zimmerman (12/9/2013)
Ed Wagner (12/9/2013)
BWFC (12/9/2013)
whereisSQL? (12/9/2013)
Ed Wagner (12/9/2013)
crookj (12/9/2013)Snow (8 inches of it!)
Driving
Skid
Row
Column
pillar
fire
Migration
December 9, 2013 at 10:20 am
BWFC (12/9/2013)
whereisSQL? (12/9/2013)
Ed Wagner (12/9/2013)
crookj (12/9/2013)Snow (8 inches of it!)
Driving
Skid
Row
Column
December 9, 2013 at 9:02 am
Raymond van Laake (12/9/2013)
Hey,After my Stored Procedure has run, I need to call a https://site/blablabla.aspx file. Can this be done from my Stored Procedure?
Thx,
Raymond
Not as far as I know, and...
December 9, 2013 at 8:53 am
crookj (12/9/2013)
JAZZ Master (12/9/2013)
Ed Wagner (12/9/2013)
crookj (12/9/2013)
BWFC (12/9/2013)
Ed Wagner (12/9/2013)
whereisSQL? (12/8/2013)
Revenant (12/8/2013)
GoldfingerThunderball
Ball Lightning
sheet
Charlie Brown
Aaugh!
football
Snow (8 inches of it!)
Driving
December 9, 2013 at 8:00 am
crookj (12/9/2013)
BWFC (12/9/2013)
Ed Wagner (12/9/2013)
whereisSQL? (12/8/2013)
Revenant (12/8/2013)
GoldfingerThunderball
Ball Lightning
sheet
Charlie Brown
Aaugh!
December 9, 2013 at 7:03 am
whereisSQL? (12/8/2013)
Revenant (12/8/2013)
GoldfingerThunderball
Ball Lightning
December 9, 2013 at 5:35 am
bcsims 90437 (12/6/2013)
crookj (12/6/2013)
sing4you (12/6/2013)
Ed Wagner (12/6/2013)
Revenant (12/6/2013)
Ed Wagner (12/6/2013)
bitbucket-25253 (12/6/2013)
crookj (12/6/2013)
Cool (-6 degrees outside)Snow
Ice
T
Coffee
java jive
jive talking
Airplane
Shirley (there are so many quotes it was hard to just pick one)
December 6, 2013 at 1:33 pm
Revenant (12/6/2013)
Ed Wagner (12/6/2013)
bitbucket-25253 (12/6/2013)
crookj (12/6/2013)
Cool (-6 degrees outside)Snow
Ice
T
Coffee
December 6, 2013 at 11:08 am
Viewing 15 posts - 8,611 through 8,625 (of 9,399 total)