Viewing 15 posts - 166 through 180 (of 1,183 total)
Someone else will have to speak the the specifics of "WHY", but I believe it has something to do with the parser having to evaluate both conditions of the IF.
This...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 13, 2012 at 6:59 am
Use the LEFT command keyword.
...
SET shortColumn = LEFT(longColumn,500)
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 12, 2012 at 7:38 am
Johan's post should get you pretty much what you are asking for.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 11, 2012 at 7:07 pm
SQLKnowItAll (1/11/2012)
Jason Selburg (1/11/2012)
Otherwise, this gets what...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 11, 2012 at 12:33 pm
In order to dynamically name the columns, you would need to use dynamic sql. Search BOL or this site for more details on that.
Otherwise, this gets what you want. ...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 11, 2012 at 12:23 pm
But more clearly stated here. 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 10, 2012 at 8:59 pm
So why don't you "want" to count the seperators? That would be the most direct way to count the codes.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 10, 2012 at 2:46 pm
Matthew Orton (1/10/2012)
Yes I could create a database from one of the projects and use that as the source to compare against the remaining project using...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 10, 2012 at 2:34 pm
What's the question?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 10, 2012 at 11:06 am
Gotcha
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 10, 2012 at 9:43 am
I may be way off here, but why not just right click the table in Object Explorer and Script as Insert then manipulate that?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 10, 2012 at 9:36 am
This may not be the optimal solution, but .....
Apply the project to two seperate database's then use Red Gate's SQL Compare on them.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 10, 2012 at 9:13 am
Dev (1/10/2012)
Divide it by 1000.
I was gonna say that, but it couldn't be that obvious. 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 10, 2012 at 8:53 am
Thanks for all of the compliments everyone.
I ran into this scenario and as it seemed contradictory to common sense to me, I figured I'd see if I was the...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 19, 2011 at 5:41 pm
A few notes:
This assumes the [Fail] value is what you want pivoted.
That the value is not to be summed, averaged per [Date] [Region] group.
That their is only one value for...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 16, 2011 at 6:42 am
Viewing 15 posts - 166 through 180 (of 1,183 total)