Viewing 15 posts - 136 through 150 (of 992 total)
The best way to approach this sort of query is using a dates table. Look on this site for "dates table" or "tally table" or "numbers table".
Essentially you want...
February 5, 2008 at 5:09 am
The easiest way for you to solve it yourself is to look up cursors and then just build up a string as you loop over the rows. I guess...
February 5, 2008 at 5:02 am
Perhaps you have some DB corruption? I've seen this sort of thing happen with a corrupted index. The select happens to not use the problem index so you...
February 5, 2008 at 5:00 am
Very cheeky answer - I think you're trying to get him into trouble. There is a subquery there!?
I think if you're going to post homework at least say that...
February 4, 2008 at 2:44 am
For starters, in your classes_subjects joining table you do not want either of the columns to be created as identity columns. Period!
Next, please oh please format your code using...
February 4, 2008 at 2:42 am
I would say DTS as your situation, moving lots of data around, is what it was built for.
Having said that, our app syncs with a number of 3rd party apps...
February 4, 2008 at 2:33 am
I have the very same configuration on my development machine. I have full access to both 2000 & 2005 servers and client tools. As Gail said, make sure...
February 4, 2008 at 12:08 am
Perhaps your SQL Server tempdb is full?
Alternatively, you may have an TEMP environment variable that's pointing to an invalid location.
February 4, 2008 at 12:06 am
Not really possible. You can encrypt your stored procedures though by specifying WITH ENCRYPTION on them. Alternatively you could put your code into .NET assemblies that you attach...
February 4, 2008 at 12:05 am
The query engine can reuse the same plan 30000 times rather than making one HUGE plan. 🙂
Also, doing all the inserts in one batch is a great way to...
February 3, 2008 at 4:28 pm
Peso, you beat me to the punch on the ROW_NUMBER suggestion 🙂
If you're stuck with SQL 2000 then moving the data to a temp table with an identity and then...
February 3, 2008 at 4:20 pm
Pretty much that's your only option. Most DBs that were written for 2000 will work without problems in 2005, especially since the compatibility setting on the database will automatically...
February 3, 2008 at 4:16 pm
You could also (shudder) create a COM object for your powerbuilder code and use the sp_OAxxx procedures in MS SQL to call your code. It depends if you want...
February 3, 2008 at 4:13 pm
As Gail said, create a calculated column on your table which contains the time rounded to the nearest 7.5 minute value - perhaps call it timeRounded. Then create a...
February 3, 2008 at 4:12 pm
The little interaction I've had with Oracle was made a LOT easier by using the product TOAD for Oracle - there's a free copy for you to try. Do...
February 3, 2008 at 4:05 pm
Viewing 15 posts - 136 through 150 (of 992 total)