mar.ko (9/2/2015)

---

I need to use the same SQL source code in more than one stored proc.

Is there a way to -include mysql.sql or something like that ?

How does everyone handle...

Jason A. Long (9/4/2015)

---

Unless CR has changed drastically since the last time I used it, it's not going to be able to do anything with the ever changing set of...

aleksandra 81219 (9/4/2015)

---

Sean Lange (9/4/2015)

---

No, I have n variables from erp system and these...

candide (9/1/2015)

---

Hi,

I use SAP Crystal Report V.14 and SS2012, my task is to build a report/pivot with CR for the last 12 months. As I read in several forums it...

How about the following somewhat dynamic cross tab?

CREATE TABLE #Leagues (

LeagueId int IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,

LeagueName nvarchar(50) NULL

);

CREATE TABLE #Players (

PlayerId int IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,

UserId...

candide (9/1/2015)

---

Hi,

I use SAP Crystal Report V.14 and SS2012, my task is to build a report by CR for the last 12 months. As I read in several forums it...

ramrajan (9/3/2015)

---

-- Find Quarter difference count

declare @enddate datetime = '2015-09-03 00:39:53.973'

declare @startdate datetime = '2014-11-07 00:42:39.920'

WITH Quarters AS (

SELECT Q = '1', MonthBegin...

Okay, take a look at the following code:

WITH SampleData (PERSON,TRANSACTDATE, STARTDATE, END_DATE, IN_PUNCH, OUT_PUNCH, [HOURS], PAYCODE) AS (

SELECT 1234,'08/03/2015','08/03/2015','08/03/2015', '06:00','09:00','3','REG1' UNION ALL

...

Grant Fritchey (8/25/2015)

---

sgmunson (8/25/2015)

---

Jeff Moden (8/25/2015)

---

sgmunson (8/25/2015)

---

Rod at work (8/24/2015)

---

Hmmm. Thank you Grant, I really appreciate the straight forward explanation for what the rowversion/timestamp is all about. I'm working on...

Jeff Moden (8/25/2015)

---

sgmunson (8/25/2015)

---

Rod at work (8/24/2015)

---

Hmmm. Thank you Grant, I really appreciate the straight forward explanation for what the rowversion/timestamp is all about. I'm working on archiving the data,...

Rod at work (8/24/2015)

---

Hmmm. Thank you Grant, I really appreciate the straight forward explanation for what the rowversion/timestamp is all about. I'm working on archiving the data, but leaving it...

scott.laird (8/25/2015)

---

I am doing some execution plan analysis. I have found that some plans do not contain: @StatementOptmEarlyAbortReason.

I am looking for values: GoodEnoughPlanFound, TimeOut, MemoryLimitExceeded.

Can anyone explain this / provide...

Bruceo (8/21/2015)

---

Hey Steve,

Happy Friday!

Yes the order is irrelevant as the BenID can go through various combinations with the BenIDNew (these are Beneficiaries that are transacting).

Your solution is much more efficient...

serviceaellis (8/22/2015)

---

Glad you have what you are looking for. One question remains. How are you deciding which years appear in the parameter list? I ask because if the user selects...

serviceaellis (8/22/2015)

---

Thank you very much!

Data seems to be resulting the way it's expected on the reporting side with an edit in the Report | Select Expert on Record.

{v060ClubOfficersPresidentMbrCounts.YearEnd} in...