Trying To Decipher...
Jul 23, 2007
Gents,
I am new to all this and have received a good chunk of code written for a web-based business I am starting. The developer was less than reliable and now my business partner and I are working to understand what has been done and where we need to go from here.
I am trying to learn MySQL at least enough to understand what we have but it is tough playing catch-up.
Can anyone help with deciphering or can point us in the direction of someone who can help. We are looking for someone that is reliable and affordable.
Please help! Thanks!
Matthew P. Ritchie
View 3 Replies
Jan 10, 2001
I am running a program in SQL 6.5 and I am getting this error message:
"Can't allocate space for object '-451' in database 'tempdb' because the 'system' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment. Sort failed: Out of space or locks in database 'tempdb'
Failed to open tax return
Unable to read data, terminating
Press any key to continue"
Kindly give me advice how to resolve this issue? I don't even know where the problem lies - is it lack of space in tempdb?
Thanks a lot
View 1 Replies
View Related
Jun 10, 2015
I am just trying to decipher this sql and the only thing I do not understand what is going on here is what the "input" key word is doing below. I believe its loading all of the select into the table ##OrderEmails, what is it doing?
Code:
SELECT
LEFT(OAORDT,4) + '-' + SUBSTRING(RTRIM(OAORDT),5,2) +'-' + RIGHT(OAORDT,2) "Date",
OACONO Company,
OADIVI Division,
COUNT(DISTINCT oaorno) "# Orders"
--/*OAORST + '/' +*/ OAORSL "Order Status"
INTO ##OrderEmails
[Code] ...
View 3 Replies
View Related
