Viewing 15 posts - 871 through 885 (of 3,666 total)
kabaari (1/19/2015)
I have the query below and it returns zero but if I remove the first part of the WHERE clause, it works using the second half parameters....
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]
January 19, 2015 at 1:34 pm
Koen Verbeeck (1/19/2015)
However, looking at the first parts already...
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]
January 19, 2015 at 1:31 pm
imex (1/15/2015)
Try:
Select dateadd(day, datediff(day, 0, datefield), 0) as datefieldfrom datetable
Hope this helps.
This is a waste of CPU cycles.
Stick with Phil Parkins suggestion. Stick to the KISS principle...
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]
January 15, 2015 at 10:06 am
Koen Verbeeck (1/13/2015)
FYI, I received the Author of the Year award at MSSQLTips.com!Thanks everyone for voting!
Congratulations!!!
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]
January 13, 2015 at 2:18 pm
Lynn Pettis (1/12/2015)
Alvin Ramard (1/12/2015)
Lynn Pettis (1/12/2015)
Steve Jones - SSC Editor (1/12/2015)
Test drove a few cars over the weekend. After...
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]
January 12, 2015 at 4:18 pm
Lynn Pettis (1/12/2015)
Steve Jones - SSC Editor (1/12/2015)
Test drove a few cars over the weekend. After selling the 911, I'm...
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]
January 12, 2015 at 4:12 pm
The only thing I can imagine is, since I had the connection open for a while, maybe SQL or SSMS was showing me the wrong spid..
This would make sense.
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]
January 9, 2015 at 2:06 pm
One way to approach this is to assign the file name to a variable as the first step inside the ForEach loop.
In your data flow, you can use...
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]
January 9, 2015 at 1:52 pm
Are you sure that spid was still active?
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]
January 9, 2015 at 1:22 pm
I strongly believe in the KISS principle. Keep It SQL Server 🙂
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]
January 8, 2015 at 2:41 pm
I had to check if the original post was from Apr 1st.
Nope. :w00t:
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]
January 7, 2015 at 3:36 pm
GilaMonster (1/6/2015)
Alvin Ramard (1/6/2015)
RamSteve (1/6/2015)
HI ,...
So should i need to take any other precautions or concerns with this approach.?
...
Yes, update your resume every 2 weeks!
Hahahahahaha :hehe: 😀
Differential update should...
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]
January 6, 2015 at 1:14 pm
RamSteve (1/6/2015)
HI ,...
So should i need to take any other precautions or concerns with this approach.?
...
Yes, update your resume every 2 weeks!
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]
January 6, 2015 at 1:06 pm
What error does the job report when it runs?
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]
January 6, 2015 at 11:50 am
Recruiters are like every other type of people. There's good ones and bad ones.
Keep shopping until you find someone that's ready to work with what you want instead of...
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]
December 18, 2014 at 10:57 am
Viewing 15 posts - 871 through 885 (of 3,666 total)