Forum Replies Created
Viewing 15 posts - 361 through 375 (of 59,066 total)
-
Reply To: Unstuck
Rod at work wrote:To this day I don't understand how come no one in IT saw the pattern that adding only a little more disk space and having that consumed within a...
-
Reply To: Check sequential order of status of items
Phil Parkin wrote:Ah yes, there's another thing I should have mentioned! After composing your code, please try running it. Yours fails to run.
The code probably worked perfectly on the OPs machine. ...
-
Reply To: Forum Etiquette: How to post data/code on a forum to get the best help
brian.cook wrote:This was very helpful. I learned some also from it.
I hopefully have posted my current question in a better format and have explained myself well enough.
Thank you
My apologies. Apparently,...
-
Reply To: Weekday different executing procedure directly or executing by SQL Server Agent
If you would post the code you're using, perhaps we could solve all of your problems with a bit of a magic temporal formula that doesn't rely on any settings...
-
Reply To: Pivot Mistake
antonio.perez wrote:Thanks a lot Drew.
It works perfectly
I think you may have a larger issue on your hands... It's a really bad idea to store temporal data as strings.
-
Reply To: SQLExternalMonitoring what is it in sp_who2 result
You'll probably need to look at Task Manager or Resource Monitor to figure out exactly what software is being executed there. Do you have an infrastructure team that might know?
-
Reply To: I have never seen an insert statement with -= tablename in place of values
Jonathan AC Roberts wrote:I think it is a typo, they probably meant to type '-- = inv.tblSoftware'
Which would mean that inv.tblSoftware is just a comment for clarity, describing something about the insert...
-
Reply To: Automate reports for when the SQL database was last used
First, I hope that you're taking a final full backup followed by a "Tail Log" backup to properly shut down a database prior to drop it.
As for determining if the...
-
Reply To: TSQL query - adapt Part2 to include Part1
Ed B wrote:I don't understand what you need to do. I presume that you don't want to union all query 1 with query 2. Do you need to left outer join...
-
Reply To: I have never seen an insert statement with -= tablename in place of values
lee.hopkins wrote:We have a third part software and looking at some of their SQL we found this
INSERT INTO tblSoftware ( Inventory , Software, [Name] , Manufacturer , [Language] , [...
-
Reply To: need guidance on reposting
stan wrote:hi one of the forums i use is specifically for netsuite.
To be clear, do you mean the forum is on this SQLServerCentral site? If so, could you provide a...
-
Reply To: I'm asking for guidance on how to best discover PK-FK relationships
Rod at work wrote:Last night I spent 45 minutes composing a complicated question here. When I finished I started the review, and then Chrome, crashed. Thanks, Chrome. This isn't the only time...
Viewing 15 posts - 361 through 375 (of 59,066 total)