Viewing 15 posts - 1,426 through 1,440 (of 1,473 total)
Garadin's post points out why I like to put the Carriage Return/Line Feed into a variable constant rather than repeating it over and over. His last one is incorrect.
Good call....
October 8, 2008 at 5:41 am
Take a look at this, courtesy of Jeff Moden:
October 8, 2008 at 5:31 am
Why would you do something like this?
October 8, 2008 at 5:29 am
I see that the editor removed XML tags from my post and that is why you dont get the correct results.
Heh, good, I kept trying it and didn't get...
October 7, 2008 at 10:06 pm
The word "Table" is a keyword. Try using something like MyTable instead.
October 7, 2008 at 11:54 am
Can you guarantee that all error codes are exactly 3 digits in length?
October 7, 2008 at 11:10 am
For the future, when someone asks for table structure / data, please post it like this:
[font="Courier New"]CREATE TABLE Table1(
fname VARCHAR(50),
lname VARCHAR(50),
error_code VARCHAR(100))
CREATE TABLE Table2(
err_cd VARCHAR(50),
err_msg VARCHAR(100))
INSERT INTO Table1(fname, lname, error_code)
SELECT...
October 7, 2008 at 10:52 am
My edit went through after your post. Please also provide sample data as so. Make sure you include data that will demonstrate the double entry issue.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 7, 2008 at 10:16 am
Beautiful, thank you sir.
October 7, 2008 at 10:04 am
That depends on what you'd like to happen in the case that they don't supply either value.
October 7, 2008 at 10:03 am
[font="Courier New"]
SET @body =
'The system has detected the following event: ' + CHAR(10) + CHAR(13) +
'SQL Alert Notification: No Activity ' + CHAR(10) + CHAR(13) +
'Date time:' + CAST(@TimeStamp AS...
October 7, 2008 at 9:56 am
Please post your table layouts for us to give you an example query. What you are looking for is just going to be a very simple join, but without...
October 7, 2008 at 9:50 am
Off Topic:
Chris, how are you getting your SQL code color coded rather than all Black and White?
October 7, 2008 at 8:09 am
Indeed it does. I was using the _ to ensure that nothing wacky happened with the Querystring, but SQL handles the %20 just fine. Thanks Jack.
October 6, 2008 at 2:45 pm
Write an Update statement with REPLACE(column,'"','') for each column.
That replace is: REPLACE ( column, ' " ', ' ') in...
October 6, 2008 at 12:14 pm
Viewing 15 posts - 1,426 through 1,440 (of 1,473 total)