|
|
|
|
-
Dalibor Commented 10 Months ago through Blogs
Madhivanan, the solution with @date-0.5 works because datetime conversion to int use ROUND function....
|
-
Dalibor Commented 10 Months ago through Blogs
Two more solutions...
declare @date datetime
set @date='20120107 19:22:10'
SELECT
DATEADD(DAY,CONVERT(INT,@date - 0.5),0)
, CONVERT(DATETIME, FORMAT ( @date, N'yyyy-MM-dd'))...
|
-
Dalibor Commented 10 Months ago through Just Learned
This solution is without GROUP BY clause.
--Use tempdb
USE tempdb
--Create a dummy table to store 4 date fields
DECLARE @Temp TABLE(TempId int identity(1,1),Date1 Date, Date2 Date, Date3 Date, Date4 Date)
--Insert ...
|
-
Dalibor Commented 10 Months ago through Just Learned
This solution is without GROUP BY clause.
--Use tempdb
USE tempdb
--Create a dummy table to store 4 date fields
DECLARE @Temp TABLE(TempId int identity(1,1),Date1 Date, Date2 Date, Date3 Date, Date4 Date)
--Insert ...
|
-
Dalibor Liked 10 Months ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
ghanadbashi.s Received Vote Up 12 Months ago through ASK
HI!
Just click F4 on "(details)" in "Row Groups" section.
Set following properties:
- Hidden = True
- ToggleItem = Group1 (Name of the group)
If you want to see sum values when the group is collapsed then in the TextBox Message_Numbers put =...
|
-
Dalibor Commented 12 Months ago through Ask
HI!
Just click F4 on "(details)" in "Row Groups" section.
Set following properties:
- Hidden = True
- ToggleItem = Group1 (Name of the group)
If you want to see sum values when the group is collapsed then in the TextBox Message_Numbers pu...
|
-
ghanadbashi.s Question Received 12 Months ago through ASK
Hi
![alt text][1]
I want from bellow image get above image (I want to pack the group appearance).
![alt text][2]
http://social.msdn.microsoft.com/Forums/getfile/121567
Link address: http://social.msdn.microsoft.com/Forums/en-US/sqlreporti...
|
-
Dalibor Liked 2 Years ago through Tutorials
This tutorial will help you to get started with SQL Server Reporting Services (SSRS)...
|