Viewing 15 posts - 20,161 through 20,175 (of 26,484 total)
Peso (6/29/2009)
And without the CASE thingySELECTZIP + COALESCE('-' + PlusFour, '') AS FullZIP
FROM[Address]
Or, if you aren't concerned about using only Standard SQL:
SELECT ZIP + isnull('-' + PlusFour, '') AS FullZIP
FROM...
June 29, 2009 at 3:48 pm
Can you provide the DDL for the table (original, not temporary), sample data (in a readily consummable format that can be cut/paste/run in SSMS), expected results based on the sample...
June 29, 2009 at 3:46 pm
When using the quote button anymore, I do two things. First, I refresh the page prior to clicking on the quote button. Second, reading the quote to be...
June 29, 2009 at 3:36 pm
Alvin Ramard (6/29/2009)
Roy Ernest (6/29/2009)
Can someone take a look at this issue?? I am bit lost on how to help this OP.
That's ok. It's just the usual behind the...
June 29, 2009 at 3:23 pm
Florian Reischl (6/29/2009)
Uh... Sorry, folks! Didn't see that the discussion about the UPDATE-thread is ongoing here.
Just a side conversation between colleagues, please feel free to join in. 😉
June 29, 2009 at 3:20 pm
ddicecca (6/29/2009)
When you refer to Books On Line, is that something on this forum? I apologize ahead of time if this is a stupid question...
Nope, Books Online is the...
June 29, 2009 at 3:03 pm
GilaMonster (6/29/2009)
Alvin Ramard (6/29/2009)
Lynn Pettis (6/29/2009)
Snippy some people can be.
Yep. I'm ready to guess the solution to his update problem is, but we can't say without knowing more about...
June 29, 2009 at 3:00 pm
GilaMonster (6/29/2009)
Lynn Pettis (6/29/2009)
Actually Gail, I think it is just an old style inner join.
Except that there's no condition in the where clause that joins the two tables...
June 29, 2009 at 2:56 pm
GilaMonster (6/29/2009)
ddicecca (6/29/2009)
GilaMonster (6/29/2009)
Take a look in Books Online for the UPDATE ... FROM syntax.Seriously...? That's your help?
I'm sorry, I thought you might like a hint where...
June 29, 2009 at 2:50 pm
ddicecca (6/29/2009)
Lynn Pettis (6/29/2009)
ddicecca (6/29/2009)
GilaMonster (6/29/2009)
Take a look in Books Online for the UPDATE ... FROM syntax.
Seriously...? That's your help? I have Googled this for a good hour...
June 29, 2009 at 2:48 pm
Not knowing the possible values in PlusFour, try this:
SELECT (ZIP + case when PlusFour is not null then '-' + PlusFour else '' end) AS FullZIP
FROM Address
June 29, 2009 at 2:41 pm
ddicecca (6/29/2009)
GilaMonster (6/29/2009)
Take a look in Books Online for the UPDATE ... FROM syntax.
Seriously...? That's your help? I have Googled this for a good hour already. Hence...
June 29, 2009 at 2:34 pm
Alvin Ramard (6/29/2009)
Lynn and Gail, what would you say to creating a new table in a user database for holding the new data, along with the key fields from sys.sql_logins?
Hmm,...
June 29, 2009 at 2:20 pm
First, to help we will need additional information. We need the DDL (CREATE TABLE statements) for the tables involved, both source and destination. Sample data in a readily...
June 29, 2009 at 2:17 pm
Viewing 15 posts - 20,161 through 20,175 (of 26,484 total)