Viewing 15 posts - 16,831 through 16,845 (of 18,926 total)
This is formated to work in a select statement... could be optimized to be used in a function.
Declare @Zip as varchar(6)
SET @Zip = 'L5 3QE'
Select LEFT(@Zip, CASE WHEN charindex(' '...
June 14, 2005 at 7:46 am
Yes but that would take extensive efforts. How about you copy the sp and adapt it to your needs on the 2nd server?
June 14, 2005 at 7:42 am
Why can't you use the same database for the 2nd application?
How will you use the first database?
June 14, 2005 at 7:37 am
We'll have to wait 'till you get home...
June 14, 2005 at 7:32 am
DDL = Data definition language.
Go in enterprise manager, select the 2 tables then right-click, copy, then you'll be able to paste the results in the boards here.
Then I'd like to...
June 14, 2005 at 7:29 am
Why do you want to do something like this?
June 14, 2005 at 7:25 am
Please do not cross-post, we monitor all boards.
Finish the thread here
June 14, 2005 at 7:23 am
Outch, would be nice if we could catch the recordset into a table...
June 14, 2005 at 7:11 am
Never seen it written that way, but as long as it works for you
.
June 14, 2005 at 7:09 am
Joe HATES identity columns like the pest, now you wanna create the clustered index on it
???
I'm not gonna restart that discussion here....
June 14, 2005 at 7:02 am
Can I get both tables' DDL, with a few inserts statements for the sample data (don't wanna guess the column's name) ?
June 14, 2005 at 7:00 am
Obviously, nice thinking about this script.
June 14, 2005 at 6:58 am
In the same line.. I often resort to decompiling the whole project and recompiling to correct bugs like this.
It sure helped me a lot in the past.
June 14, 2005 at 6:57 am
I never understood you didn't like my postings
.
June 14, 2005 at 6:55 am
Viewing 15 posts - 16,831 through 16,845 (of 18,926 total)