Viewing 15 posts - 2,026 through 2,040 (of 4,820 total)
October 12, 2017 at 1:55 pm
Build your own web page and have multiple report viewer controls on it. Those kinds of functionality aren't likely to show up in SSRS any time soon.
October 12, 2017 at 12:52 pm
If you decide you need an inline table-valued function for performance reasons, try this:USE [W_SE-MFG]
GO
/****** Object: UserDefinedFunction [dbo].[QtyOnHandNoExcl] Script Date: 2017-10-12 09:57:22 ******/
SET ANSI_NULLS...
October 12, 2017 at 12:38 pm
October 12, 2017 at 12:13 pm
October 12, 2017 at 12:08 pm
Honestly, I suspect a language translation issue here. I don't quite understand what the poster is really looking for, as the words just aren't making enough sense to provide a...
October 12, 2017 at 11:17 am
October 12, 2017 at 7:28 am
I suspect that part of your problem is that you're taking varchar data and subjecting it to translation to Unicode, as the C# string data type is Unicode. You may...
October 12, 2017 at 6:37 am
Have you tried re-compiling your assembly using VS 2017 and re-deploying? It might just be a version thing, but any time you have CLR and also change versions of SQL...
October 11, 2017 at 7:51 am
Add a ROW_NUMBER() function that partitions by Name and Address, and then ORDER BY [Order], and then you can use CASE statements for a sort of CROSS TAB query that...
October 11, 2017 at 7:44 am
It's probably a VIEW. You might well find other views that are dependent on the tables they select data from, but the existence of a view doesn't necessarily define any...
October 11, 2017 at 7:37 am
I appreciate where you're coming from, but do you understand what the FLOOR function or ROUND function do? Do a Google search on ROUND() and then another on FLOOR() and...
October 11, 2017 at 6:55 am
Just in case you want what I think you want:CREATE TABLE #stats (
id int,
[status] varchar(10),
startdate datetime,
enddate datetime
);
INSERT INTO #stats
VALUES (111,'medium','2014-06-01 00:00:00.000','2015-05-13 00:00:00.000'),
(111,'high','2016-10-31...
October 11, 2017 at 6:38 am
Viewing 15 posts - 2,026 through 2,040 (of 4,820 total)