SQL Auto 250 worksheet

Posted by Chris Allsopp - Connaught Hous on April 17, 2007, 9:00 am

Please log in for more thread options

I'm sure this has been mentioned before, but I can't find it anywhere.

People not doing 250 worksheets (and others) is a real problem for me. Is
there a SQL command that can be run every day at say 23:00 to perform a 250
to send all data to the shops?

Posted by Ahmed Nashat on April 18, 2007, 3:32 am

Please log in for more thread options

: quoted-printable

Chris,

find attached the job script, please search in the script for HQSample =
and replace it with your database name, the job will run each day at =
23:00 and it well send ONLY the items updated in the same day, you can =
remove the condition if you want the job to send all items

Nashat

> I'm sure this has been mentioned before, but I can't find it anywhere.

>=20

> People not doing 250 worksheets (and others) is a real problem for me. =

Is=20

> there a SQL command that can be run every day at say 23:00 to perform =

a 250=20

> to send all data to the shops?=20

>=20

------=_NextPart_001_0033_01C7819C.7672BA20
Content-Type: text/html;
        charset="windows-1256"
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-1256">
<META content=3D"MSHTML 6.00.2900.3059" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 =
size=3D2>Chris,</FONT></DIV>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 size=3D2>find =
attached the job=20
script, please search in the script for HQSample and replace it with =
your=20
database name, the job will run each day at 23:00 and it well send ONLY =
the=20
items updated in the same day, you can remove the condition if you want =
the job=20
to send all items</FONT></DIV>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 =
size=3D2>Nashat</FONT></DIV>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 =
size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>"Chris Allsopp - Connaught House" =
<</FONT><A=20
size=3D2>chris@connaught-house.co.uk</FONT></A><FONT face=3DArial =
size=3D2>> wrote=20
in message </FONT><A =
face=3DArial =
face=3DArial size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> =
I'm sure this has=20
been mentioned before, but I can't find it anywhere.<BR>> <BR>> =
People not=20
doing 250 worksheets (and others) is a real problem for me.  Is =
<BR>>=20
there a SQL command that can be run every day at say 23:00 to perform a =
250=20
<BR>> to send all data to the shops? <BR>> =
<BR>></FONT></BODY></HTML>

------=_NextPart_001_0033_01C7819C.7672BA20--

------=_NextPart_000_0032_01C7819C.7672BA20
Content-Type: application/octet-stream;
        name="job script.sql"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
        filename="job script.sql"

//4tAC0AIABTAGMAcgBpAHAAdAAgAGcAZQBuAGUAcgBhAHQAZQBkACAAbwBuACAAMQA4AC8AMAA0
AC8AMgAwADAANwAgADAAOQA6ADIAOAAgADUGDQAKAC0ALQAgAEIAeQA6ACAAcwBhAA0ACgAtAC0A
IABTAGUAcgB2AGUAcgA6ACAAKABMAE8AQwBBAEwAKQANAAoADQAKAEIARQBHAEkATgAgAFQAUgBB
AE4AUwBBAEMAVABJAE8ATgAgACAAIAAgACAAIAAgACAAIAAgACAAIAANAAoAIAAgAEQARQBDAEwA
QQBSAEUAIABAAEoAbwBiAEkARAAgAEIASQBOAEEAUgBZACgAMQA2ACkAIAAgAA0ACgAgACAARABF
AEMATABBAFIARQAgAEAAUgBlAHQAdQByAG4AQwBvAGQAZQAgAEkATgBUACAAIAAgACAADQAKACAA
IABTAEUATABFAEMAVAAgAEAAUgBlAHQAdQByAG4AQwBvAGQAZQAgAD0AIAAwACAAIAAgACAAIAAN
AAoASQBGACAAKABTAEUATABFAEMAVAAgAEMATwBVAE4AVAAoACoAKQAgAEYAUgBPAE0AIABtAHMA
ZABiAC4AZABiAG8ALgBzAHkAcwBjAGEAdABlAGcAbwByAGkAZQBzACAAVwBIAEUAUgBFACAAbgBh
AG0AZQAgAD0AIABOACcAWwBVAG4AYwBhAHQAZQBnAG8AcgBpAHoAZQBkACAAKABMAG8AYwBhAGwA
KQBdACcAKQAgADwAIAAxACAADQAKACAAIABFAFgARQBDAFUAVABFACAAbQBzAGQAYgAuAGQAYgBv
AC4AcwBwAF8AYQBkAGQAXwBjAGEAdABlAGcAbwByAHkAIABAAG4AYQBtAGUAIAA9ACAATgAnAFsA
VQBuAGMAYQB0AGUAZwBvAHIAaQB6AGUAZAAgACgATABvAGMAYQBsACkAXQAnAA0ACgANAAoAIAAg
AC0ALQAgAEQAZQBsAGUAdABlACAAdABoAGUAIABqAG8AYgAgAHcAaQB0AGgAIAB0AGgAZQAgAHMA
YQBtAGUAIABuAGEAbQBlACAAKABpAGYAIABpAHQAIABlAHgAaQBzAHQAcwApAA0ACgAgACAAUwBF
AEwARQBDAFQAIABAAEoAbwBiAEkARAAgAD0AIABqAG8AYgBfAGkAZAAgACAAIAAgACAADQAKACAA
IABGAFIATwBNACAAIAAgAG0AcwBkAGIALgBkAGIAbwAuAHMAeQBzAGoAbwBiAHMAIAAgACAAIAAN
AAoAIAAgAFcASABFAFIARQAgACgAbgBhAG0AZQAgAD0AIABOACcAVQBwAGQAYQB0AGUAIABJAG4A
dgBlAG4AdABvAHIAeQAnACkAIAAgACAAIAAgACAAIAANAAoAIAAgAEkARgAgACgAQABKAG8AYgBJ
AEQAIABJAFMAIABOAE8AVAAgAE4AVQBMAEwAKQAgACAAIAAgAA0ACgAgACAAQgBFAEcASQBOACAA
IAANAAoAIAAgAC0ALQAgAEMAaABlAGMAawAgAGkAZgAgAHQAaABlACAAagBvAGIAIABpAHMAIABh
ACAAbQB1AGwAdABpAC0AcwBlAHIAdgBlAHIAIABqAG8AYgAgACAADQAKACAAIABJAEYAIAAoAEUA
WABJAFMAVABTACAAKABTAEUATABFAEMAVAAgACAAKgAgAA0ACgAgACAAIAAgACAAIAAgACAAIAAg
ACAAIAAgACAARgBSAE8ATQAgACAAIAAgAG0AcwBkAGIALgBkAGIAbwAuAHMAeQBzAGoAbwBiAHMA
ZQByAHYAZQByAHMAIAANAAoAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgAFcASABFAFIARQAg
ACAAIAAoAGoAbwBiAF8AaQBkACAAPQAgAEAASgBvAGIASQBEACkAIABBAE4ARAAgACgAcwBlAHIA
dgBlAHIAXwBpAGQAIAA8AD4AIAAwACkAKQApACAADQAKACAAIABCAEUARwBJAE4AIAANAAoAIAAg
ACAAIAAtAC0AIABUAGgAZQByAGUAIABpAHMALAAgAHMAbwAgAGEAYgBvAHIAdAAgAHQAaABlACAA
cwBjAHIAaQBwAHQAIAANAAoAIAAgACAAIABSAEEASQBTAEUAUgBSAE8AUgAgACgATgAnAFUAbgBh
AGIAbABlACAAdABvACAAaQBtAHAAbwByAHQAIABqAG8AYgAgACcAJwBVAHAAZABhAHQAZQAgAEkA
bgB2AGUAbgB0AG8AcgB5ACcAJwAgAHMAaQBuAGMAZQAgAHQAaABlAHIAZQAgAGkAcwAgAGEAbABy
AGUAYQBkAHkAIABhACAAbQB1AGwAdABpAC0AcwBlAHIAdgBlAHIAIABqAG8AYgAgAHcAaQB0AGgA
IAB0AGgAaQBzACAAbgBhAG0AZQAuACcALAAgADEANgAsACAAMQApACAADQAKACAAIAAgACAARwBP
AFQATwAgAFEAdQBpAHQAVwBpAHQAaABSAG8AbABsAGIAYQBjAGsAIAAgAA0ACgAgACAARQBOAEQA
IAANAAoAIAAgAEUATABTAEUAIAANAAoAIAAgACAAIAAtAC0AIABEAGUAbABlAHQAZQAgAHQAaABl
ACAAWwBsAG8AYwBhAGwAXQAgAGoAbwBiACAADQAKACAAIAAgACAARQBYAEUAQwBVAFQARQAgAG0A
cwBkAGIALgBkAGIAbwAuAHMAcABfAGQAZQBsAGUAdABlAF8AagBvAGIAIABAAGoAbwBiAF8AbgBh
AG0AZQAgAD0AIABOACcAVQBwAGQAYQB0AGUAIABJAG4AdgBlAG4AdABvAHIAeQAnACAADQAKACAA
IAAgACAAUwBFAEwARQBDAFQAIABAAEoAbwBiAEkARAAgAD0AIABOAFUATABMAA0ACgAgACAARQBO
AEQAIAANAAoADQAKAEIARQBHAEkATgAgAA0ACgANAAoAIAAgAC0ALQAgAEEAZABkACAAdABoAGUA
IABqAG8AYgANAAoAIAAgAEUAWABFAEMAVQBUAEUAIABAAFIAZQB0AHUAcgBuAEMAbwBkAGUAIAA9
ACAAbQBzAGQAYgAuAGQAYgBvAC4AcwBwAF8AYQBkAGQAXwBqAG8AYgAgAEAAagBvAGIAXwBpAGQA
IAA9ACAAQABKAG8AYgBJAEQAIABPAFUAVABQAFUAVAAgACwAIABAAGoAbwBiAF8AbgBhAG0AZQAg
AD0AIABOACcAVQBwAGQAYQB0AGUAIABJAG4AdgBlAG4AdABvAHIAeQAnACwAIABAAG8AdwBuAGUA
cgBfAGwAbwBnAGkAbgBfAG4AYQBtAGUAIAA9ACAATgAnAHMAYQAnACwAIABAAGQAZQBzAGMAcgBp
AHAAdABpAG8AbgAgAD0AIABOACcATgBvACAAZABlAHMAYwByAGkAcAB0AGkAbwBuACAAYQB2AGEA
aQBsAGEAYgBsAGUALgAnACwAIABAAGMAYQB0AGUAZwBvAHIAeQBfAG4AYQBtAGUAIAA9ACAATgAn
AFsAVQBuAGMAYQB0AGUAZwBvAHIAaQB6AGUAZAAgACgATABvAGMAYQBsACkAXQAnACwAIABAAGUA
bgBhAGIAbABlAGQAIAA9ACAAMQAsACAAQABuAG8AdABpAGYAeQBfAGwAZQB2AGUAbABfAGUAbQBh
AGkAbAAgAD0AIAAwACwAIABAAG4AbwB0AGkAZgB5AF8AbABlAHYAZQBsAF8AcABhAGcAZQAgAD0A
IAAwACwAIABAAG4AbwB0AGkAZgB5AF8AbABlAHYAZQBsAF8AbgBlAHQAcwBlAG4AZAAgAD0AIAAw
ACwAIABAAG4AbwB0AGkAZgB5AF8AbABlAHYAZQBsAF8AZQB2AGUAbgB0AGwAbwBnACAAPQAgADIA
LAAgAEAAZABlAGwAZQB0AGUAXwBsAGUAdgBlAGwAPQAgADAADQAKACAAIABJAEYAIAAoAEAAQABF
AFIAUgBPAFIAIAA8AD4AIAAwACAATwBSACAAQABSAGUAdAB1AHIAbgBDAG8AZABlACAAPAA+ACAA
MAApACAARwBPAFQATwAgAFEAdQBpAHQAVwBpAHQAaABSAG8AbABsAGIAYQBjAGsAIAANAAoADQAK
ACAAIAAtAC0AIABBAGQAZAAgAHQAaABlACAAagBvAGIAIABzAHQAZQBwAHMADQAKACAAIABFAFgA
RQBDAFUAVABFACAAQABSAGUAdAB1AHIAbgBDAG8AZABlACAAPQAgAG0AcwBkAGIALgBkAGIAbwAu
AHMAcABfAGEAZABkAF8AagBvAGIAcwB0AGUAcAAgAEAAagBvAGIAXwBpAGQAIAA9ACAAQABKAG8A
YgBJAEQALAAgAEAAcwB0AGUAcABfAGkAZAAgAD0AIAAxACwAIABAAHMAdABlAHAAXwBuAGEAbQBl
ACAAPQAgAE4AJwBTAHQAZQBwADEAJwAsACAAQABjAG8AbQBtAGEAbgBkACAAPQAgAE4AJwAtAC0A
cwBoAG8AdQBsAGQAIABjAGgAZQBjAGsAIABoAGUAcgBlACAAaQBmACAAdABoAGUAcgBlACAAcgAg
AGkAdABlAG0AcwAgAGEAcwBsAGEAbgANAAoAaQBmACAAbgBvAHQAIABlAHgAaQBzAHQAcwAgACgA
cwBlAGwAZQBjAHQAIAAqACAAZgByAG8AbQAgAGkAdABlAG0AIAB3AGgAZQByAGUAIABJAHQAZQBt
AC4AWwBMAGEAcwB0AFUAcABkAGEAdABlAGQAXQAgAD4AIABnAGUAdABkAGEAdABlACgAKQAtACcA
JwAyADMAOgAwADAAOgAwADAAJwAnACkADQAKAAkAcgBlAHQAdQByAG4ADQAKAGQAZQBjAGwAYQBy
AGUAIABAAFcAUwBJAEQAIABpAG4AdAANAAoAZABlAGMAbABhAHIAZQAgAEAAUwB0AG8AcgBlAEkA
RAAgAGkAbgB0AA0ACgANAAoAaQBuAHMAZQByAHQAIABpAG4AdABvACAAVwBvAHIAawBzAGgAZQBl
AHQAKABTAHQAeQBsAGUALABFAGYAZgBlAGMAdABpAHYAZQBEAGEAdABlACwAUwB0AGEAdAB1AHMA
LABOAG8AdABlAHMALABUAGkAdABsAGUALABGAHIAbwBtAEQAYQB0AGUAKQANAAoAVgBhAGwAdQBl
AHMAIAAoACcAJwAyADUAMAAnACcAIAAsAGcAZQB0AGQAYQB0AGUAKAApACAALAAnACcAMgAnACcA
IAAsACcAJwAnACcAIAAsACcAJwBVAHAAZABhAHQAZQAgAEkAbgB2AGUAbgB0AG8AcgB5ACAALQAg
AEkAdABlAG0AcwAnACcAIAAsACcAJwAyADAAMAAwAC0AMAA1AC0AMgAyACAAMAAwADoAMAAwADoA
MAAwAC4AMAAwADAAJwAnACkADQAKAA0ACgBzAGUAdAAgAEAAVwBTAEkARAA9AEAAQABJAGQAZQBu
AHQAaQB0AHkADQAKAA0ACgBJAE4AUwBFAFIAVAAgAEkATgBUAE8AIABXAG8AcgBrAHMAaABlAGUA
dABIAGkAcwB0AG8AcgB5ACAAKABXAG8AcgBrAHMAaABlAGUAdABJAEQALABTAHQAYQB0AHUAcwAs
AEgAaQBzAHQAbwByAHkARABhAHQAZQAsAEgAUQBFAG4AdAByAHkALABTAHQAbwByAGUASQBEACwA
QwBvAG0AbQBlAG4AdAApAA0ACgBWAEEATABVAEUAUwAgACgAQABXAFMASQBEACwAMAAsAGcAZQB0
AGQAYQB0AGUAKAApACwAMAAsADAALAAnACcAQwByAGUAYQB0AGUAZAAgAGIAeQAgAGEAIABqAG8A
YgAnACcAKQANAAoADQAKAEkATgBTAEUAUgBUACAASQBOAFQATwAgAFcAbwByAGsAcwBoAGUAZQB0
AEgAaQBzAHQAbwByAHkAIAAoAFcAbwByAGsAcwBoAGUAZQB0AEkARAAsAFMAdABhAHQAdQBzACwA
SABpAHMAdABvAHIAeQBEAGEAdABlACwASABRAEUAbgB0AHIAeQAsAFMAdABvAHIAZQBJAEQALABD
AG8AbQBtAGUAbgB0ACkADQAKAFYAQQBMAFUARQBTACAAKABAAFcAUwBJAEQALAAwACwAZwBlAHQA
ZABhAHQAZQAoACkALAAwACwAMAAsACcAJwBBAHAAcAByAG8AdgBlAGQAIABiAHkAIABhACAAagBv
AGIAJwAnACkADQAKAA0ACgBEAEUAQwBMAEEAUgBFACAAUwB0AG8AcgBlAF8AQwB1AHIAcwBvAHIA
IABDAFUAUgBTAE8AUgAgAEYATwBSAA0ACgBTAEUATABFAEMAVAAgAGkAZAANAAoARgBSAE8ATQAg
AHMAdABvAHIAZQANAAoADQAKAE8AUABFAE4AIABTAHQAbwByAGUAXwBDAHUAcgBzAG8AcgANAAoA
RgBFAFQAQwBIACAATgBFAFgAVAAgAEYAUgBPAE0AIABTAHQAbwByAGUAXwBDAHUAcgBzAG8AcgAN
AAoAaQBuAHQAbwAgAEAAUwB0AG8AcgBlAEkARAANAAoAVwBIAEkATABFACAAQABAAEYARQBUAEMA
SABfAFMAVABBAFQAVQBTACAAPQAgADAADQAKAEIARQBHAEkATgANAAoACQBpAG4AcwBlAHIAdAAg
AGkAbgB0AG8AIABXAG8AcgBrAHMAaABlAGUAdABTAHQAbwByAGUAIAAoAFcAbwByAGsAUwBoAGUA
ZQB0AEkARAAsAFMAdABvAHIAZQBJAEQALABTAHQAYQB0AHUAcwAsAE8AcgBpAGcAaQBuAGEAdABv
AHIAKQANAAoACQBWAGEAbAB1AGUAcwAgACgAQABXAFMASQBEACwAQABTAHQAbwByAGUASQBEACwA
MAAsADAAKQANAAoADQAKAA0ACgAJAEYARQBUAEMASAAgAE4ARQBYAFQAIABGAFIATwBNACAAUwB0
AG8AcgBlAF8AQwB1AHIAcwBvAHIADQAKAAkAaQBuAHQAbwAgAEAAUwB0AG8AcgBlAEkARAANAAoA
RQBOAEQADQAKAEMATABPAFMARQAgAFMAdABvAHIAZQBfAEMAdQByAHMAbwByAA0ACgBEAEUAQQBM
AEwATwBDAEEAVABFACAAUwB0AG8AcgBlAF8AQwB1AHIAcwBvAHIADQAKAA0ACgBpAG4AcwBlAHIA
dAAgAGkAbgB0AG8AIABXAG8AcgBrAHMAaABlAGUAdABfAEkAdABlAG0AVQBwAGQAYQB0AGUADQAK
AA0ACgBzAGUAbABlAGMAdAAgAEAAVwBTAEkARAAgACAAYQBzACAAdwBvAHIAawBzAGgAZQBlAHQA
SQBEACwAIABpAHQAZQBtAC4AaQBkACAAYQBzACAASQB0AGUAbQBJAEQALAAgAG4AdQBsAGwAIABh
AHMAIABkAGIAdABpAG0AZQBzAHQAYQBtAHAADQAKAGYAcgBvAG0AIABpAHQAZQBtAA0ACgB3AGgA
ZQByAGUAIABJAHQAZQBtAC4AWwBMAGEAcwB0AFUAcABkAGEAdABlAGQAXQAgAD4AIABnAGUAdABk
AGEAdABlACgAKQAtACcAJwAyADMAOgAwADAAOgAwADAAJwAnACcALAAgAEAAZABhAHQAYQBiAGEA
cwBlAF8AbgBhAG0AZQAgAD0AIABOACcASABRAFMAYQBtAHAAbABlACcALAAgAEAAcwBlAHIAdgBl
AHIAIAA9ACAATgAnACcALAAgAEAAZABhAHQAYQBiAGEAcwBlAF8AdQBzAGUAcgBfAG4AYQBtAGUA
IAA9ACAATgAnACcALAAgAEAAcwB1AGIAcwB5AHMAdABlAG0AIAA9ACAATgAnAFQAUwBRAEwAJwAs
ACAAQABjAG0AZABlAHgAZQBjAF8AcwB1AGMAYwBlAHMAcwBfAGMAbwBkAGUAIAA9ACAAMAAsACAA
QABmAGwAYQBnAHMAIAA9ACAAMAAsACAAQAByAGUAdAByAHkAXwBhAHQAdABlAG0AcAB0AHMAIAA9
ACAAMAAsACAAQAByAGUAdAByAHkAXwBpAG4AdABlAHIAdgBhAGwAIAA9ACAAMQAsACAAQABvAHUA
dABwAHUAdABfAGYAaQBsAGUAXwBuAGEAbQBlACAAPQAgAE4AJwAnACwAIABAAG8AbgBfAHMAdQBj
AGMAZQBzAHMAXwBzAHQAZQBwAF8AaQBkACAAPQAgADAALAAgAEAAbwBuAF8AcwB1AGMAYwBlAHMA
cwBfAGEAYwB0AGkAbwBuACAAPQAgADEALAAgAEAAbwBuAF8AZgBhAGkAbABfAHMAdABlAHAAXwBp
AGQAIAA9ACAAMAAsACAAQABvAG4AXwBmAGEAaQBsAF8AYQBjAHQAaQBvAG4AIAA9ACAAMgANAAoA
IAAgAEkARgAgACgAQABAAEUAUgBSAE8AUgAgADwAPgAgADAAIABPAFIAIABAAFIAZQB0AHUAcgBu
AEMAbwBkAGUAIAA8AD4AIAAwACkAIABHAE8AVABPACAAUQB1AGkAdABXAGkAdABoAFIAbwBsAGwA
YgBhAGMAawAgAA0ACgAgACAARQBYAEUAQwBVAFQARQAgAEAAUgBlAHQAdQByAG4AQwBvAGQAZQAg
AD0AIABtAHMAZABiAC4AZABiAG8ALgBzAHAAXwB1AHAAZABhAHQAZQBfAGoAbwBiACAAQABqAG8A
YgBfAGkAZAAgAD0AIABAAEoAbwBiAEkARAAsACAAQABzAHQAYQByAHQAXwBzAHQAZQBwAF8AaQBk
ACAAPQAgADEAIAANAAoADQAKACAAIABJAEYAIAAoAEAAQABFAFIAUgBPAFIAIAA8AD4AIAAwACAA
TwBSACAAQABSAGUAdAB1AHIAbgBDAG8AZABlACAAPAA+ACAAMAApACAARwBPAFQATwAgAFEAdQBp
AHQAVwBpAHQAaABSAG8AbABsAGIAYQBjAGsAIAANAAoADQAKACAAIAAtAC0AIABBAGQAZAAgAHQA
aABlACAAagBvAGIAIABzAGMAaABlAGQAdQBsAGUAcwANAAoAIAAgAEUAWABFAEMAVQBUAEUAIABA
AFIAZQB0AHUAcgBuAEMAbwBkAGUAIAA9ACAAbQBzAGQAYgAuAGQAYgBvAC4AcwBwAF8AYQBkAGQA
XwBqAG8AYgBzAGMAaABlAGQAdQBsAGUAIABAAGoAbwBiAF8AaQBkACAAPQAgAEAASgBvAGIASQBE
ACwAIABAAG4AYQBtAGUAIAA9ACAATgAnAFMAYwBoAGUAZAB1AGwAZQAxACcALAAgAEAAZQBuAGEA
YgBsAGUAZAAgAD0AIAAxACwAIABAAGYAcgBlAHEAXwB0AHkAcABlACAAPQAgADQALAAgAEAAYQBj
AHQAaQB2AGUAXwBzAHQAYQByAHQAXwBkAGEAdABlACAAPQAgADIAMAAwADcAMAA0ADEAOAAsACAA
QABhAGMAdABpAHYAZQBfAHMAdABhAHIAdABfAHQAaQBtAGUAIAA9ACAAMgAzADAAMAAwADAALAAg
AEAAZgByAGUAcQBfAGkAbgB0AGUAcgB2AGEAbAAgAD0AIAAxACwAIABAAGYAcgBlAHEAXwBzAHUA
YgBkAGEAeQBfAHQAeQBwAGUAIAA9ACAAMQAsACAAQABmAHIAZQBxAF8AcwB1AGIAZABhAHkAXwBp
AG4AdABlAHIAdgBhAGwAIAA9ACAAMAAsACAAQABmAHIAZQBxAF8AcgBlAGwAYQB0AGkAdgBlAF8A
aQBuAHQAZQByAHYAYQBsACAAPQAgADAALAAgAEAAZgByAGUAcQBfAHIAZQBjAHUAcgByAGUAbgBj
AGUAXwBmAGEAYwB0AG8AcgAgAD0AIAAwACwAIABAAGEAYwB0AGkAdgBlAF8AZQBuAGQAXwBkAGEA
dABlACAAPQAgADkAOQA5ADkAMQAyADMAMQAsACAAQABhAGMAdABpAHYAZQBfAGUAbgBkAF8AdABp
AG0AZQAgAD0AIAAyADMANQA5ADUAOQANAAoAIAAgAEkARgAgACgAQABAAEUAUgBSAE8AUgAgADwA
PgAgADAAIABPAFIAIABAAFIAZQB0AHUAcgBuAEMAbwBkAGUAIAA8AD4AIAAwACkAIABHAE8AVABP
ACAAUQB1AGkAdABXAGkAdABoAFIAbwBsAGwAYgBhAGMAawAgAA0ACgANAAoAIAAgAC0ALQAgAEEA
ZABkACAAdABoAGUAIABUAGEAcgBnAGUAdAAgAFMAZQByAHYAZQByAHMADQAKACAAIABFAFgARQBD
AFUAVABFACAAQABSAGUAdAB1AHIAbgBDAG8AZABlACAAPQAgAG0AcwBkAGIALgBkAGIAbwAuAHMA
cABfAGEAZABkAF8AagBvAGIAcwBlAHIAdgBlAHIAIABAAGoAbwBiAF8AaQBkACAAPQAgAEAASgBv
AGIASQBEACwAIABAAHMAZQByAHYAZQByAF8AbgBhAG0AZQAgAD0AIABOACcAKABsAG8AYwBhAGwA
KQAnACAADQAKACAAIABJAEYAIAAoAEAAQABFAFIAUgBPAFIAIAA8AD4AIAAwACAATwBSACAAQABS
AGUAdAB1AHIAbgBDAG8AZABlACAAPAA+ACAAMAApACAARwBPAFQATwAgAFEAdQBpAHQAVwBpAHQA
aABSAG8AbABsAGIAYQBjAGsAIAANAAoADQAKAEUATgBEAA0ACgBDAE8ATQBNAEkAVAAgAFQAUgBB
AE4AUwBBAEMAVABJAE8ATgAgACAAIAAgACAAIAAgACAAIAAgAA0ACgBHAE8AVABPACAAIAAgAEUA
bgBkAFMAYQB2AGUAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgAA0ACgBRAHUAaQB0AFcAaQB0
AGgAUgBvAGwAbABiAGEAYwBrADoADQAKACAAIABJAEYAIAAoAEAAQABUAFIAQQBOAEMATwBVAE4A
VAAgAD4AIAAwACkAIABSAE8ATABMAEIAQQBDAEsAIABUAFIAQQBOAFMAQQBDAFQASQBPAE4AIAAN
AAoARQBuAGQAUwBhAHYAZQA6ACAADQAKAA0ACgANAAoA

------=

Posted by Chris Allsopp - Connaught Hous on April 18, 2007, 5:03 am

Please log in for more thread options

: quoted-printable

Thanks Nashat,

I've looked at the script though and I can't find HQSample in it

Chris
Chris,

find attached the job script, please search in the script for HQSample =
and replace it with your database name, the job will run each day at =
23:00 and it well send ONLY the items updated in the same day, you can =
remove the condition if you want the job to send all items

Nashat

> I'm sure this has been mentioned before, but I can't find it =
anywhere.
>=20
> People not doing 250 worksheets (and others) is a real problem for =
me. Is=20
> there a SQL command that can be run every day at say 23:00 to =
perform a 250=20
> to send all data to the shops?=20
>=20
>
------=_NextPart_000_00B7_01C781A0.DBBB8AC0
Content-Type: text/html;
charset="windows-1256"
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-1256">
<META content=3D"MSHTML 6.00.6000.16414" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Thanks Nashat,</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I've looked at the script though and I can't find =
HQSample in=20
it</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Chris</FONT></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Ahmed Nashat" <<A=20
wrote in=20
message <A=20
=
@TK2MSFTNGP04.phx.gbl</A>...</DIV>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 =
size=3D2>Chris,</FONT></DIV>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 size=3D2>find =
attached the job=20
script, please search in the script for HQSample and replace it with =
your=20
database name, the job will run each day at 23:00 and it well send =
ONLY the=20
items updated in the same day, you can remove the condition if you =
want the=20
job to send all items</FONT></DIV>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 =
size=3D2>Nashat</FONT></DIV>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 =
size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>"Chris Allsopp - Connaught House" =
<</FONT><A=20
size=3D2>chris@connaught-house.co.uk</FONT></A><FONT face=3DArial =
size=3D2>>=20
wrote in message </FONT><A=20

face=3DArial=20
size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> I'm sure =
this has been=20
mentioned before, but I can't find it anywhere.<BR>> <BR>> =
People not=20
doing 250 worksheets (and others) is a real problem for me.  Is =
<BR>>=20
there a SQL command that can be run every day at say 23:00 to perform =
a 250=20
<BR>> to send all data to the shops? <BR>> <BR>></FONT>=20
</BLOCKQUOTE></BODY></HTML>

------=

Posted by Ahmed Nashat on April 18, 2007, 8:24 am

Please log in for more thread options

: quoted-printable

locate this line

where Item.[LastUpdated] > getdate()-''23:00:00''', @database_name =3D =
N'HQSample', @server =3D N'', @database_user_name =3D N'', @subsystem =
=3D N'TSQL', @cmdexec_success_code =3D 0, @flags =3D 0, @retry_attempts =
=3D 0, @retry_interval =3D 1, @output_file_name =3D N'', =
@on_success_step_id =3D 0, @on_success_action =3D 1, @on_fail_step_id =
=3D 0, @on_fail_action =3D 2

Thanks Nashat,

I've looked at the script though and I can't find HQSample in it

Chris
Chris,

find attached the job script, please search in the script for =
HQSample and replace it with your database name, the job will run each =
day at 23:00 and it well send ONLY the items updated in the same day, =
you can remove the condition if you want the job to send all items

Nashat

> I'm sure this has been mentioned before, but I can't find it =
anywhere.
>=20
> People not doing 250 worksheets (and others) is a real problem for =
me. Is=20
> there a SQL command that can be run every day at say 23:00 to =
perform a 250=20
> to send all data to the shops?=20
>=20
>
------=_NextPart_000_000E_01C781C5.5456E5F0
Content-Type: text/html;
charset="windows-1256"
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-1256">
<META content=3D"MSHTML 6.00.2900.3059" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>locate this line</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>where Item.[LastUpdated] >=20
getdate()-''23:00:00''', @database_name =3D N'<FONT=20
color=3D#ff0000><STRONG>HQSample</STRONG></FONT>', @server =3D N'',=20
@database_user_name =3D N'', @subsystem =3D N'TSQL', =
@cmdexec_success_code =3D 0,=20
@flags =3D 0, @retry_attempts =3D 0, @retry_interval =3D 1, =
@output_file_name =3D N'',=20
@on_success_step_id =3D 0, @on_success_action =3D 1, @on_fail_step_id =
=3D 0,=20
@on_fail_action =3D 2</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Chris Allsopp - Connaught House" <<A=20
=
A>>=20
wrote in message <A=20
=
96@TK2MSFTNGP05.phx.gbl</A>...</DIV>
<DIV><FONT size=3D2>Thanks Nashat,</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I've looked at the script though and I can't find =
HQSample=20
in it</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Chris</FONT></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Ahmed Nashat" <<A=20
wrote in=20
message <A=20
=
@TK2MSFTNGP04.phx.gbl</A>...</DIV>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 =
size=3D2>Chris,</FONT></DIV>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 size=3D2>find =
attached the job=20
script, please search in the script for HQSample and replace it with =
your=20
database name, the job will run each day at 23:00 and it well send =
ONLY the=20
items updated in the same day, you can remove the condition if you =
want the=20
job to send all items</FONT></DIV>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 =
size=3D2>Nashat</FONT></DIV>
<DIV><FONT face=3D"Century Gothic" color=3D#800000 =
size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>"Chris Allsopp - Connaught House" =
<</FONT><A=20
size=3D2>chris@connaught-house.co.uk</FONT></A><FONT face=3DArial =
size=3D2>>=20
wrote in message </FONT><A=20
face=3DArial=20
face=3DArial=20
size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> I'm sure =
this has been=20
mentioned before, but I can't find it anywhere.<BR>> <BR>> =
People not=20
doing 250 worksheets (and others) is a real problem for me.  Is =

<BR>> there a SQL command that can be run every day at say 23:00 =
to=20
perform a 250 <BR>> to send all data to the shops? <BR>>=20
<BR>></FONT> </BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>

------=

Posted by Richard on May 10, 2007, 10:48 am

Please log in for more thread options

Nashat,

I would be very interested in the full script, could you possibly send it to
me.

Thank you very much

"Ahmed Nashat" wrote:

> locate this line

> where Item.[LastUpdated] > getdate()-''23:00:00''', @database_name =

N'HQSample', @server = N'', @database_user_name = N'', @subsystem = N'TSQL',
@cmdexec_success_code = 0, @flags = 0, @retry_attempts = 0, @retry_interval = 1,
@output_file_name = N'', @on_success_step_id = 0, @on_success_action = 1,
@on_fail_step_id = 0, @on_fail_action = 2

> Thanks Nashat,

> I've looked at the script though and I can't find HQSample in it

> Chris

> Chris,

> find attached the job script, please search in the script for HQSample and

replace it with your database name, the job will run each day at 23:00 and it
well send ONLY the items updated in the same day, you can remove the condition
if you want the job to send all items

> Nashat

> > I'm sure this has been mentioned before, but I can't find it anywhere.

> >

> > People not doing 250 worksheets (and others) is a real problem for me.

> > there a SQL command that can be run every day at say 23:00 to perform a

250

> > to send all data to the shops?

> >