Viewing 15 posts - 271 through 285 (of 1,183 total)
Jason Selburg (7/19/2011)
Ninja's_RGR'us (7/19/2011)
Jeff Moden (7/19/2011)
Ninja's_RGR'us (7/19/2011)
USA :exclamationmark:Better look at a map. 🙂
I just googled it.
Detroit, Michigan, USA.
I rest my case. You can always trust what Google says...
______________________________________________________________________
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. SelburgJuly 19, 2011 at 11:25 am
Ninja's_RGR'us (7/19/2011)
Jeff Moden (7/19/2011)
Ninja's_RGR'us (7/19/2011)
USA :exclamationmark:Better look at a map. 🙂
I just googled it.
Detroit, Michigan, USA.
I rest my case. You can always trust what Google says 😀 :-P.
Who...
______________________________________________________________________
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. SelburgJuly 19, 2011 at 11:23 am
Ninja's_RGR'us (5/11/2011)
Why am I tempted to answer : Me, without any doubt :w00t:.
Steve needs to impliment a "LIKE" button for SSC.
______________________________________________________________________
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. SelburgJuly 19, 2011 at 11:10 am
Ok here goes.....
DISCLAIMER: This only addresses one of MANY possible patterns.
declare @numbers table (nDex int)
insert @numbers (nDex)
values
(1),(2),(3),(4),(5),(6),(7),(8),(9),(-1),(-2),(-3),(-4),(-5),(-6),(-7),(-8),(-9)
-- just as Steve pointed out, there must be something that defines 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. SelburgJuly 19, 2011 at 10:51 am
bopeavy (7/19/2011)
______________________________________________________________________
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. SelburgJuly 19, 2011 at 10:27 am
Not sure the specifics of where you're encountering issues.
But in general, you would create a procedure that returns the values you want in your drop down list and use 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. SelburgJuly 19, 2011 at 10:23 am
bopeavy (7/19/2011)
______________________________________________________________________
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. SelburgJuly 19, 2011 at 10:20 am
I agree, before providing a solution the "Pattern" requirement will need clearly defined. 😀
______________________________________________________________________
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. SelburgJuly 19, 2011 at 10:04 am
______________________________________________________________________
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. SelburgJuly 19, 2011 at 9:16 am
Dynamic SQL 🙂
______________________________________________________________________
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. SelburgJuly 19, 2011 at 9:06 am
Define "Invalid"
______________________________________________________________________
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. SelburgJuly 12, 2011 at 9:04 am
Have you tried?
ISDATE(yourColumn) = 1
______________________________________________________________________
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. SelburgJuly 11, 2011 at 12:24 pm
1. Reverse the ORDER BY in the ROW_NUMBER()
2. Reverse the WHERE to be < 3
3. As a general rule, use table variables or temp tables in your questions/answers. Nobody wants...
______________________________________________________________________
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. SelburgJune 30, 2011 at 9:52 am
And yet another option is to get the eval version http://msdn.microsoft.com/en-us/sqlserver/bb895906.
It's valid for 6 months.
______________________________________________________________________
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. SelburgJune 27, 2011 at 6:22 pm
I just ask Jeff. 😀
______________________________________________________________________
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. SelburgJune 27, 2011 at 1:21 pm
Viewing 15 posts - 271 through 285 (of 1,183 total)