326 reputation
29
bio website
location
age
visits member for 1 year, 7 months
seen Aug 22 at 9:19

Jul
23
comment SQL Server - constraint to prevent overlapping dates
Thanks Paul, I will reword with an example on what the differences are.
Jul
23
revised SQL Server - constraint to prevent overlapping dates
added 251 characters in body
Jul
23
comment SQL Server - constraint to prevent overlapping dates
As I mentioned, if you take the effort (which you wont now that were having this discussion), you'll see that the link provided is not related to this question at all.
Jul
23
comment SQL Server - constraint to prevent overlapping dates
This is already on the first page of google when you search for "sql prevent overlapping dates". I think has a higher likelihood to be found than the other links.
Jul
23
comment SQL Server - constraint to prevent overlapping dates
This is not a duplicate question at all. The examples shown are not remotely the same as the OP. E.g. in the Z_Store_Team database as in the link provided, you simply cannot look across ranges, and even if you enter a correct value , it gives errors INSERT [Z_STORE_TEAM] ([STORENUM], [TEAM], [EFFECTIVE], [FINISHED]) VALUES (2, N'1', '20140202', '20140331');
Jul
22
asked SQL Server - constraint to prevent overlapping dates
Jul
11
awarded  Notable Question
Jul
4
comment Coalesce per row - get all Detail IDs grouped per HeaderRow e.g. Invoice1 | 1,2,3 Invoice 2 | 4,5,6
brilliant, thank you so much
Jul
4
accepted Coalesce per row - get all Detail IDs grouped per HeaderRow e.g. Invoice1 | 1,2,3 Invoice 2 | 4,5,6
Jul
4
revised Coalesce per row - get all Detail IDs grouped per HeaderRow e.g. Invoice1 | 1,2,3 Invoice 2 | 4,5,6
added 136 characters in body
Jul
4
revised Coalesce per row - get all Detail IDs grouped per HeaderRow e.g. Invoice1 | 1,2,3 Invoice 2 | 4,5,6
added 133 characters in body
Jul
4
asked Coalesce per row - get all Detail IDs grouped per HeaderRow e.g. Invoice1 | 1,2,3 Invoice 2 | 4,5,6
Jul
4
asked Matching 3 columns in row - if one column is null then exclude it from comparison
Jul
2
awarded  Curious
Jun
20
comment Unsure of Rank / Dense_Rank - Mulitple Columns - change rank when unique combination changes
Perfect! Thank you!
Jun
20
comment Unsure of Rank / Dense_Rank - Mulitple Columns - change rank when unique combination changes
perfect thanks, all the examples had something in the Partition By section which I should have left out.
Jun
20
asked Unsure of Rank / Dense_Rank - Mulitple Columns - change rank when unique combination changes
Mar
31
asked Inside stored procedure, set column names of returned query according to variable
Mar
10
comment .bak file not visible in any directory
it did help! :)
Feb
24
awarded  Critic