ChrisM@Work (10/29/2015)

---

J Livingston SQL (10/29/2015)

---

Bruceo (10/29/2015)

---

By the way, how do you format your results like that? I looked through all the shortcuts and could not figure it out!

Is that an...

my shot at this...first glance suggests I get different results from anthony

but I have added and addtional row

create table #test (empid int, start_date datetime, end_date datetime)

insert into #test values

(1001,'1998-01-01','2003-06-21'),

(1001,'2004-01-01','2004-06-15'), ...

Bruceo (10/29/2015)

---

By the way, how do you format your results like that? I looked through all the shortcuts and could not figure it out!

Is that an image or just SQL...

Mark Harley (10/29/2015)

---

I have a table that contains an employee id and dates signifying time periods that those employees were working. I need to calculate anniversaries, such as 20...

Good spot, G. I've only tested the proposed solution on the sample data set provided by the OP. I think it would be trivial to tweak the query to account...

ChrisM@Work (10/29/2015)

---

Try this - the result of some fiddling around earlier:

-- Set up sample data

DECLARE @Deductions TABLE (DeductionID int IDENTITY(1,1),DeductionAmount money);

INSERT @Deductions (DeductionAmount) VALUES (1000),(200),(50),(600);

DECLARE @Payments TABLE (PaymentID int IDENTITY(1,1),PaymentAmount...

you are...

see this article and read the comments from Jeff at the bottom of the article

https://www.mssqltips.com/sqlservertip/3576/generate-random-strings-with-high-performance-with-a-sql-clr-function

celine.godines (10/28/2015)

---

It will be for multiple customers (I have about over 1000000)

All customers have different products and different Names/Values... (and not always 2 products and 6 names, it will varies)

I...

I trust that you understand how this works?

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

celine.godines (10/28/2015)

---

I have the following results:

CustomerProductName ValueChargesNewCharges

13AZ 40005056

13BY 30023

13BX 50003536

13BW 16001312

13BV 107009392

13BU 7000109110

And would like to...

SQLPain (10/27/2015)

---

there are some records in exported column those are NOT Null and it is also a DATETIME data type. If you look at the attached excel Loan '123123' is...

a suggestion...as you appear to be using Getdate() as a filter. then please provide...

maybe something along these lines will work for you.

have only looked at Vacation

WITH ctesecs as

(

SELECT

A.FirstName

, A.LastName

, SUM(CASE

WHEN DailyStartDate IS NULL THEN HourlyVacationEndTime...

sorry...but...