Skip to main content
added [query-performance] to 2412 questions - Shog9 (Id=1924)
Link
rephrased for clarity, incorporated an explanation from a comment
Source Link
Andriy M
  • 23.2k
  • 6
  • 59
  • 103

I have two columns with the names, units, and range as followsthat look like this:


Start_Post  End_Post
----------  --------
102+20.45   153+19.22 
120+21.25   220+25.30
...         ...

Column1: Start_post
Units: Ft
Min Range And I want to introduce a constraint to each column:

  • Start_Pos
    Min Range: 100+50.30
    Max Range: 150+20.65
  • End_Pos
    Min Range: 150+60.30
    Max Range: 500+20.75

All values are in feet and follow a special format. It's a construction convention and I am not an expert but to my knowledge, 1+00 would be 100 feet. Essentially, taking the above range of 100+50.30
Max Range: to 150+20.65

Column2: End_Post
Units: Ft
Min Range: 150+60 would mean a distance of 4970 ft.30
Max Range: 500+20 What I did was just remove the plus sign and subtract the two numbers.75 Hope that made sense.

Is there a way to define this constraint whilst maintaining the format?

I have two columns with the names, units, and range as follows:

Column1: Start_post
Units: Ft
Min Range: 100+50.30
Max Range: 150+20.65

Column2: End_Post
Units: Ft
Min Range: 150+60.30
Max Range: 500+20.75

Is there a way to define this constraint whilst maintaining the format?

I have two columns that look like this:


Start_Post  End_Post
----------  --------
102+20.45   153+19.22 
120+21.25   220+25.30
...         ...

And I want to introduce a constraint to each column:

  • Start_Pos
    Min Range: 100+50.30
    Max Range: 150+20.65
  • End_Pos
    Min Range: 150+60.30
    Max Range: 500+20.75

All values are in feet and follow a special format. It's a construction convention and I am not an expert but to my knowledge, 1+00 would be 100 feet. Essentially, taking the above range of 100+50.30 to 150+20.65 would mean a distance of 4970 ft. What I did was just remove the plus sign and subtract the two numbers. Hope that made sense.

Is there a way to define this constraint whilst maintaining the format?

Tweeted twitter.com/StackDBAs/status/825073649162022913
deleted 19 characters in body
Source Link
Hannah Vernon
  • 70.5k
  • 22
  • 177
  • 321

I have two columns with the names, units, and range as follows:
  

Column1: Start_post
Units: Ft
Min Range: 100+50.30
Max Range: 150+20.65
  

Column2: End_Post
Units: Ft
Min Range: 150+60.30
Max Range: 500+20.75

Is there a way to define this constraint whilst maintaining the format?
Appreciate your help!

I have two columns with the names, units, and range as follows:
 Column1: Start_post
Units: Ft
Min Range: 100+50.30
Max Range: 150+20.65
 Column2: End_Post
Units: Ft
Min Range: 150+60.30
Max Range: 500+20.75

Is there a way to define this constraint whilst maintaining the format?
Appreciate your help!

I have two columns with the names, units, and range as follows: 

Column1: Start_post
Units: Ft
Min Range: 100+50.30
Max Range: 150+20.65 

Column2: End_Post
Units: Ft
Min Range: 150+60.30
Max Range: 500+20.75

Is there a way to define this constraint whilst maintaining the format?

Source Link
SQLserving
  • 476
  • 3
  • 8
  • 21
Loading