????????

That is controlled by the link to the table. The information about how the link is done is stored in the access application and not on individual PC's. ...

royce.bacon (3/3/2010)

---

The definition of the ODBC source defines whether to use Integrated authenitication or SQL Server authentication on the second tab.

If you have specified Integrated and it displays an error...

nm, i used group 2's group on field and it works. in this case it would be values in column C.

Thank u!

I am...

lmu92 (1/22/2010)

---

Maybe something like this?

Note 1: I used the tally table as described in the related link in my signature to generate the weeks

Note 2: You may notice that this...

lmu92 (1/22/2010)

---

What would be Week one for this year?

Either from 01-02 (Fr - Sat) or 03-09 (Sun-Sat)?

Or, to phrase it a little different:

What needs to be the first day of...

wow this works but there's so many AND's and OR's it's confusing trying to decipher it. thanks!

anyone?

WayneS (1/12/2010)

---

Thanks for letting us know how you decided.

Is there any particular reason for going this method - specially since there is a way further on down that is faster,...

WayneS (1/11/2010)

---

Try this.

-- if temp table already exists (failed previous run), drop it

if OBJECT_ID('tempdb..#test') IS NOT NULL DROP TABLE #test

-- simulate the table with the data in it.

-- NOTE how...

thanks everyone. this is really good stuff 🙂

That script returns the values into seperate rows. I need to return into 6 columns

It says NULL in the text file.

During my import, there is a section to check if the field is "nullable"...