Are they advocating that SCHEMABINDING is permanently removed? If so, I would seriously question why. I might temporarily remove it as necessary for certain modifications but there would...

I've never had any issues upgrading with the splitter using SCHEMABINDING. Is it your view? In any case, if SCHEMABINDING is causing issues, just remove SCHEMABINDING on the...

Dixie,

Thank you for fine-tuning Luis' code. I haven't had an opportunity yet to test his version but I will work on testing both versions. The number of records...

Luis,

Your code works. I shall have to see about extrapolating it to my actual data. I will agree that the original data structure is flawed but it's from...

Yes, I have already contacted the person that I get the data from to see if they are able to add a column with the row number. 🙂

Scott,

Other than the order of the rows themselves, there is nothing about the data that I can rely upon to order it. If I understand how the ORDER option...

Thank you, Phil. Not what I was hoping for, but at least I know. SSIS is not something that I'm familiar with (and little time to learn it...

o324712 (1/2/2015)

---

I need some help if someone is willing. I'm not a professional DBA however with Google as your friend anything is possible. My issue is that I have a...

Try the following out. It uses Jeff Moden's DelimitedSplit8K function which I didn't include. I highly recommend that you read the (absolutely awesome!) article on it (

I suggest you look at the RowSource and BoundColumn properties of each item. My guess is that you have some sot of ID field that is the BoundColumn. ...

L' Eomot Inversé (11/23/2011)

---

That explicit documentation doesn't give any explanation either. Since MONEY and DECIMAL and NUMERIC are all exact numeric types (see the Data Types topic in BoL)...

peter-757102 (5/13/2011)

---

Excuse me when I am wrong with this as I did not verified this myself.

This new function does returns one record when the input is NULL. Just from memory,...

Jeff, I believe the running total you are thinking of is...

AndrewSQLDBA (1/14/2011)

---

This is part of our website, and we want to be able to store the inventory, and recipes in one single database. Not having to try to keep multiples...

Have you thought about going the easy route and buying a software package? It looks like there are several nice ones for around $30-$35. It's your choice but...