| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 1 month |
| seen | May 19 at 17:53 | |
| stats | profile views | 29 |
|
Dec 3 |
answered | Identify why a user can drop a database |
|
Nov 28 |
comment |
Adding specific information to a local file Do you mean "store information about this specific file"? Or are you talking about writing data to the file itself? |
|
Nov 27 |
answered | Update field with new string made from characters in existing value |
|
Nov 26 |
comment |
JOIN 2 tables, and query data from them 3 times It doesn't seem like you need to store both the make and model of a vehicle for a post, since the model sort of indicates already what the make is, doesn't it? I mean, if 'model' is 'Silverado', then make is only ever going to be 'Chevy", no? Never Ford or Toyota. But that's a different discussion. |
|
Nov 26 |
answered | JOIN 2 tables, and query data from them 3 times |
|
Nov 23 |
revised |
Not able to create a new table new_table from t1 by comparing primary key values of another table t2 in MYSQL added 191 characters in body |
|
Nov 23 |
answered | Not able to create a new table new_table from t1 by comparing primary key values of another table t2 in MYSQL |
|
Oct 22 |
accepted | Full-text search in SQL Server on multiple tables fails |
|
Oct 22 |
comment |
Full-text search in SQL Server on multiple tables fails Well isn't my face red. That was the entire problem. Back to normal results. Thanks very much! |
|
Oct 22 |
revised |
Full-text search in SQL Server on multiple tables fails corrected the altered stored procedure to show the changes I had actually made to it. |
|
Oct 22 |
comment |
Full-text search in SQL Server on multiple tables fails Hello, thanks for your response. I apologize for the error, but I pasted the wrong code snippet in the altered stored procedure. I had in fact changed it to use the new view. I have edited my original post. |
|
Oct 22 |
revised |
Full-text search in SQL Server on multiple tables fails corrected the altered stored procedure to show the changes I had actually made to it. |
|
Oct 22 |
asked | Full-text search in SQL Server on multiple tables fails |
|
May 22 |
comment |
Replace cursor with set-based approach We can't join on email unless address is blank. But this is close enough that I can work out the remaining issues. Thanks tons. |
|
May 22 |
accepted | Replace cursor with set-based approach |
|
May 21 |
comment |
Replace cursor with set-based approach Up-voted. This is quite close--I think the rest can be handled with IF logic. Checking one last thing before accepting as the answer. |
|
May 21 |
comment |
Replace cursor with set-based approach @AaronBertrand : Again, this is simplified. The column extra actually represents 6 columns, only one of which is actually nullable in the personal_code_extra table. This represents data that is specific to the merchants of only a single industry, not all of our clients. |
|
May 21 |
revised |
Replace cursor with set-based approach Error in final insert statement |
|
May 21 |
comment |
Replace cursor with set-based approach @AaronBertrand : There absolutely will be either an address or an email. The match will be on fname-lname-address if an address is supplied; otherwise on fname-lname-email. One of the two must be supplied. The data is not being submitted directly from customers. |
|
May 21 |
awarded | Commentator |