Viewing 15 posts - 31 through 45 (of 2,611 total)
SELECT
CONVERT(VARCHAR,[Column] / 60) + ':' + RIGHT('00' + CONVERT(VARCHAR,[Column] % 60),2)
FROM
[Table]
February 13, 2009 at 12:00 pm
I was thinking the same thing Ninja's...
I think I would have asked for my money back after attending that conference.
February 13, 2009 at 11:15 am
The SQL Server Destination component is a bulk load operation that must be running on a local SQL instance. It uses the file system for the operation in a...
February 13, 2009 at 10:41 am
I would have to vote for this one.
:Whistling:
February 13, 2009 at 9:34 am
You are not able to schedule it? What's wrong, can you not get to the SQL Job agent UI in management studio? Are you unable to find it...
February 13, 2009 at 9:32 am
A date as a measure is weird. Measures are things that are aggregated. By default, the aggregation method is going to be SUM, so it is possible you...
February 13, 2009 at 9:30 am
I've always preferred someone with common sense and troubleshooting skills and wants to work over someone with a pile of certifications and lots of letters after their name.
Especially these days,...
February 13, 2009 at 9:22 am
The real issue is that names can follow multiple rules.
McDonald and Mcdonald are both correct - for different people.
February 13, 2009 at 7:48 am
peitech (2/13/2009)
lol, our firstname field's probably a varchar(50) or something, that would blow him out :p
As far as I can tell, his first name is Karl - so I think...
February 13, 2009 at 7:46 am
I have said it a lot - proper-casing names is a losing proposition and I would not recommend it.
The funny thing is, I just saw a name that will mess...
February 13, 2009 at 7:29 am
If you have to constantly check the cache against the database, haven't you eliminated the usefullness of the cache?
First, try not to cache data that is really likely to change...
February 13, 2009 at 7:24 am
SQL orders alpha-numeric just fine normally.
[font="Courier New"]SELECT 'L1'
UNION ALL SELECT 'L2'
UNION ALL SELECT 'L3'
UNION ALL SELECT 'L5'
UNION ALL SELECT 'L7'
UNION ALL SELECT 'L6'
UNION ALL SELECT 'L8'
UNION ALL SELECT 'L4'
ORDER BY...
February 13, 2009 at 7:02 am
Roy Ernest (2/13/2009)
Allright... Thanks for the explanation..Did you see this question?? :ermm:
Don't you regularly export relational database systems to an Excel file?
February 13, 2009 at 6:47 am
To do this, you need to give the "Everyone" group access to the cube. This will make the AS security ignore the authentication entirely, so an un-authenticated user should...
February 12, 2009 at 12:59 pm
Grant Fritchey (2/12/2009)
I've been trying to stay away from this thread, but here's one:
That one is pretty good.
February 12, 2009 at 7:16 am
Viewing 15 posts - 31 through 45 (of 2,611 total)