You don't need to remove the comma, you need to remove the column. This is done in the flat file source editor, assuming that you have an additional column that...

Use a separate table as those are different entities.

You should have an entity allowance with attributes type and amount. You might need to have dates to define time periods but...

Hi, welcome to the forums.

You posted almost 300 lines of code (after formatting) which is considered rude for a simple problem. You should identify where the error is and without...

Take a look at Cross tabs which will make the pivoting of multiple columns a lot easier and faster using Copy-Paste-Edit.

References in here:

Part 1[/url]

Part 2[/url]

Example

SELECT instanceid

...

Raghavendra Mudugal (2/13/2015)

---

Thank you for the post, very interesting one.

(so, 63 people thought that they can create a table with no cols; if this becomes real, I am not sure...

Use the Available Values tab to set the same values as the default.

It won't be disabled but the value can't be changed.

Another option is to define them as hidden and...

Disregard my previous post.

On the Default Values tab, set Specify Values and use the function button (fx).

For start of Month:

=DateAdd("M", DateDiff("M", CDate("1900-01-01"), Now()), CDate("1900-01-01"))

For end of Month:

=DateAdd("M", DateDiff("M", CDate("1900-01-01"), Now()),...

I'm not sure if it's the correct way to do it, but I used a new dataset for parameter values.

See next post.

It might be bad parameter sniffing. You can read about it on many articles.

For more information specific to your problem, check the following article: http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

I would change the join conditions.

SELECT people.id,

people.[First Name] AS EFirst,

people.[Last Name] AS ELast,

people_Identifiers.[Number/Code] AS ENumber,...

Remove TIME from GROUP BY.

Try not to use reserved keywords for names.

Please don't. Use a single table with an additional column to define the date of the data. Otherwise, you'll end with way too many tables for no reason.

djj (2/12/2015)

---

Ed Wagner (2/12/2015)

---

Sioban Krzywicki (2/12/2015)

---

Eirikur Eiriksson (2/12/2015)

---

Brandie Tarvin (2/12/2015)

---

jasona.work (2/12/2015)

---

Brandie Tarvin (2/12/2015)

---

jasona.work (2/12/2015)

---

Is it me, or is it at least once a week minimum someone posts a "How do...

Could you create a group/role to revoke access to the dbs before the maintenance tasks occur and grant the access again after all the night processes end?

Would that create problems?

Here's another option.

SELECT *

FROM #Machine m

JOIN #MachineBranch mb ON mb.MachineFk = m.MachinePk

WHERE m.MachinePk IN ( SELECT im.MachinePk

...