What is supposed to be doing the insert? A person? An application?

One idea is to have a trigger on the table that takes the inserted ID value and adds them...

We need DDL statements for your tables, inserts, and the queries with any parameters you are using in your report to pull your datasets.

Please start from the top. Just...

kevin.obrien 66193 (10/9/2016)

---

Hi,

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

MickyD (9/15/2016)

---

Hi everyone.

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

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