Viewing 15 posts - 466 through 480 (of 1,246 total)
kevin.obrien 66193 (10/9/2016)
How do I allow for an item in SourceA to be matched to an item in SourceB?
So in my report output, if the user has indicated these 2...
----------------------------------------------------
October 10, 2016 at 11:11 am
MickyD (9/15/2016)
I recently came across a dev database in our organization that had no clustered indexes and circa 100 million row.....:crazy:
In order to rectify I need some advice on...
----------------------------------------------------
October 7, 2016 at 2:36 pm
hoseam (10/5/2016)
I have Test.rdll, with one parameter and one dataset
Dataset:
Name:Country
Query:
select distinct
[Country]
from [DW].[dbo].[Dim_Country]
where Active = 1
and Country = @Country
Parameter:
General; Name= Country, Prompt = Country, Data...
----------------------------------------------------
October 7, 2016 at 1:18 pm
GilaMonster (10/4/2016)
CferMN (10/4/2016)
Could you please explain how to tell what the table is most frequently filtered by or how to tell the most common predicate used against the table?
You go...
----------------------------------------------------
October 7, 2016 at 11:44 am
marc.corbeel (10/6/2016)
Problem is here that my real query is very complex (about 40 lines), and putting it 2 times...
----------------------------------------------------
October 7, 2016 at 11:07 am
moranamon (10/6/2016)
Actually, it'll never be MTM as each photo predicts a unique indicator. as for the location, i don't store the photos in the DB but on remote storage (Azure)...
----------------------------------------------------
October 6, 2016 at 11:36 am
Are you sure this will never be a many to many relationship, even if it is not one now? A person can appear in more than one photo but can...
----------------------------------------------------
October 4, 2016 at 4:37 pm
MMartin1 (10/4/2016)
peter478 (10/3/2016)
Based on last day in month I found week number via function DatePart("ww", 30.11.2016) result is 40 or other. It does not matter.
The...
----------------------------------------------------
October 4, 2016 at 3:49 pm
peter478 (10/3/2016)
Based on last day in month I found week number via function DatePart("ww", 30.11.2016) result is 40 or other. It does not matter.
The task...
----------------------------------------------------
October 4, 2016 at 3:38 pm
sanjaydut26 (10/2/2016)
ALTER FUNCTION [dbo].[ufn_GetHcmDesignFields]
(
@ModuleId bigint, -- HCM_DESIGN_FIELDS moduleid with IsExtendable status 1
@RID bigInt -- table rid
)
RETURNS nvarchar(max)
AS
BEGIN
DECLARE @Return...
----------------------------------------------------
October 4, 2016 at 3:13 pm
henryKrinkle (10/4/2016)
D1, T1, C1, P1, ORDER1, LINE1, 100
D1, T2, C1, P1, ORDER1, LINE1, 500
D1, T3, C1, P1, ORDER1, LINE1, 100
Hi,
Thanks for your input.
In an ideal world, yes, the lines...
----------------------------------------------------
October 4, 2016 at 10:56 am
RonKyle (10/3/2016)
If not you could add your own line item number within the group -->(date, customer, product, orderNumber, lineItem) as your key. Maybe you can even populate a calculated field...
----------------------------------------------------
October 3, 2016 at 1:23 pm
D1, T1, C1, P1, ORDER1, LINE1, 100
D1, T2, C1, P1, ORDER1, LINE1, 500
D1, T3, C1, P1, ORDER1, LINE1, 100
Sorry if I missed a detail here, would the line numbers not...
----------------------------------------------------
October 3, 2016 at 1:03 pm
I myself advocate for the lowest possible granularity unless you know for sure you wont need the details. For example, can one of those transactions be reversed at a later...
----------------------------------------------------
October 3, 2016 at 12:51 pm
this has to be done by grouping and expression in ssrs . So , cannot use CTE.
I am curious about this requirement. Would you mind sharing why?
----------------------------------------------------
October 3, 2016 at 12:32 pm
Viewing 15 posts - 466 through 480 (of 1,246 total)