Quick Query

Our dev database was not built correctly for phone #'s so all of the
sample data or test data (not sure if it is legit) has them in the form
of XXX-YYY-ZZZZ. Is there a query that can remove the dashes from
those values and turn it into XXXYYYZZZZ?
Thanks.Try:
update MyTable
set
Phone = replace (Phone, '-', '')
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<josh.tucholski@.gmail.com> wrote in message
news:1156253610.284442.275620@.i3g2000cwc.googlegroups.com...
Our dev database was not built correctly for phone #'s so all of the
sample data or test data (not sure if it is legit) has them in the form
of XXX-YYY-ZZZZ. Is there a query that can remove the dashes from
those values and turn it into XXXYYYZZZZ?
Thanks.|||update YourTable
set PhoneNumber = replace(PhoneNumber, '-', '')
-Sue
On 22 Aug 2006 06:33:30 -0700, josh.tucholski@.gmail.com
wrote:

>Our dev database was not built correctly for phone #'s so all of the
>sample data or test data (not sure if it is legit) has them in the form
>of XXX-YYY-ZZZZ. Is there a query that can remove the dashes from
>those values and turn it into XXXYYYZZZZ?
>Thanks.

Quick Query

Our dev database was not built correctly for phone #'s so all of the
sample data or test data (not sure if it is legit) has them in the form
of XXX-YYY-ZZZZ. Is there a query that can remove the dashes from
those values and turn it into XXXYYYZZZZ?
Thanks.Try:
update MyTable
set
Phone = replace (Phone, '-', '')
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<josh.tucholski@.gmail.com> wrote in message
news:1156253610.284442.275620@.i3g2000cwc.googlegroups.com...
Our dev database was not built correctly for phone #'s so all of the
sample data or test data (not sure if it is legit) has them in the form
of XXX-YYY-ZZZZ. Is there a query that can remove the dashes from
those values and turn it into XXXYYYZZZZ?
Thanks.|||update YourTable
set PhoneNumber = replace(PhoneNumber, '-', '')
-Sue
On 22 Aug 2006 06:33:30 -0700, josh.tucholski@.gmail.com
wrote:
>Our dev database was not built correctly for phone #'s so all of the
>sample data or test data (not sure if it is legit) has them in the form
>of XXX-YYY-ZZZZ. Is there a query that can remove the dashes from
>those values and turn it into XXXYYYZZZZ?
>Thanks.

Quick Fact Check on Clustering SQL Server

Am I correct in my assumption? If I am creating a two-node SQL Server 2000
active\active cluster configuration, (cluster will be built on Windows 2000)
I can have a maximum of one virtual server name per node and up to 16 named
instances per node if I do not use the Default Instance.
Thanks
Steven S. Warren [MVP Windows]
MCDBA, MCSE, MCSA, CCA
Close. You get up to 16 instances per cluster. You can have 1 default and
15 named or just 1 named instances. You can arrange them on the host nodes
however you see fit.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Steven S. Warren" <swtechworksnomorespam@.tampabay.rr.com> wrote in message
news:%23209KlbvEHA.2536@.TK2MSFTNGP11.phx.gbl...
> Am I correct in my assumption? If I am creating a two-node SQL Server 2000
> active\active cluster configuration, (cluster will be built on Windows
2000)
> I can have a maximum of one virtual server name per node and up to 16
named
> instances per node if I do not use the Default Instance.
> Thanks
> --
> Steven S. Warren [MVP Windows]
> MCDBA, MCSE, MCSA, CCA
>
|||Thanks...Back to designing my cluster...I am enjoying this.
Thanks
Steven S. Warren [MVP Windows]
MCDBA, MCSE, MCSA, CCA
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OI$YfUcvEHA.612@.TK2MSFTNGP15.phx.gbl...
> Close. You get up to 16 instances per cluster. You can have 1 default
> and
> 15 named or just 1 named instances. You can arrange them on the host
> nodes
> however you see fit.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Steven S. Warren" <swtechworksnomorespam@.tampabay.rr.com> wrote in
> message
> news:%23209KlbvEHA.2536@.TK2MSFTNGP11.phx.gbl...
> 2000)
> named
>

Questions to the Microsoft guys about the custom assembly

Hi Guys,

I created a custom assemy and added a reference to it in my report, but when I built the report, it told me that the system could not find the file. I followed the steps in the MSDN when I did the above steps. Can anybody tell me why?

Another question is about the location of the assmbly that I should copy. In the Debugging Custom Assemblie chapter on MSDN, it tells to copy my assembly to

C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE.

But in Deploying a Custom Assembly chapter, it tells me to copy it to

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies.

Can Microsoft guys tell me which is correct?

Thanks in advance.

Danny

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies is the correct location for the report designer in BI Development Studio.

-- Robert

|||

Hi Robert,

Thank you very much for your answer. My another question is I can only refer to my custom assembly when I use strong name for the assembly and put it into GAC. Or else, the report designer just told me that the file or its dependecies counld not be found. But put the assembly into the GAC means I cannot debug my assembly. Could you give me some tips on this? (I followed all the steps I could find on the MSDN)

Thanks in advance.

Danny