maybe best if you explain how you are expecting Excel and SQL to interact first....then we can move on

Steve's seems to be working, in my test db environment. But due to the EndYear not being a field and I can't figure out how to edit it as posted,...

serviceaellis (8/21/2015)

---

J Livingston SQL,

Thank you for the link on Using SP!

This is also to sgmunson,

On the question of Crystal, again I thought I answered it.

The end-user enters the year they...

you are welcome....how long did it take to run?

Hi ...welcome to SSC

as a start, I would suggest reading this article below in how to provide us with an easy way to see what you are doing and this...

jessica.green2312 (8/21/2015)

---

Apologies! No, that's an oversight on my part. Here is the corrected sample data and attached example result set:

SELECT 140675885,072915107,1580,'D' UNION ALL

SELECT 140675886,072915107,11,'D' UNION ALL

SELECT 140675887,072915107,1580,'D' UNION ALL

SELECT 140675888,072915107,109,'D'...

guessing.....

declare @d as datetime = '1900-01-01'

select dateadd (dd,41981,@d) as calcdate

calcdate

2014-12-10 00:00:00.000

Which states that the View, which is the only way Crystal could link to that I know of, so again I do not know why solutions were not provided so...

pwalter83 (8/21/2015)

---

Hi,

I have an issue where I need to remove a duplicate row based on a value. For e.g. if there are 2 values - 1234567 and 1234567A, then the...

no problem ...i will wait until you can.

serviceaellis (8/20/2015)

---

Hi J Livingston SQL,

I thought I replied to that formula.

Though it looks to display...

serviceaellis (8/20/2015)

---

To summarize issue,

when the formula is changed to handle >=EndYear it does not produce the correct information for ClubNo 5305.

the correct information is only produced when doing an =EndYear.

The...

Hi BO

just wondering and perhaps you can explain the rationale behind your request please?

here is some test data to use and using ChrisM's code

SELECT TOP 1000000

CustomerID =...

maybe an idea for you try out.....

DECLARE @yr INT

SET @yr = YEAR(GETDATE())

--SET @yr = 2016

;

WITH cteclub AS (

SELECT DISTINCT

ClubID

, ClubNo

, ClubName

, President

--...

ChrisM@Work (8/20/2015)

---

serviceaellis (8/19/2015)

---

Currently working with

DECLARE @yr AS int;

SET @yr = 2015;

which is used in

WHERE (YEAR(EndDate) = @yr)

...