Viewing 15 posts - 3,856 through 3,870 (of 7,185 total)
Could it be a rounding error?
John
September 3, 2013 at 2:31 am
First, you need a table with all those August dates in it. Do you already have one? If not, you can create a permanent one or use a...
August 30, 2013 at 3:34 am
I think the only way is to make the user the owner of the databases in question. From the documentation:
If the database being restored does not exist, the user...
August 30, 2013 at 2:43 am
Looks serious. Use your favourite search engine to investigate this error: SqlDumpExceptionHandler: Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. You may have...
August 29, 2013 at 9:05 am
Posting exactly the same thing again doesn't alter the fact that it's from SQLAGENT.OUT, not from the SQL Server errorlog. From the Access Denied error, I'd say you've got...
August 28, 2013 at 4:46 am
Mark-101232 (8/28/2013)
Is there some significance in 'AA' in Danish/Norwegian? It seems to sort after 'Z'
Yes, I think you've nailed it. Take a look at the very bottom line of...
August 28, 2013 at 4:38 am
That's telling you that SQL Server Agent stopped because SQL Server stopped unexpectedly. To find out why SQL Server stopped, try the SQL Server errorlog or the Windows event...
August 28, 2013 at 4:14 am
I didn't get that. What is your server collation set to?
John
August 28, 2013 at 2:36 am
So you don't want XXX to be able to change YYY's permissions? Start by removing XXX from sysadmin. What do you want XXX to be able to do?
John
August 28, 2013 at 1:30 am
Probably several ways of doing that, but this one will work:
WITH a (aval, astamp) AS (
SELECT min(value), min(t_stamp) from @t
WHERE value = (SELECT min(value) FROM @t)
)
, b (bval, bstamp) AS...
August 28, 2013 at 1:26 am
Could it be because you have ">=" in the first and ">" in the second?
John
August 27, 2013 at 5:13 am
Because NULL means "unknown" and therefore "NULL not equal to 'Check' " can't equate to True.
John
August 23, 2013 at 4:29 am
Because you're looking for those students who have a match with every row in tblData. Therefore the row count for each student needs to be the same as the...
August 22, 2013 at 3:36 am
prasanta.paul 88490 (8/22/2013)
Am I doing correct?
You tell me. Is it returning the results you expected? If it is, then your requirement has changed, because you said you only...
August 22, 2013 at 2:09 am
Here you go. Obviously it doesn't return any rows for your sample data, but if it did, you could join back to A if you need the student name.
John
SELECT
B.StudentID
FROM
B
JOIN
TblData...
August 22, 2013 at 1:39 am
Viewing 15 posts - 3,856 through 3,870 (of 7,185 total)