Search results for query: *

Have a pipe-delimited csv with 340k+ rows I'm importing into a staging table. It has 5 date fields, all in euro format dd-mm-yyyy, which I've defined as varchar in a staging table. I've written some t-sql which selects the data into a production table and converts the varchar dates into...

I have a cfinput autosuggest in a cfform which is used to populate a div and a grid in an adjacent tablayout. When the user first enters a min of two characters in the autosuggest, the autosuggest populates the drop down correctly from a query. The user makes a selection and hits the submit...

Thanks all for the wisdom of your experience. Would it help if I said the sheer volume of variables (and this is only a third of the columns involved!) is why I missed the in-loop fetch??? [wink] ESquared: I'd never opened the template explorer before. Thanks! SQLSister: I think I can see...

SQL2005, W2K3-SP2 I can't see why the cursor in this stored procedure won't move past the 1st row. The select statement hits a table with ~5k unique AuthorizationNumber(s). The while loop works because the @Count increments, but the other vars just sit on the first row. ------ ALTER...

in any case, what i didn't show in my example was that i had some grouping in the sql query, and that was causing the problem. also, my company's websense filtering doesn't seem to permit webform submissions to tech-help sites, hence the total lack of response from me.

thx all. for some reason, i couldn't post replies from work yesterday. i ended up solving it (more or less) with a CTE (I'm in SQL 2005): --the CTE definistion with finished as ( select Item from myTable where Status = 'FINISHED' ) --the accessor query select Item from myTable where Item...

Hi I have a table structured like this: Item Status ----------------- SN1 READY SN1 INPROCESS SN1 FINISHED SN2 READY SN3 INPROCESS SN4 INPROCESS SN4 FINISHED I need to be able to isolate the Items which haven't been FINISHED. In other...