Viewing 15 posts - 3,466 through 3,480 (of 7,191 total)
Have you tried changing the protocol to TCP/IP in the alias?
John
July 24, 2014 at 3:53 am
Is it just this one client that can't connect? Is remote access allowed?
EXEC sp_configure 'remote access'
John
July 23, 2014 at 2:12 am
Ashok
OK, I'm assuminng you know how to get all your data into a staging table, which we'll call SampleData. I'm not sure I understand the second and third rules,...
July 22, 2014 at 9:53 am
Prabhu
It depends. You can only find out by testing. Test it with the index drop and without, for all sizes of data you're likely to encounter.
John
July 22, 2014 at 4:43 am
Here's one approach:
(1) SELECT DISTINCT unitname FROM production
(2) Loop through that result set something like this:
SELECT pointname, pointdescription
FROM production
WHERE unitname = ?
(3) Export the result of (2) to an Excel...
July 21, 2014 at 9:56 am
Ashok
How many rows of data do you have? The problem with the SCD, and your stored procedure approach, is that they process one row at a time, which can...
July 21, 2014 at 9:32 am
Do you have access to the server on which the backups were made? If so, you can generate a script by querying the backupset tables in msdb. Alternatively...
July 21, 2014 at 5:20 am
Go to SQL Server Agent and open Jobs. There should be a job called something like <Name-of-your-maintenance-plan>.Subplan_1. You'll be able to see whether that's still running or finished.
John
July 16, 2014 at 5:52 am
Yes, that should work, provided it doesn't break any referential integrity. Otherwise, use UPDATE with a JOIN, or MERGE.
John
July 15, 2014 at 7:12 am
Or use MERGE. This will handle the case where you have new fruits in the first table that aren't in the second.
John
July 15, 2014 at 6:54 am
Bilal
A CREATE TABLE statement, as requested, would have been better, so that I can see whether the Required column allows NULLs. I take it there's nothing already in the...
July 15, 2014 at 5:08 am
Bilal
That's good. It's courteous to post your solution so that those who have helped you can see what you did, and also to help anyone else who has a...
July 15, 2014 at 4:34 am
Bilal
As Gail suggested, you need to use GROUP BY. It's well documented in Books Online and elsewhere. Also, what does your Result table look like?
John
July 14, 2014 at 9:44 am
bilal 17797 (7/14/2014)
So far i managed to write a query which count distinct values in a column
Please will you share that with us. We should be able to point...
July 14, 2014 at 9:25 am
Viewing 15 posts - 3,466 through 3,480 (of 7,191 total)