hoseam (10/5/2016)

---

Hi,

I have Test.rdll, with one parameter and one dataset

Dataset:

Name:Country

Query:

Parameter:

General; Name= Country, Prompt = Country, Data...

GilaMonster (10/4/2016)

---

You go...

marc.corbeel (10/6/2016)

---

Yes but here you include the complete select command in the condition.

Problem is here that my real query is very complex (about 40 lines), and putting it 2 times...

moranamon (10/6/2016)

---

Hi,

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)...

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...

MMartin1 (10/4/2016)

---

peter478 (10/3/2016)

---

Let me explain what I need.

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...

peter478 (10/3/2016)

---

Let me explain what I need.

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...

sanjaydut26 (10/2/2016)

---

Here is the function...

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...

henryKrinkle (10/4/2016)

---

Hi,

Thanks for your input.

In an ideal world, yes, the lines...

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...

Sorry if I missed a detail here, would the line numbers not...

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...

I am curious about this requirement. Would you mind sharing why?

Another way to approach this is if you have a rowID column in your table , you can derive one into a temp table from the base table if you...

Hmm, I would rather do this in the SQL code ...

I scrapped up the following >>

with cte as

(

selectcast('20140701' as date) as cteDate

Union all

selectdateadd(d, 1,c.cteDate)

fromcte as c

wherec.cteDate <'20140731'

)

,nextCte as

(

select top...