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

Spiff (9/29/2016)

---

MMartin1 (9/29/2016)

---

In the SSIS expression builder , enter:

(DT_DATE)((DT_WSTR, 4) year(getdate())+"-"+ REPLICATE( "0", 2-LEN((DT_WSTR, 2)(month(getdate())+1) )) + (DT_WSTR, 2)( month(getdate())+1) +"-01")

EDIT : This will give you...

xr280xr (9/29/2016)

---

drew.allen (9/26/2016)

---

Luis Cazares (9/26/2016)

---

drew.allen (9/26/2016)

---

xr280xr (9/26/2016)

---

I don't specifically care about short circuiting. I just need to only evaluate b if a is false and only evaluate c if a...

In the SSIS expression builder , enter:

(DT_DATE)((DT_WSTR, 4) year(getdate())+"-"+ REPLICATE( "0", 2-LEN((DT_WSTR, 2)(month(getdate())+1) )) + (DT_WSTR, 2)( month(getdate())+1) +"-01")

EDIT : This will give you the first...