Items no longer needed

Posted by dan on January 2, 2007, 6:58 pm

Please log in for more thread options

Hi,
I want to delete (not make inactive) many items we no longer need and no
longer need to refer to any transaction history. I want to delete them from
the HQ database and then make sure the corresponding items are deleted at
all 10 stores.
If I delete the item at HQ will a corresponding delete occur at the store
when a 401 worksheet runs? Or do I need to issue a (massively long - many
thousands of items) sql statement to do this?
What would the sql be to delete the item, its corresponding record in
itemdynaic and any transaction histories associated with the item.
Thanks in advance.

--
Regards

Dan

Posted by Terrible Tom on January 2, 2007, 7:52 pm

Please log in for more thread options

A 401 won't help at all.

There is no worksheet for deleting items at the store level.

As far as queries go, if you have the list of ILCs in some manageable format
you can create a series of query statements in Excel by using text formulas.
For example, at the store ops level, the sql statement would be:

DELETE from Item WHERE ItemLookupCode = 'XXX'

At HQ, you might need to export the results of a query that gives you ID &
ILC from the Item table then delete the IDs from the ItemDynamic table. This
could be complicated and you could screw up *big time*.

Maybe somebody else has a better idea.

Tom
--
Stop fishing for e-mail

"dan" wrote:

> Hi,

> I want to delete (not make inactive) many items we no longer need and no

> longer need to refer to any transaction history. I want to delete them from

> the HQ database and then make sure the corresponding items are deleted at

> all 10 stores.

> If I delete the item at HQ will a corresponding delete occur at the store

> when a 401 worksheet runs? Or do I need to issue a (massively long - many

> thousands of items) sql statement to do this?

> What would the sql be to delete the item, its corresponding record in

> itemdynaic and any transaction histories associated with the item.

> Thanks in advance.

> --

> Regards

> Dan

Posted by Jeff @ Check Point Software on January 4, 2007, 9:27 pm

Please log in for more thread options

: quoted-printable

Dan,

Currently, there isn't that option to delete them from HQ and the =
stores.

Check with Afshin @ Retail Realm as I think they have a utility to do =
it. Afshin@RetailRealm.co.uk

--=20

Jeff=20
Check Point Software

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express or some other type of newsgroup reader =
to
see and download the file attachment(s). If you are not using a reader, =
follow
the link below to setup Outlook Express. Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

Hi,
I want to delete (not make inactive) many items we no longer need and =
no=20
longer need to refer to any transaction history. I want to delete them =
from=20
the HQ database and then make sure the corresponding items are deleted =
at=20
all 10 stores.
If I delete the item at HQ will a corresponding delete occur at the =
store=20
when a 401 worksheet runs? Or do I need to issue a (massively long - =
many=20
thousands of items) sql statement to do this?
What would the sql be to delete the item, its corresponding record in=20
itemdynaic and any transaction histories associated with the item.
Thanks in advance.

--=20
Regards

Dan=20

------=_NextPart_000_075D_01C7302D.FAFC0370
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Dan,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Currently, there isn't that option to delete =
them from=20
HQ and the stores.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Check with Afshin @ Retail Realm as I think =
they have a=20
utility to do it.  <A=20
NT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV> </DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express or some other type of newsgroup =
reader=20
to<BR>see and download the file attachment(s).  If you are not =
using a=20
reader, follow<BR>the link below to setup Outlook Express.  Click =
on "Open=20
with newsreader"<BR>under the MS Retail Management System on the =
right.</DIV>
<DIV> </DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"dan" <<A =
wrote in message <A=20
=
80@TK2MSFTNGP03.phx.gbl</A>...</DIV>Hi,<BR>I=20
want to delete (not make inactive) many items we no longer need and no =

<BR>longer need to refer to any transaction history. I want to delete =
them=20
from <BR>the HQ database and then make sure the corresponding items =
are=20
deleted at <BR>all 10 stores.<BR>If I delete the item at HQ will a=20
corresponding delete occur at the store <BR>when a 401 worksheet runs? =
Or do I=20
need to issue a (massively long - many <BR>thousands of items) sql =
statement=20
to do this?<BR>What would the sql be to delete the item, its =
corresponding=20
record in <BR>itemdynaic and any transaction histories associated with =
the=20
item.<BR>Thanks in advance.<BR><BR>-- <BR>Regards<BR><BR>Dan=20
<BR><BR></BLOCKQUOTE></BODY></HTML>

------=