SQLRNNR (2/4/2014)

---

Yes this is very possible but be concerned about some of the problems using Access as a front end could cause if not careful (new session created for each...

danawexler (5/10/2013)

---

here's a bit of information on rules of normalization: http://www.sqlservercentral.com/blogs/abhijit_desai/2010/09/07/noramlization/ However, in this case, you're looking at data that seems to have a clear relationship, so...

Sean Lange (5/10/2013)

---

slunt01 (5/10/2013)

---

I wish I could show screen shots for further help but I am unable to because of the company policies. I will try and post more details...

danawexler (5/9/2013)

---

are you creating one denormalized table using data from several views? i've done something like this recently and although it's labor intensive, it's not difficult to do. ...

I wish I could show screen shots for further help but I am unable to because of the company policies. I will try and post more details about it.

thank...

Ok awesome it seems to have worked.

just wondering what is the 112 doing at the end of the second code? I am just curious what the code is doing. (i...

WOW ok i will look at this some more when i have some tinker time.

THANK YOU for your help. I am really hoping this works. it would make it...

the table names are like AB_201201 then AB_201202 and so on.

there are a few variations of the AB but other than those few the only think that changes is...

ive looked at that...it seems like i would have to write the code to union things each time if i am not mistaken.

And i have 200 tables that...

ACinKC (5/23/2012)

---

I dunno...I think SSIS is the better tool for this kind of fixed-width import. Using the GUI to map out the columns for the input file (connection) is...

They call that "fixed field format" (along with some pet names) and you can either use a format file or you can load it in as a single string and...

awesome thanks you all! I really wish i had more time to explore these things... its mainly hit or miss.

Ill do some more playing and see what kind of...

I dont know what BCP is. 🙁

Jeff...

Still working on this. It is hit and miss I think I am getting closer.

I looked at doing a bulk insert but I couldn't figure out the code to...

ok what is a bulk insert?

See i told you i was new.

It seems like there is a million ways to do one thing.