357 reputation
211
bio website
location
age
visits member for 1 year, 10 months
seen Nov 6 at 12:30

Nov
5
awarded  Popular Question
Sep
28
awarded  Popular Question
Sep
18
accepted SQL Server 2008 R2 - remove line below heading (which has ----,----) - dont have SSIS
Sep
17
comment SQLCMD - add date to CSV. When run inside Command Prompt it works, when in Job then %date
You just saved me from having to enable xp_cmdShell. Thank you so much!
Sep
17
accepted SQLCMD - add date to CSV. When run inside Command Prompt it works, when in Job then %date
Sep
16
asked SQLCMD - add date to CSV. When run inside Command Prompt it works, when in Job then %date
Sep
15
asked SQL Server 2008 R2 - remove line below heading (which has ----,----) - dont have SSIS
Sep
5
accepted Operand type clash: my first User Defined Type with list of Integers, how to test via SSMS
Sep
5
comment Operand type clash: my first User Defined Type with list of Integers, how to test via SSMS
I still dont understand the jist of this please. I can create a table, insert the values, but how to execute please, this still gives error .declare ATlist as table(l nvarchar(max)) insert Into ATlist(l)values('1,2,3,4,5') exec sp_UseStringList ATlist
Sep
5
asked Operand type clash: my first User Defined Type with list of Integers, how to test via SSMS
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