Viewing 15 posts - 2,026 through 2,040 (of 4,820 total)
October 12, 2017 at 1:58 pm
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
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.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
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...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 12, 2017 at 12:38 pm
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
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...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 12, 2017 at 11:17 am
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 12, 2017 at 7:28 am
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 12, 2017 at 7:27 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...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
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...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
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...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
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...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
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...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
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...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 11, 2017 at 6:38 am
Viewing 15 posts - 2,026 through 2,040 (of 4,820 total)