Viewing 15 posts - 331 through 345 (of 1,229 total)
SELECT
tbl1.Date,
tbl1.ID,
tbl1.Order_Amount,
tbl2.StoreNum,
COUNT(tbl1.id) over(partition by tbl1.id) as count
FROM tbl1 right join tbl2
ON tbl1.ID = tbl2.ID
I always cringe a bit when I see those right joins.
Let us...
January 9, 2017 at 4:51 pm
wendy elizabeth (1/8/2017)
January 9, 2017 at 4:36 pm
wendy elizabeth (1/8/2017)
January 9, 2017 at 4:31 pm
Newbi (1/9/2017)
Thank you. How about date time datatype? What are we supposed to give the as datatype when adding empty rows?
See if the following example helps
create table #t2(mydate datetime)
insert into...
January 9, 2017 at 4:20 pm
Thom A (1/8/2017)
1. Log what you have processed thus far, then, when...
January 9, 2017 at 4:09 pm
Yes, not difficult that I re-read a couple times to make sure I was not missing anything. Though the wording could be better "I want to return the nickname if...
January 9, 2017 at 3:55 pm
pankaj.chakole (1/9/2017)
DDM fuctions are not masking or modifying the orginal data so i dont think so it will allow you to retrive data by putting blah in where clause
Not sure...
January 9, 2017 at 12:45 pm
SSIS has a "checkpoint" feature that allows you to begin at a particular task if that task failed. That does not help with a actual failure rows within a data...
January 5, 2017 at 2:31 pm
A step forward indeed to simplify operations in a business that protects personal data.
Another great feature to have would be the ability to generate fake records by substituting column...
January 5, 2017 at 2:21 pm
Right click the solution name at the top of your solution explorer tab. Select properties and under the general configurations node there is on the right window pane a section...
January 3, 2017 at 12:48 pm
BOR15K (12/30/2016)
Chris Harshman (12/30/2016)
BOR15K (12/30/2016)
January 3, 2017 at 12:32 pm
Wouldn't you just join on brokerKey (fact table)= brokerAccountKey (mapping table)? Try keeping the columns names consistent on multiple tables when representing the same column.
January 3, 2017 at 11:12 am
kevin.obrien 66193 (12/19/2016)
MMartin1 (12/14/2016)
a) Creating a surrogate key should be a normal routine
b) If there is no business ID (primary key usually) in your source data , try...
December 19, 2016 at 11:53 am
One other idea I can suggest is to have the SSRS reports call a stored procedure instead of pasting all of the sql query in the query window. That can...
December 19, 2016 at 11:22 am
subramaniam.chandrasekar (12/16/2016)
hi ,Any Ideas please ?
Can anyone help ?
You have been presented with ideas. What have you you tried so far ?
December 16, 2016 at 5:06 pm
Viewing 15 posts - 331 through 345 (of 1,229 total)