Viewing 15 posts - 826 through 840 (of 3,666 total)
I'm pretty sure I saw one version that did not return the SPID that was executing SP_WHO3.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 20, 2015 at 8:07 am
jbalbo (3/19/2015)
I got en error because one record had parenthesis in...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 19, 2015 at 1:50 pm
I'm not sure that I understand why you're doing this, but you could make a copy of the project folder. Run one instance from the original folder and another...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 19, 2015 at 12:56 pm
jbalbo (3/19/2015)
HiI have a field which looks like "LastName, FirstName (DOB: 01/01/1900)"
How do I get the "01/01/1900" between ":" and ")"
Thanks in Advance
Joe
I'd try something like:
DECLARE @TestString...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 19, 2015 at 12:30 pm
Why are you inserting the same values in each table twice? This might be causing the unexpected results?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 19, 2015 at 9:14 am
There's several System views you can query to get that type of information, for example:
INFORMATION_SCHEMA.TABLES
INFORMATION_SCHEMA.COLUMNS
sys.tables
sys.columns
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 19, 2015 at 8:50 am
Jim, when you said the processes were doing incremental loads, did you mean that they were only loading new records and may have ignored old modified records?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 19, 2015 at 7:44 am
Yes you can take one file and in one data flow, insert any column(s) you want to one or more tables.
You could also do this in multiple data flows if...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 19, 2015 at 7:35 am
If you want "column level security" for data coming out of SSAS, then you have to apply the security in SSAS.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 18, 2015 at 2:27 pm
Someone is asking the question: "One of the database that I monitoring is showing the .mdf file full. Recovery model of that database is simple. How can I add more...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 18, 2015 at 8:30 am
If I read your query correctly, you have IF statements to cover the 4 regions specified individually, but nothing else.
If the value used is not 1 of the 4 values...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 18, 2015 at 8:26 am
below86 (3/12/2015)
Koen Verbeeck (3/12/2015)
below86 (3/12/2015)
I'm not a fan of SSIS 2012 for sure, 2008 is OK.🙁
What's worse in 2012 than in 2008?
One huge problem I see so far is...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 12, 2015 at 8:18 am
Be very careful about putting the "when" and "not when" conditions in a where clause. This could cause unexpected results if both conditions exists in the same string.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 11, 2015 at 10:25 am
Hany Helmy (3/11/2015)
I am using this one a lot, thanx for the question.
+ 1
I create a process to rebuild or reorganize indexes that are too fragmented. The process...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 11, 2015 at 7:56 am
lawsonoliver1 (3/6/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 10, 2015 at 11:10 am
Viewing 15 posts - 826 through 840 (of 3,666 total)