Viewing 15 posts - 5,221 through 5,235 (of 8,731 total)
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...
February 13, 2015 at 4:10 pm
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...
February 13, 2015 at 3:50 pm
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...
February 13, 2015 at 12:46 pm
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:
Example
SELECT instanceid
...
February 13, 2015 at 10:53 am
Raghavendra Mudugal (2/13/2015)
(so, 63 people thought that they can create a table with no cols; if this becomes real, I am not sure...
February 13, 2015 at 8:37 am
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...
February 13, 2015 at 7:17 am
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()),...
February 12, 2015 at 2:52 pm
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.
February 12, 2015 at 2:35 pm
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/
February 12, 2015 at 2:20 pm
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,...
February 12, 2015 at 2:16 pm
Remove TIME from GROUP BY.
Try not to use reserved keywords for names.
February 12, 2015 at 1:20 pm
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.
February 12, 2015 at 12:13 pm
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)
February 12, 2015 at 12:09 pm
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?
February 12, 2015 at 11:29 am
Here's another option.
SELECT *
FROM #Machine m
JOIN #MachineBranch mb ON mb.MachineFk = m.MachinePk
WHERE m.MachinePk IN ( SELECT im.MachinePk
...
February 12, 2015 at 10:26 am
Viewing 15 posts - 5,221 through 5,235 (of 8,731 total)