Viewing 15 posts - 136 through 150 (of 162 total)
One tool that is readily available to you as a part of the SQL Server 2k5 without any additional cost is SSRS (SQL Server Reporting Services). You can use this...
January 16, 2008 at 12:56 pm
The another way to get the same result:
select top 25 * from Products a
where ProductID in (select top 50 ProductID from Products)
order by...
January 16, 2008 at 12:13 pm
Hi Venki,
It is my pleasure to inform that I have posted the second version of my work
Calculating the Number of Business Hours Passed Since a Point of Time[/url]
I have modified...
January 14, 2008 at 11:41 am
Sorry, no idea. You should provide the structure of your three tables x, y, z and some sample rows if you want more help.
Sincerely,
Maz
January 8, 2008 at 7:55 am
Ahmad,
I already gave you the answer. The keyword here that will solve your purpose is 'embedded query'
The solution will be:
---------------------------------------------------------
select z.category,x.count(distinct customers) as cnt, y.sum(sales) as sales from
x inner...
January 7, 2008 at 11:35 am
Congatulations Steve,
I feel honored too by associationg with you and the community through SQLserverCentral.
Sincerely,
Maz
January 7, 2008 at 9:51 am
Dear Carlos,
You had a similar remark earlier also
when i execute the function "select dbo.ufninc_CalcTimeSinceCreated (getdate(),getdate()+1)" it return 9 hours instead of the 8 hours.
Then you sloved it yourself.
By the...
January 5, 2008 at 11:42 am
You can do like this:
select Category, Count, sales from 'Your Table view or embedded query'
union
select 'Total', sum(Count), sum(Sales) from 'Your Table view or embedded query'
order by 2
The result will be:
-------------------------
CategoryCountSales
-------------------------
ABC1250.00
ZYX2450.00
PQR3550.00
Total61250.00
January 4, 2008 at 4:45 am
You are right. This is a rat race. But in a rat race it is not guarented that the older and fatter rat will necessarily win.
SQL Server is surely a...
January 4, 2008 at 4:23 am
You can try to use SSRS 2005. I had the same problem with my SSRS 2005 reports when some one checked the anonymous login in the IIS folders. I fixed...
January 4, 2008 at 4:04 am
Hi carlos,
Nice to see you back. I know the reason. This is because you need to modify your function dbo.ufninc_CalcGetDate
I have clarified this in the first posting in this...
January 4, 2008 at 3:09 am
Dear carlosdanielsousa,
Here is the bug:
You need to move the code
if dbo.ufninc_DataAMeiaNoite(@VarCalcCreateDate) in (select dbo.ufninc_DataAMeiaNoite (EffectiveIntervalStart) from dbo.CalendarRuleBase where ExtentCode=2 and SubCode=5)
set @VarCalcCreateDate = dbo.ufninc_DataInicioTrab(@VarCalcCreateDate + 1)
7 lines down its present...
January 3, 2008 at 3:18 pm
I think I can resolve the issue if I see your modified code. Apparently it is not able to get out of the loop if the previous day of the...
January 3, 2008 at 5:01 am
Also check the properties of the two virtual folders in the IIS and uncheck the 'Anonymious Login'
January 1, 2008 at 8:55 am
Check your browser settings:
Tools -> InternetOptions -> Security -> Custom Level -> Make the User Authentication as Anonymous Login
December 29, 2007 at 5:17 pm
Viewing 15 posts - 136 through 150 (of 162 total)