bgolembiesky 4883 (7/24/2015)

---

Unfortunately, it does not. That's what I tried initially. It seems like a simple request. All I want is the employee, check date and amount from ps_al_chk_ded where...

You're welcome. It's always good to see how the query you provide gets used, and even better when you get a good idea on why the original poster...

bgolembiesky 4883 (7/24/2015)

---

I've having difficulty joining two tables and getting the results I want. What I'm trying to accomplish is an Health Savings Account (HSA) upload file to go to...

yayan.m (7/24/2015)

---

select

period, kode_lang, namaprod, kode_comp, kode_type,

kodesalur, company,

...

Now that...

Scott,

Your sample data broke my code, and I soon realized I had a bigger problem to solve, especially when I read greggg's last post.

Here's the new code:

DECLARE @tblCustomers TABLE (CustomerID...

Xedni (7/24/2015)

---

So the way I'm using them is in procedures which are part of an API which allows people to put in configuration rows which eventually get put into pres...

Xedni (7/24/2015)

---

Hey all,

Is there a good way to add columns to a table type?

I built several procs which make use of table-valued-parameters, and they work pretty nicely, until I...

yayan.m (7/24/2015)

---

Have you tried running your query from your LEFT JOIN separately with a WHERE clause that just gets data for 201312 ?

That might help determine if it's a query...

KGJ-Dev (7/24/2015)

---

Hi, please find the below sample data and expected result

Declare @table table(Name varchar(200),Zipcode varchar(10),State varchar(10),City varchar(50))

Declare @ExpectedOutput table(Zipcode varchar(10),State varchar(10),City varchar(50),Name varchar(max))

insert into @table(Zipcode,Name,State,City)

select 1000 as zip,...

greggg (7/24/2015)

---

Thanks for the responses. The ultimate goal is an annual report that contains an accurate count on the number of machines that were serviced during the year, grouped by...

SSRS Newbie (7/24/2015)

---

sgmunson & J Livingston SQL - I appreciate your response. I modified the DDL and included the BATCH NUMBER per the business rule. Here is the business rule:

1)...

As Gail requested that you expand your sample data, she did so because we don't know exactly what you mean by the word unique. In this scenario, it could...

yayan.m (7/24/2015)

---

Assume I have a query like this

select

a.period, a.kode_lang, a.namaprod,

a.kode_comp, a.kode_type, a.kodesalur, a.company,

sum(a.sales) as...

SSRS Newbie (7/23/2015)

---

sgmunson,

Thank you for your response. The code you suggested works. I need to assign a Scheduled Ship Date to the closest Monday. For example- if the Requested Delivery...