Viewing 15 posts - 406 through 420 (of 1,246 total)
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
I'm sure you already know this but its worth mentioning. In your source control dont forget to create a tag for your releases so that you know what version of...
----------------------------------------------------
November 11, 2016 at 10:50 am
Now we have 2000+ SSRS reports for many clients and we scheduled those reports as subscriptions in those report servers.
This would have given me the indication right away that there...
----------------------------------------------------
November 11, 2016 at 10:36 am
Viewing 15 posts - 406 through 420 (of 1,246 total)