Gullimeel (7/3/2012)

---

Why everything is defined as nvarchar(50) like fiscalyear could be a smallint similarly others. nvarchar takes double space the corresponding varchar. You might need nvarchar for some columns for...

Lynn Pettis (7/2/2012)

Last I heard, D11 still is. Been almost 2 years since I left the district and I can't fully remember the how the tables relate any more.

I...

That would be a safe assumption, though we're not the ones...

Sorry for the delay, been slammed with other stuff today.

Query- Please ignore the syntax. I changed it to ANSI joins as a test and the query plan is...

Awesome! Worked like a charm. Comes back instantly now instead of the 5-6 hours that it used to take on the large data loads.

Thanks again for the help...

I think I'm just going to have to change one of the columns (almost happens to be one of the most selective) to nvarchar(50) so that I can create an...

Great thanks! I'll try these later today.

Unfortunately we really don't have control over the data we bring in for the most part and they can change data types and...

Well I certainly don't argue with you there, but unfortunately there are about 10 different types of systems that we get data from with all different data types, and nulls...

Ok, so that works, BUT, it isn't any faster than the other option using the cursor. I think the problem might actually be retrieving the data itself, not the...

That completely makes sense. I tried doing something similar earlier but I think I instead put both join tables within the subquery and so it came back with all...

*Smacks self in head*

I was thinking something in that direction but couldn't actually extract it. Worked like a charm.

Thanks!

Thanks for the reply.

The table schema will "usually" match, though there's no guarantee that it will, which is why I was thinking that I need to build the column list...

The code creates all the fields as varchar(20), though you could do an IsNumeric() check and then create the column as an int data type instead.

I added the user to the SQLAgentUser and SQLAgentReader roles and now it works. I figured datareader, datawriter and execute on the database would work. Though not a...

Michael Valentine Jones (8/30/2011)

---

Rogman (8/30/2011)

---

We don't really care if the value is numeric other than we are inserting the data into a column with a sql_variant datatype and want to...