J Brune

Baltimore, MD

May
14
answered SSIS 2008 - File Delete not working, but File Move does
May
14
awarded Nice Answer
Mar
19
asked SSIS 2008 - File Delete not working, but File Move does
Jan
26
awarded Popular Question
Nov
17
asked SSIS 2008 - Script Component - Microsoft.SqlServer.Dts.Pipeline.Wrapper - doesn't contain any public member or cannot be found
Nov
10
awarded Necromancer
Sep
26
accepted MySQL - Adding CHECK to a Column
Sep
26
awarded Commentator
Sep
26
comment MySQL - Adding CHECK to a Column
Thank you so much. I'm finding MySQL to be... interesting this way.
Sep
26
asked MySQL - Adding CHECK to a Column
Sep
25
comment Not able to create foreign key "There are no primary or candidate keys in the referenced table"
Right, in PurchaseDate you reference a PK (Purchase_Order_No), but you don't have a PK (Purchase_Order_No), you have a PK (Purchase_Order_No, Purchase_Product_ID)
Sep
25
accepted Datetime in MySQL
Sep
25
comment Datetime in MySQL
Thanks all. I also find I can say SELECT * FROM temp WHERE Col1 < 'potato' and it doesn't throw any error. Learning curve for me to say the least.
Sep
25
comment Datetime in MySQL
No friggin way. It HAS to be yyyy-mm-dd in MySQL?
Sep
25
asked Datetime in MySQL
Apr
25
comment How can I restrict a column to certain values from another table without using a foreign key?
I love how it's #1 on the article. I tried to have separate lookup tables and was overruled. I might try again, or I'll have to drop the 2nd column, and just make the 1st column the primary key and use that, which I was kind of trying to avoid. Thank you all for your prompt and well thought out responses.
Apr
25
asked How can I restrict a column to certain values from another table without using a foreign key?
Jan
21
awarded Teacher
Dec
12
answered How to update TFS workspace after computer name changes?
Jul
8
awarded Notable Question
1 2