true

Eugene Elutin (5/24/2012)

---

It's pointless. You shouldn't rely on this.

You need to change your code (and coding practice)

Whenever you are using string datatype for date values, ensure that unambiguous...

+100

WiRL (5/24/2012)

---

Hello Michael,

I tried DECLARE email_cursor CURSOR FOR SELECT email, @job_detail = RTRIM(Job_name) +' '+ RTRIM(short_desc) FROM vw_expiring_jobs

but recieve an error stating I can't set variables within a CURSOR?

How else...

and please re-read the thread yourself - lowels reponse was to change the "query results to text" - which is nothing to do with a select to a grid (although...

can we also lose the 90s please - what is the correct parameter for that ?

I strongly resent your implications with the word "Nazi". Let's keep this civil and straight instead of even coming close to ad hominem attacks or using such ugly words....

then possibly your sql service account does not have permissions to run winrar.exe

without you telling us the error message i can only assume you don't have winrar command line installed

derek.colley (5/24/2012)

---

Hear hear!

We're all guilty of asking idiotic questions from time to time but not to know the basic fundamentals of your job, then lying about it on CVs? ...

+1 eugene, but also - check the default language of your login on the local machine - if you are in BRITISH rather than ENGLISH (which i guess godaddy may...

your command needs to look like

C:\Program Files\WinRAR\WinRAR.exe x -u "c:\import\PastaExportacao SGCTlocal - 4.01 - 20120523 112426 - T - 1118.rar" "c:\import\PastaExportacao SGCTlocal - 4.01 - 20120523 112426 - T...

that's correct

you can shrink...

oh and by the way, the irony of me clogging up the "active forums page" with a complaint about users clogging up the active forums page is not at all...

typically (and i'm not going into indexed views here) - views don't have indexes,...