Viewing 15 posts - 721 through 735 (of 1,193 total)
Hi Steve,
That file (SQLEXPRWT_x86_ENU.exe) is just SQL Express plus Management tools - you need Express with Advanced Services (SQLEXPRADV_x86_ENU.exe) to get Reporting Services.
(And any reason for x86 over x64?)...
October 25, 2012 at 9:24 am
Isn't the mirroring endpoint (TCP://XXX:5022) the server name?
Should tell you which timed out. If there was no failover I'd expect it to be the mirror though.
October 25, 2012 at 9:15 am
Ok, I'm not familiar with that app so can't offer any insight there.
The only thing I can think of now is checking the case of the Database Name, if you're...
October 24, 2012 at 2:54 am
Yeah, think you're right with the next step being to log in with SSMS - not sure what else to suggest at this point!
October 23, 2012 at 9:48 am
Hi Dave,
It was the connect permission I was looking for, just wanted to check it was there.
What's the specific error you get when trying to connect? Anything in the SQL...
October 23, 2012 at 8:58 am
Interesting! Doesn't sound like you have the orphaned user problem either.
Another thing to check would be the user has connect permission on the database - take a look in sys.database_permissions
October 23, 2012 at 8:09 am
Is there a little red down arrow on the user icon in the db they can't connect to?
October 23, 2012 at 7:11 am
Yep, that's a good way - you can roll it into a view or function if you need to calculate it from other sources.
If you need to work it out...
October 23, 2012 at 6:47 am
Is ##SalesData a global temp table in your database?
You could do it with a trigger if it's not a temp table, but I'd strongly recommend using a view or function...
October 23, 2012 at 5:10 am
Hi,
Think this is what you're after, if I've read it right:
SELECT c.CustomerNum, c.Source, COUNT(cm.*)
FROM Contracts c
INNER JOIN CustomerMaster cm ON cm.CustomerID = c.CustomerNum AND cm.Source = c.Source
GROUP BY c.CustomerNum, c.Source
Cheers
Gaz
October 23, 2012 at 4:47 am
davdam8 (10/22/2012)
Thanks Body'sWorks fine now.
Regards
Thanks!
No problem, glad it got sorted. If that ordering does have to appear in other queries, look at putting it in a table as Dave suggested.
You'll...
October 22, 2012 at 10:32 am
Dave Ballantyne (10/22/2012)
Gazareth (10/22/2012)
Dave Ballantyne (10/22/2012)
Why not normalize the CARAC values to a different table , add a 'SortOrder' Column and Bobs you uncle ?Yes, or this 🙂
Didnt want to...
October 22, 2012 at 10:31 am
Dave Ballantyne (10/22/2012)
Why not normalize the CARAC values to a different table , add a 'SortOrder' Column and Bobs you uncle ?
Yes, or this 🙂
October 22, 2012 at 10:21 am
ORDER BY CASE CARAC WHEN 'None' THEN 1 WHEN 'Low' THEN 2 WHEN 'Strong' THEN 3 WHEN 'Extreme' THEN 4 END ASC, PROJ ASC
October 22, 2012 at 10:20 am
davdam8 (10/22/2012)
SELECT PROJ, CARACFROM X
WHERE CARAC<>''
ORDER BY CASE WHEN CARAC= 'None' THEN CARAC ELSE CARAC END DESC
That's identical to:
SELECT PROJ, CARAC
FROM X
WHERE CARAC<>''
ORDER BY CARAC DESC
Works for you in this...
October 22, 2012 at 10:11 am
Viewing 15 posts - 721 through 735 (of 1,193 total)