Viewing 15 posts - 346 through 360 (of 1,241 total)
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
MMartin1 (12/16/2016)
Given a large table;a more potentially SARGable approach, and readable from my perspective is
Declare @customers table (country varchar(2))
Insert into @customers(country)
values('UK'),('US'),('FR'),(NULL)
Select*
from@customers
Except
Select*
from@customers
wherecountry in ('US','UK')
;
I should...
December 16, 2016 at 2:32 pm
Given a large table;
a more potentially SARGable approach, and readable from my perspective is
Declare @customers table (country varchar(2))
Insert into @customers(country)
values('UK'),('US'),('FR'),(NULL)
Select*
from@customers
Except
Select*
from@customers
wherecountry in ('US','UK')
;
December 16, 2016 at 2:26 pm
Lynn Pettis (12/12/2016)
To repeat (emphasis mine):Jeff Moden (12/11/2016)
...From the movie, "War Games"...
"A strange game. The only winning move is not to play."
Have to emphasise the quote myself :-P...
December 15, 2016 at 12:47 pm
Viewing 15 posts - 346 through 360 (of 1,241 total)