Viewing 15 posts - 391 through 405 (of 1,233 total)
Interesting that SMALLINT will implicitly convert to INT , but INT wont implicitly convert to BIGINT. Is this the case also with a .NET language like C#?
November 18, 2016 at 4:21 pm
Eric M Russell (11/17/2016)
In terms of the Kimball methodology of star-schema modeling, I believe this would be an example of a "role playing dimension".
From what I understand I dont think...
November 17, 2016 at 1:42 pm
Jeff Moden (11/16/2016)
IMHO, cleaner code if you take the shortcut.
SELECT mychar FROM mydata WHERE mychar LIKE '[[]%'
That's how I went about doing it and then had to take a closer...
November 17, 2016 at 12:00 pm
kevin.obrien 66193 (11/16/2016)
The question to the OP is ... are CounterpartyAccountKey and GenevaAccountKey mutualy exclusive? It appears to me from the reading that they may very well be (normally a...
November 17, 2016 at 11:42 am
Jeff Moden (11/16/2016)
tnnelzo (6/20/2013)
Everyday i run a querry in sqlserver 2008 to get a report to sent to my boss, but i want to automate this, so that the...
November 17, 2016 at 11:27 am
Luis Cazares (11/15/2016)
I wonder why an SSRS subscription wasn't considered. Too late for that, I suppose.
This would be the approach I would take. It is simple to set up Subscriptions...
November 16, 2016 at 10:23 am
chocthree (11/14/2016)
I have installed the 2016 version of the SQL Server software (as stated in previous posts). I am having trouble finding training videos...
November 16, 2016 at 10:15 am
Good QotD. Someone not knowing this could introduce a serious bug into their work.
November 16, 2016 at 9:56 am
glebih (10/17/2016)
IE
UPDATE table
SET Col1 = Val1
OUTPUT inserted.Col1 (should be Val1),...
November 15, 2016 at 5:27 pm
>> I have to check if this exists in table, if it does not exist only then insert. <<
No, another alternative is to try to insert a row and see...
November 15, 2016 at 12:26 pm
Just to note, for the answer that you marked as correct ... the second instance where col1=2 has col5 = 'ewqq' and not 'kjhg' as you specified. Eirikur's solution however...
November 15, 2016 at 11:47 am
bheema.ece12 (11/14/2016)
Hi Martin,The file is stored on my machine and both DB and SSIS packages are running in my local machine itself.
You'll have to provide some more information like the...
November 15, 2016 at 11:00 am
Building on Lynn's good example here:: I added a couple of audit fields that you may readily see , 'created on' and 'updated on' dates. It is not difficult...
November 14, 2016 at 4:32 pm
I believe in the one source of truth, as the ideal. From many sources one place to store. It also keeps enforcement on data standards easy since you are working...
November 14, 2016 at 12:17 pm
bheema.ece12 (11/13/2016)
Error: [SSIS.Pipeline] Error: Read From CSV failed the pre-execute phase and returned error code...
November 14, 2016 at 12:01 pm
Viewing 15 posts - 391 through 405 (of 1,233 total)