Viewing 15 posts - 2,506 through 2,520 (of 6,486 total)
Except that you're not including the ORDERS table in your FROM clause. If you do include it there, you need to join it to your shipping table AND the...
September 30, 2008 at 10:07 am
steveb (9/30/2008)
you can do this using the row_number() function;
SELECT Location, ProductID, Qty,
ROW_NUMBER() OVER (PARTITION BY Location ORDER BY Location, ProductID) AS NewOrder
FROM YOURTABLE
I'm thinking the ranking is...
September 30, 2008 at 8:43 am
ruyfigueiredo (9/30/2008)
I have an database with 250MB and a Log File with 24GB.
After i reconfigure the Autogrowth i have to made...
September 30, 2008 at 8:30 am
You should be able to use PATINDEX for that. At least you can in 2005 (I don't recall there being any major change to patindex between 2000 and 2005).
select...
September 30, 2008 at 8:02 am
There's always TRY/CATCH, too.
begin try
exec ('use john')
end try
begin catch
print 'no luck - try again!'
end catch
September 27, 2008 at 9:58 pm
Jeff Moden (9/27/2008)
Heh... thanks for posting your solution. Sometimes the problem just boils down to "must look eye." 🙂
Any more references like these and you're going to have...
September 27, 2008 at 9:49 pm
Assuming the data type is appropriate - you might have some luck forcing the Bulk insert or BCP to treat that column as a float through a format file (even...
September 27, 2008 at 9:47 pm
jlp3630 (9/26/2008)
As an aside - aren't you telling it NOT to stop with the table's missing?
What do you mean?
To give a little background on my situation, I'm copying data...
September 26, 2008 at 9:35 pm
I just remembered something. There are some special issue with trying to use try/catch over a linked server.
Per BOL:
Calling RAISERROR with severity less than 20 from inside a remote stored...
September 26, 2008 at 9:11 pm
Your script looks a little strange. The Variables you're using in the CATCH aren't declared anywhere. If you want to raise the error you got, then you need...
September 26, 2008 at 8:31 pm
If you size the objects (data and log files) big, then no, you likely wouldn't needd to run a defragmenter.
If on the other hand you don't size the data files...
September 26, 2008 at 8:19 pm
Jeff Moden (9/26/2008)
September 26, 2008 at 8:16 pm
jlp3630 (9/26/2008)
1. drop all tables
2. recreate all tables
3. populate...
September 26, 2008 at 6:00 pm
Unless every destination is in the same direction from a common point, your calculation isn't going to return the right result (if AAA is north of "here" and BBB is...
September 26, 2008 at 4:05 pm
what does this do?
dmsUpdateTriggerPhoneNumberChanged
September 26, 2008 at 3:44 pm
Viewing 15 posts - 2,506 through 2,520 (of 6,486 total)