I am looking to sign off orders older than 3 months.. so using SQL how do you set the cut off date?
Ps in the code above are you hard coding that or did you sugest putting it in the strings part of the component
Thanks
Hey there..
Was wondering if anyone could help,
In my system - for all orders that are older than 3 months i want to sign them off..
so for exmple I have a date in table 1 and i want to loop round that table until i find a date older than 3 months, then i want to set the values of some...
Hey guys,
I am trying to search round a string such as:
abcdefghi(10)[11]
I want to grab the value 11 to store in my table, so i want to stop when i come to the fist [ to grap the value i think???...
I am not sure how to do this, has anyone any ideas...
Thansk in advance for your help
ferriec
Hi,
I have a table that stores documents in an image field.
There is a trigger on the table that fires when any updates are made to the other fields in the table. The triger builds up a message and sends an email using xp_sendmail. I want to attach the document that is stored in the image...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.