Viewing 15 posts - 166 through 180 (of 703 total)
It's not clear what you're trying to do. The topic you posted is "How to get Excel sheet A1 column value", which is ambiguous because in Excel, "A1" is...
March 29, 2011 at 9:55 am
vikram.gharge (3/29/2011)
SQL Server 2008 brought us some new date types including DATETIME2 .............There's some fun to be had with 1751 as well but we'll leave that for another holiday.
Vikram,
What's...
March 29, 2011 at 9:28 am
Ray K (3/24/2011)
...contemplating which game(s) to attend. I'm thinking about the June 26 game (Old Timer's Day) against -- sorry, Steve -- the Colorado Rockies.
That (old timer's day) can...
March 24, 2011 at 2:45 pm
Perhaps your instructor will provide the correct answer after you and your classmates have submitted your attempts.
March 20, 2011 at 10:11 pm
You may find that a Case structure beats a series of IF's (as suggested by Howard), and that using date arithmetic is faster than CONVERT().
Create FUNCTION [dbo].[ROUNDDATE]
(
@Datetype varchar(4),...
March 18, 2011 at 7:15 pm
ehlinger (3/11/2011)
March 15, 2011 at 1:20 pm
Koen,
Thank you. I must have been brain-cramping to not realize that by using a SQL query, of course one may specify the "table" from which the data is to...
March 11, 2011 at 9:59 am
It's not completely clear what you're trying to do. Your original post said you wanted to "choose a tab from the file in the Excel Data Source". That...
March 10, 2011 at 9:37 pm
May I suggest you ask about this in the more appropriate Business Intelligence forum and that you note here that you've done so. That way you'll get the...
March 10, 2011 at 8:12 pm
May I suggest you ask about this in the more appropriate Business Intelligence forum and that you note here that you've done so. That way you'll get the...
March 10, 2011 at 8:01 pm
Tom.Thomson (3/8/2011)
john.arnott (3/8/2011)
March 8, 2011 at 10:24 pm
Tom.Thomson (3/8/2011)
There is however a problem with use of imprecise English - this is of course sheer nit-picking, and I'm not complaining because I guessed that the...
March 8, 2011 at 11:04 am
KMPSSS (2/20/2011)
Actually i got this query from net. Below one is query.
select sum(convert(bigint,case when status & 64 = 0 then size else 0 end))
, sum(convert(bigint,case...
February 28, 2011 at 9:56 am
In the Duke's memory, this would be a good time to re-read Roger Kahn's "The Boys of Summer" to get a feel for what the Brooklyn Dodgers, and baseball in...
February 28, 2011 at 9:11 am
Maybe it's just a typo in your post, but if the collumn name in the table is [server_name], then the query should use that same name and not [SQLServer_name].
February 25, 2011 at 11:57 am
Viewing 15 posts - 166 through 180 (of 703 total)