Crystal Reports report files have the .RPT file extension, and the data is not readily consumable, so I know of no possible way to programmatically get such...

OLSONEJ (7/1/2015)

---

The solution presented works to a point. An additional point of criteria, that I was only informed of this morning, is that we only want to count as...

karthik82.vk (7/1/2015)

---

I have a client data which has the candidate id, a start date which will have only the date in varchar format and a time value associated to that...

Finally got...

Was in progress using that site when 5pm showed up. Will look further at this later tonight...

a4apple (6/30/2015)

---

@steve-2, your query failed with an error message LAG doesn't have an OVER clause. So I added that with partition between AccountID.

Next, It actually prints the flag for the...

a4apple (6/30/2015)

---

Luis Cazares (6/30/2015)

---

I was exactly going to suggest the @Points table because I had to use a triangular join which might cause problems.

Using your new Points table, here's a...

You're welcome. Glad I could help.

OLSONEJ (6/30/2015)

---

My apologies, I was not aware of the business rules previously as it had to be decided upon since we are rebuilding something that previously existed. Same reason...

dandenise316 (6/29/2015)

---

DROP TABLE mytable;

CREATE TABLE mytable(

primary_attribute_value VARCHAR(33) NOT NULL PRIMARY KEY

, date VARCHAR(27) NOT NULL

, emails INTEGER(3) NOT NULL

, emails_delivered INTEGER(3) NOT NULL

, delivery_rate NUMERIC(6,4) NOT NULL

, opens...

Your query from the ZIP file has a number of DECLARE statements where you do the equivalent of:

DECLARE @somevariable dbo.sometablename

That will never...

mikes84 (6/30/2015)

---

Hey guys,

Thanks so much for the suggestions! I found the exact query that produces different results each time I execute it. I'm still not exactly sure why, but there...

Jeffery Williams (6/29/2015)

---

Quotes did not work. Bouncing the service did not work. Bouncing the server did not work.

I am on the 4th floor... I wonder if a bounce out the...

coachmkavanaugh (6/29/2015)

---

Hello,

I work in the world of swimming and use a SQL Server Database to help me work on reporting. I have the following query below.

select b.last_Name

, b.first_name

,FLOOR(DATEDIFF(day, b.birthdate,...

And without a posted query...