Any sql nerds want to help me figure out how to upload 5 flat files as one table in ssms? - someone who isnt good at sql

Posting as :
works at
You are currently posting as works at

Chat gpt is a different app

like

i would upload them as 5 separate tables and then create a new table to union them all.

also, in all seriousness, chatgpt is really good at this sorta thing.

like

UNION is likely your friend. Alternatively, or as part of a crazy process, so might UPDATE TABLE be...

like

also be thinking about the reason you would append data sets like that. do they have same columns? or will roll up for something else etc

like

Ooh! I've actually had data come from different resources like this. If you are centralizing contact data from Marketo (prospecting), Salesforce (sales), website, POS (retail location), and service record (siebel/SAP). Needless to say, this moved from a consolidation problem to an ID management problem. I wouldn't recommend solving anything like I did. This should have been a budget request for an ID resolution package, then stage each set, clean and standardize each, then assign the ID, and then join like a champ.

I would combine the flat files as one file in excel first. This tutorial seems helpful! https://learn.microsoft.com/en-us/sql/relational-databases/import-export/import-flat-file-wizard?view=sql-server-ver16

doesn’t work if the files are millions of rows.

Thanks all!

Temp tables

Related Posts

Please help me to get 11 likes.

like

Hi fish! Looking for a recommendation for an online ad builder program where people can easily build marketing collateral like fliers, posters, letterhead, etc. through templates. Suggestions?

Started at my first agency 3 mo. ago. I’m doing great work on exciting clients, but I often feel uninspired and drained. Is it growing pains or is this the wrong industry for me? How will I know?

like

Need referance for ReactJs developer position.
1 year experience in React.

like

What’s the culture like at Waystar Royco? Its an UMM fund focused on media

likefunny

Been at the company for a year - switched teams at my 7th month mark. My annual review is coming up. How do I negotiate for a raise/promo?

like

Hello fishes,

I'm a Senior system engineer completing 2 YOE but working on UI/UX designer role. My salary is equal to service ticket support role and not relevant to ux designer role. Please suggest what should I do.

like

What is avg salary for 5yoe java fullstack dev in UAE

Spec Ad: Olympia Beer
Slogan: Powered by Mystic Clearwater
Headline: It’s the Water. What is the Water?

Post Photo
like

I thought the power reserve on DJ41 Ref126333 was about 70hours, but I noticed it’s about 40-48 hours on mine. Wear mine about every other day, but not on weekends and then Monday morning when I go to wear it, it’s dead and have to wind it. Anyone else seeing this?

like

Hi Folks. I have the below offers.

@Harman: 23.4 LPA fixed + 1.88 LPA variable (total ctc 27 LPA). Client side Mercedes Benz. WFO.

@Accolite: 26.5 LPA fixed no variable + 50k JB. (Total ctc 28.34 LPA) Fidelity client.

@Nihilent: 24.56 LPA fixed + 2 lacs variable + 1 lac JB. Work location is pune & I need to shift from bangalore to pune.

YOE: 9y9m Role: Scrum master

Kindly advise and provide your opinions as to which would be a better deal in terms of company benefits job security & WLB

like

Does anyone know of any non profit companies (for loan forgiveness purposes) that offer at least part time, if not full time, telemedicine work? I know this is a long shot but I have been very curious if such a thing exists.

like

Anyone ever take a biotin or hair supplement to combat thinning hair. Would love ideas.

like

For all the 🐠 that switched from consulting to product, which role provided you with more tangible skills? I know I’m making some broad strokes here, but thought it might open other discussions as well

like

What’s the wait time on a Sub? Have been waiting for 6 months on my AD, but still nothing.

like

Any bi males here who have struggled with “being taken seriously” by both the hetero & LGBTQ+ community? In the process of interviewing for a new company and feeling the familiar anxiety around coming out at work creeping up.

like

Hi all, I just had my first round interview for a non-tech L7 role and made it to the next round. I’ll keep you posted but DM me with any questions in the meantime.

like

Is anyone here a member of Equinox Sports Club in West LA? Curious how crowded it gets, particularly in the evenings around 8.

like

Additional Posts in Data & Analytics Consultants

Anyone use Cloudera? What has your experience been like?

What’s so good about the Georgia Tech OMSC and OMSA? Is it just the cost? Seems to be recommended by most of reddit

likehelpful

How hard is it to get an interview for SWE at FAANG outside of on campus recruiting? I’m in GT’s OMSCS program right now, hoping to take advantage of career fairs this fall, but I don’t know if I’ll have enough time to prepare for the technical interviews before then. I’m worried about missing out on the recruiting opportunity and having to resort to applying online/LinkedIn afterwards. Any insights into this?

like

Is 128k a fair base salary for Consultant in Deloitte Analytics & Cognitive. MS CS and about 3 yrs experience. In one of the fastest growing but midtier tech cities in the US.

like

Do any of the top consulting firms have analytics roles (preferably not super technical) that don’t require weekly travel?

Any conda users in here have to install a binary and use conda forge? Need some help installing pdftotext. Throwing a weird message saying “Found conflicts!” Any and all help would be appreciated.

like

I was hired a few months ago by D to do data science. I am not doing data science currently, is there a way I can switch roles internally? Should I talk to my coach? Or should I just start looking for a new job. I’m starting to feel that the field is so hot rn my small stint at D won’t be a big deal to other firms.

like

Have you ever failed to deliver? What was it and why?

like

Hi! Does anyone know what kind of knowledge is needed to crack the Data Scientist interview at Google?

I'm currently working in Marketing Analytics (primarily using SQL and a bit of pyspark). Apart from mastering SQL, I wanted to know from people working at Google what does it take to get there as a Data Scientist? (I'm very interested in Strategy Ops)

I plan to another 6-8 months in preparation and upskilling myself before I even apply.
Any help and guidance is appreciated! Thanks :)

like

I am currently working mostly in Data Analytics, but I want to transition into Data Engineering. I've applied to a couple Data engineer positions but it seems I don't have the qualifications for them. Should I maybe look for Jr. Data Engineer positions to get experience and try to move up from there? If so anybody know of any Jr. Data Engineer positions available?

like

Can anyone from Deloitte provide anymore insight to the differences between the Applied AI and Strategic Analytics divisions within GPS? I am in the data analytics and science space and have had two separate recruiters reach out. Thanks

like

Anyone know of an alternative to StackOverflow for asking tech questions? The community is super toxic and I'm looking for a place I can casually ask questions that might seem dumb without being hrangued for not providing an essay proof of the research I've already done. Or some sort of buddy system where I can ping a person of relevant experience those questions. It's better to poke someone's brain for a minute than to spin in circles reading docs/dead end articles sometimes.

like

today I choose violence

Post Photo
funnylikesmartuplifting

Single book recommendation for user research?

Goal is interview prep. Ideally focused on applications in tech.

like

Noob question - I want to consolidate the dates into a single dates column. Would numpy or pandas help me reorganize this dataset effectively or should I do it within excel?

Post Photo
like

Anybody interviewed for a data engineer role for Facebook? I have a SQL and Python coding interview next, any idea on what to expect?

like

In the most unnecessarily complicated phrasing worthy a dissertation, what are you working on this week?

like

Anyone who has done masters in business analytics Singapore? Could you help on courses, Scholarships and careers and jobs. Looking for help.

Looking for an entry-level data analyst position in the DC area. Have a BA in economics & certification in Computer Science. Also 3 years of professional work experience as a full time marketing manager which I performed while attending school full time. I’m a self-starter and extremely driven. I also have a passion for data and statistics, and plan on pursuing my MS in data science within the next year. Please let me know if you know of any positions! Thank you.

like

How should I move to tech as a ML Engineer? How did people here make the transition?

likehelpful

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal