YOUCH!!!! You might check your indexes. You have guids on these tables as the clustered index. Unless you have a process that defrags them daily I suspect your fragmentation is...

rs80 (4/4/2014)

---

Thanks Sean for your reply. The loading of the file is on a daily basis. The layout of the data isn't straightforward so it's difficult for me...

djj (4/4/2014)

---

Jason, I do not think that is the problem. However that might fix it.

I did a quick test

create table Props (mapparam varchar(20));

INSERT INTO Props values (44.01);

select mapparam from...

It would be REALLY helpful if you could provide ddl and sample with your posts.

I am not 100% certain what you are trying to do here but see if this...

rs80 (4/4/2014)

---

I'm wondering if the data from a sample csv file can be transformed and loaded into a table. I have attached a workbook where worksheet1 has the sample...

Well you gave us a bunch of data and said "here is my results". Results of what? Presumably a query.

The problem is that you have...

Pretty hard to tell from what you posted how to do this. I can think of 2 or 3 ways this might be done but it all depends on your...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

Why all the looping and dynamic sql to create inserts? From what you posted this looks procedural instead of set based. If you want some help to make this whole...

gedhinch (4/4/2014)

---

In response to your post Sean i haven't changed around the joins as i don't fully understand how they work yet i need to do a little more reading...

ChrisM@Work (4/4/2014)

---

SQLRNNR (4/4/2014)

---

Sean Lange (4/4/2014)

---

TomThomson (4/3/2014)

---

Steve Jones - SSC Editor (4/3/2014)

---

Revenant (4/3/2014)

---

Sean Lange (4/3/2014)

---

Greg Edwards-268690 (4/3/2014)

---

it was clear they had no idea what they wanted or needed.

But finish it by...

Greg Edwards-268690 (4/4/2014)

---

SQLRNNR (4/4/2014)

---

Sean Lange (4/4/2014)

---

TomThomson (4/3/2014)

---

Steve Jones - SSC Editor (4/3/2014)

---

Revenant (4/3/2014)

---

Sean Lange (4/3/2014)

---

Greg Edwards-268690 (4/3/2014)

---

it was clear they had no idea what they wanted or needed.

But finish it...

OCTom (4/4/2014)

---

This is my take on LINQ to SQL. I have found that it does not handle large data sets well. It can be slow. And, because you do...

You're where predicate here doesn't make sense.

The isnull is replacing NULL with a 0. And I don't quite understand the Like...

TomThomson (4/3/2014)

---

Steve Jones - SSC Editor (4/3/2014)

---

Revenant (4/3/2014)

---

Sean Lange (4/3/2014)

---

This is an everyday...