Viewing 15 posts - 1 through 15 (of 746 total)
When I am installing SQL Server on a server, I usually copy the contents of the DVD to the machine. This allows me to install new instances quickly and easily...
August 21, 2019 at 8:26 pm
I believe powershell can handle that, but most setup applications have silent options so powershell may be overkill for it.
That being said, I would be more concerned about why your...
August 21, 2019 at 6:25 pm
If you are wanting to do it manually, I believe this query should help (may want to tweak it a bit to suit your specific needs):
July 30, 2019 at 8:12 pm
Sorry for the delayed response, but that is the method I would use. Basically exactly the code you have.
Then before you do the delete, do a quick check to make...
July 22, 2019 at 7:29 pm
You would need the same logic in your delete. Your insert and delete logic should be the same or you will either insert data that isn't deleted (resulting in duplicate...
July 11, 2019 at 5:26 pm
Can you have duplicate OperatorID's in the Transaction table?
try running the following query on the Transaction table:
WITH duplicateCheck AS(SELECT OperatorID, count(OperatorID) OVER (PARTITION BY OperatorID) AS OperatorCountFROM...
July 9, 2019 at 7:57 pm
I still see that link taking me to an article about Data Compression Double Take which seems different than SQL and T-SQL for Beginners or is that where it is...
July 8, 2019 at 5:37 pm
With the sample hourly rate being 10,000, I was just trying to make sure I picked a value that was substantially large enough to cover almost everything possible in the...
July 5, 2019 at 4:21 pm
Do you need this to be "real time" data or can you load the data into some system (Hadoop, SQL Server, Oracle, etc) on a nightly basis?
I am not the...
July 5, 2019 at 2:54 pm
I would not recommend putting an excel file on here. Not many people will nab that as there is inherit risk of downloading random files from the internet...
I would just...
July 4, 2019 at 7:05 pm
I think all you need to do is change how it is formatting the cell. When I paste that in with a straight paste (no paste special or anything like...
July 4, 2019 at 6:59 pm
Without seeing the data or having any idea of what things look like, what I would do is something like this for your case statement:
July 4, 2019 at 6:51 pm
I think the link in the OP points to the wrong post?
July 4, 2019 at 6:43 pm
The problem with trying to manage 1,2,3 as well as a,b,c is what happens when you hit 1,a,1? One solution could be to just sign each letter a numeric value...
June 28, 2019 at 11:19 pm
I see a few things that will make this tricky. The first being that the datetime column has no time. So how do you know that m5 went from 3...
June 28, 2019 at 6:50 pm