Savya (6/14/2016)

---

based on email id and phone the customer is unique. If the customer changes the order it should only update the product columns which are modified for example internet,video...

Lynn Pettis (6/14/2016)

---

joe-584802 (6/14/2016)

---

Thank you so much for the replies this is what I ended up doing as a Scalar-Valued Function

CREATE FUNCTION [dbo].[GetHarvestYear] (@InputDate datetime)

RETURNS int

AS ...

joe-584802 (6/14/2016)

---

Thank you so much for the replies this is what I ended up doing as a Scalar-Valued Function

CREATE FUNCTION [dbo].[GetHarvestYear] (@InputDate datetime)

RETURNS int

AS

BEGIN...

Unfortunately, your picture cuts off much of the data. It is hard to tell how the data should be combined from multiple rows to a single row. Please...

Luis Cazares (6/14/2016)

---

I expect that Lynn's option can be simplified without errors.

DECLARE @Sample TABLE(

SomeDate datetime,

HarvestYr int

);

INSERT INTO...

GSquared (6/14/2016)

---

I wouldn't do this in an SQL function. I'd put it as a column in a Calendar table and have it pre-calculated and queriable.

Use Calendar tables for this...

something like this:

declare @TestDate datetime;

set @TestDate = '2016-06-15 10:12:00';

select year(dateadd(year,datediff(year,0,dateadd(month,-6,@TestDate)),0));

set @TestDate = '2016-07-15 10:12:00';

select year(dateadd(year,datediff(year,0,dateadd(month,-6,@TestDate)),0));

set @TestDate = '2017-03-12 14:30:00';

select year(dateadd(year,datediff(year,0,dateadd(month,-6,@TestDate)),0));

Kingston Dhasian (6/14/2016)

---

Actually its...

As for how my query works, start with the following:

http://www.sqlservercentral.com/articles/T-SQL/62867/

http://www.sqlservercentral.com/articles/Tally+Table/72993/

The rest, play with the date functions. Understand that the zero (0) in the datediff function represents 1900-01-01 that is...

DiabloSlayer (6/14/2016)

---

Hi Lynn Pettis,

That's exactly the results I need so THANK YOU very much !!

But... I don't know two things, so if you could please help me 🙂

1. How do...

DiabloSlayer (6/13/2016)

---

Thanks to both twin.devil and Lowell for the quick solution, that's exactly the output I was looking for and presented to the client however ..

The client now added a...

The execution plan (even an estimated plan at this point) would also help.

DiabloSlayer (6/13/2016)

---

Hello Everyone,

I need some help in setting up a Calendar Table or an Staging Table that I can use for running some reports.

I'm given a Start Date and an...

TSQL Tryer (6/13/2016)

---

Hi there,

I have the following TSQL

select STUFF(( SELECT ISNULL(',' + ltrim(rtrim(l.Description)) + ' ' + ltrim(rtrim(c.Surname)),'')

FROM ContactDetail c

LEFT JOIN ContactGroupMember cgm ON cgm.ContactId =...

Phil Parkin (6/10/2016)

---

Brandie Tarvin (6/10/2016)

---

Ed Wagner (6/10/2016)

---

WayneS (6/10/2016)

---

Phil Parkin (6/8/2016)

---

And why not ask them to make it idempotent while you're at it:

IF COL_LENGTH('dbo.mytable', 'col1') IS NULL

BEGIN

...