Viewing 15 posts - 3,721 through 3,735 (of 4,087 total)
m_cg (6/7/2011)
Still not sure of the format, but gave it 2 ways. Does this work for you?[...]
insert into monthcounter(monthid)
values
(1),
(2),
(3),
(4),
(5),
(6),
(7),
(8),
(9),
(10),
(11),
(12)
Since this syntax was introduced in SQL 2008 and this is a...
June 7, 2011 at 10:00 am
The problem here is that the tax week uses modulo arithmetic and the comparison operators don't. So when the tax week reaches 52 (or 53) it cycles back to...
June 7, 2011 at 7:47 am
bhanu.singh83 (6/6/2011)
Please make me clear.what is basically the 'localhost'? Is it SQL Server Instance?
Thx
First, this question is completely unrelated to the original question. You're better off starting a...
June 6, 2011 at 9:58 am
skcadavre (6/3/2011)
June 3, 2011 at 11:45 am
This is something that is best left to the presentation layer.
Drew
June 3, 2011 at 8:34 am
Jnrstevej (6/2/2011)
Thanks for your reply, its not a homework question i'm in the process of designing a SSRS report and i need this section in the store procedure in...
June 2, 2011 at 9:59 am
Ninja's_RGR'us (5/26/2011)
The other way to find this out is to wrap all the columns with MAX(LEN(column)) and then checking 1 by 1 to see which one(s) bust the limits.
I use...
May 26, 2011 at 10:44 am
I came up with the following solution using a calendar table fragment. You can create a calendar table on the fly using a tally table. I also added...
May 26, 2011 at 10:01 am
peterzeke (5/26/2011)
SELECT ProcessID, Month, Compliant,
ROW_NUMBER() OVER(PARTITION BY ProcessID ORDER BY Month) -
ROW_NUMBER() OVER(PARTITION...
May 26, 2011 at 9:10 am
First, this thread is almost three years old.
Second, the OP has a table that is normalized and asks how to denormalize it. Your sample data starts out denormalized. ...
May 24, 2011 at 8:26 am
You do realize that this thread is over three years old.
Drew
May 23, 2011 at 8:54 am
Maybe the problem is with the GROUP BY itself. There are a couple of approaches you can try instead. Which is more efficient may depend on indices you...
May 20, 2011 at 4:10 pm
SSRS will export to Excel. You can also schedule reports to run automatically, so you might want to investigate using SSRS.
Drew
May 20, 2011 at 8:19 am
Look at the following two articles on cross tabs and pivot:
http://www.sqlservercentral.com/articles/63681/
http://www.sqlservercentral.com/articles/65048/
Drew
May 19, 2011 at 2:58 pm
Ninja's_RGR'us (5/17/2011)
To do this you need to save the spot where you find...
May 18, 2011 at 10:07 am
Viewing 15 posts - 3,721 through 3,735 (of 4,087 total)