hi there,
could you possible ellaborate? what do you mean by normilise the data
structure?
Thanks
danny
-----Original Message-----
From: andersg [mailto:[Email address protected]
Sent: 22 December 2004 18:08
To: Danny Hearn
Subject: RE: Dynamic path
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text
You need to normalize your data structure.
Glen Anderson
Operations Analyst
Card Services Collections MIS
503-614-6728
-----Original Message-----
From: Danny Hearn
[mailto:mssqldba-ezmlmshield-x12593778.[Email address protected]
Sent: Wednesday, December 22, 2004 7:53 AM
To: LazyDBA Discussion
Subject: RE: Dynamic path
ahh but
the true path would be
suppliers_new.LatinAmerica
suppliers_new.Asia
etc..
so not sure how:
SELECT suppliers_category.SuppliersID, @Location AS Location
can work...
Wouldn't it have to be
SELECT suppliers_category.SuppliersID, [Email Address Removed] AS
suppliers_new.LatinAmerica
- but I can't put Latin America as I Don't know which continent it would
be
hence the dynamic param)
-----Original Message-----
From: Smith Dano
[mailto:mssqldba-ezmlmshield-x50596283.[Email address protected]
Sent: 22 December 2004 15:41
To: LazyDBA Discussion
Subject: RE: Dynamic path
If you want @Location as a column in your result set, use this...
SELECT suppliers_category.SuppliersID, @Location AS Location
Dano..
-----Original Message-----
From: Danny Hearn
[mailto:mssqldba-ezmlmshield-x26172675.[Email address protected]
Sent: Wednesday, December 22, 2004 10:24 AM
To: LazyDBA Discussion
Subject: Dynamic path [faked-from]
Importance: Low
Hi there...
I'm trying to use a parameter in a stored procedure to form a path is
this
poss?
CREATE PROCEDURE bp_suppliers_map
@Form int,
@Location nvarchar(100)
AS
SELECT suppliers_category.SuppliersID, suppliers_new.@Location
GO
Thanks
Danny
Visit www.statravel.co.uk
For flights, insurance, accommodation, discount cards, visa information,
currency, car hire,
package holidays, weekend breaks, ski trips, travel gear, destination
info, tours,
travel passes, work abroad packages and much more.
This message and any attachments are confidential to the ordinary
user of the e-mail address to which it was addressed and may also
be privileged. If you are not the addressee you may not copy,
forward, disclose or use any part of the message or its
attachments and if you have received this message in error, please
notify the sender immediately by return e-mail and delete it from
your system.
Internet communications cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
arrive late or contain viruses. The sender therefore does not
accept liability for any errors or omissions in the context of
this message which arise as a result of Internet transmission.
Any opinions contained in this message are those of the author and
are not given or endorsed by the STA Travel Group or office
through which this message is sent unless otherwise clearly
indicated in this message and the authority of the author to so
bind STA Travel entity referred to is duly verified.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
Visit www.statravel.co.uk
For flights, insurance, accommodation, discount cards, visa information,
currency, car hire,
package holidays, weekend breaks, ski trips, travel gear, destination
info, tours,
travel passes, work abroad packages and much more.
This message and any attachments are confidential to the ordinary
user of the e-mail address to which it was addressed and may also
be privileged. If you are not the addressee you may not copy,
forward, disclose or use any part of the message or its
attachments and if you have received this message in error, please
notify the sender immediately by return e-mail and delete it from
your system.
Internet communications cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
arrive late or contain viruses. The sender therefore does not
accept liability for any errors or omissions in the context of
this message which arise as a result of Internet transmission.
Any opinions contained in this message are those of the author and
are not given or endorsed by the STA Travel Group or office
through which this message is sent unless otherwise clearly
indicated in this message and the authority of the author to so
bind STA Travel entity referred to is duly verified.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
Visit www.statravel.co.uk
For flights, insurance, accommodation, discount cards, visa information, currency, car hire,
package holidays, weekend breaks, ski trips, travel gear, destination info, tours,
travel passes, work abroad packages and much more.
This message and any attachments are confidential to the ordinary
user of the e-mail address to which it was addressed and may also
be privileged. If you are not the addressee you may not copy,
forward, disclose or use any part of the message or its
attachments and if you have received this message in error, please
notify the sender immediately by return e-mail and delete it from
your system.
Internet communications cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
arrive late or contain viruses. The sender therefore does not
accept liability for any errors or omissions in the context of
this message which arise as a result of Internet transmission.
Any opinions contained in this message are those of the author and
are not given or endorsed by the STA Travel Group or office
through which this message is sent unless otherwise clearly
indicated in this message and the authority of the author to so
bind STA Travel entity referred to is duly verified.
MS Sql Server LazyDBA home page