Viewing 15 posts - 451 through 465 (of 1,241 total)
If you are developing code then you are advised to use a source control system. Aside from not having the copy of the release code reside on your machine or...
October 20, 2016 at 6:25 pm
As I see things like target price, target something ; plus sales markup and the like I think about the deal dimension and the promotion dimension that Kimball outlines...
October 20, 2016 at 5:57 pm
I just think SQL Server has lots better maintainability, speed optimization potential and is easy to build functions, calculated fields etc.. The fact that it has the ability to...
October 14, 2016 at 4:32 pm
Please provide sample DDL, sample data, with INSERT statements corresponding with the sample data and desired results, so that we can properly understand what you are trying to do and...
October 13, 2016 at 6:20 pm
I know there is a deployment utility within VS, though I've not used it much at all. Right click the name of the project in solution explorer > properties >...
October 13, 2016 at 6:07 pm
Luis Cazares (10/12/2016)
I really hope the OP didn't depend on the last replies. Not because they're bad, but because it's been over 3 years now.
I also hope the OP migrated...
October 13, 2016 at 5:45 pm
A good illustration for anyone learning the basics of Xquery.
October 13, 2016 at 11:25 am
The issue I see is that you can have one product out of many that only uses source D for example, while the rest are varied among the...
October 11, 2016 at 11:57 am
What is supposed to be doing the insert? A person? An application?
One idea is to have a trigger on the table that takes the inserted ID value and adds them...
October 10, 2016 at 11:36 am
We need DDL statements for your tables, inserts, and the queries with any parameters you are using in your report to pull your datasets.
Please start from the top. Just...
October 10, 2016 at 11:22 am
kevin.obrien 66193 (10/9/2016)
How do I allow for an item in SourceA to be matched to an item in SourceB?
So in my report output, if the user has indicated these 2...
October 10, 2016 at 11:11 am
MickyD (9/15/2016)
I recently came across a dev database in our organization that had no clustered indexes and circa 100 million row.....:crazy:
In order to rectify I need some advice on...
October 7, 2016 at 2:36 pm
hoseam (10/5/2016)
I have Test.rdll, with one parameter and one dataset
Dataset:
Name:Country
Query:
select distinct
[Country]
from [DW].[dbo].[Dim_Country]
where Active = 1
and Country = @Country
Parameter:
General; Name= Country, Prompt = Country, Data...
October 7, 2016 at 1:18 pm
GilaMonster (10/4/2016)
CferMN (10/4/2016)
Could you please explain how to tell what the table is most frequently filtered by or how to tell the most common predicate used against the table?
You go...
October 7, 2016 at 11:44 am
marc.corbeel (10/6/2016)
Problem is here that my real query is very complex (about 40 lines), and putting it 2 times...
October 7, 2016 at 11:07 am
Viewing 15 posts - 451 through 465 (of 1,241 total)