Viewing 15 posts - 736 through 750 (of 3,666 total)
ChrisM@home (6/3/2015)
GilaMonster (6/3/2015)
What, other than the NOLOCK hints, is the problem?
The OP is confused by the location of the ON clauses. Since there are only INNER joins, I don't think...
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]
June 3, 2015 at 2:58 pm
You should step thru the script and see what the value of filename when you try to assign it to the SSIS variable. Look like the error message it's...
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]
June 3, 2015 at 2:50 pm
Can you connect to other instances? If so, it's not likely to be a SSMS issue.
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]
June 3, 2015 at 2:18 pm
Lowell (6/3/2015)
if he is a local admin on the PC in question, he can run the script and take over the SQL instance(s).
if he had 3...
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]
June 3, 2015 at 2:08 pm
Can't you use a WHERE clause for the UPDATE to only update the rows that need updating, without going the EXCEPT route?
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]
June 3, 2015 at 2:03 pm
If I remember expressions correctly, try using IIF to check if the denominator is zero. If it is, return NA, else return the division.
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]
June 3, 2015 at 1:46 pm
Lowell (6/3/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]
June 3, 2015 at 1:42 pm
jshahan (6/3/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]
June 3, 2015 at 12:42 pm
Eirikur Eiriksson (6/3/2015)
Luis Cazares (6/3/2015)
Eirikur Eiriksson (6/3/2015)
SQLRNNR (6/3/2015)
Ed Wagner (6/3/2015)
SQLRNNR (6/3/2015)
Brandie Tarvin (6/3/2015)
I am going to report ya'll to the USDA for pork chop abuse.I just thought you should know.
Actually,...
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]
June 3, 2015 at 12:15 pm
yusufm 48726 (6/3/2015)
I have compiled a report where in SQL query I have used Order By DateEntered, Value DESC but somehow when I check all the lines it does not...
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]
June 3, 2015 at 9:09 am
GilaMonster (6/3/2015)
Um...http://www.sqlservercentral.com/Forums/Topic1691210-2799-1.aspx
Crystal ball to aisle 5 please. (or maybe we need something a tad stronger)
Something much stronger is needed here.
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]
June 3, 2015 at 8:42 am
GilaMonster (6/3/2015)
Alvin Ramard (6/3/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]
June 3, 2015 at 8:38 am
oops
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]
June 3, 2015 at 8:33 am
patelxx (6/3/2015)
declare @EndTime nvarchar(10)= '12:45'
declare @Diff time(1) = cast(@EndTime as datetime) - cast(@StartTime as datetime)
How to I use Column names instead of Hard coding variables - e.g....
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]
June 3, 2015 at 8:28 am
GilaMonster (6/3/2015)
Read the question? What heresy is this, Alvin???
Sorry, in a dream world I was. :hehe:
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]
June 3, 2015 at 8:17 am
Viewing 15 posts - 736 through 750 (of 3,666 total)