tacy.highland (7/19/2012)

---

Ok, here's the sample data with the varchars:

CREATE TABLE #Schedules_RC

(

Route INT

...

What error(s). All you gave us was this: In VS when I have a query like this it ask me for the dates,...

jbnv (7/19/2012)

---

Lynn Pettis (7/19/2012)

---

One, you are still generalizing when you say "Americans are stubborn about pragmatic change'. I'm sorry, but you could potentially say this about almost any group....

If you post some sample data in the format you are actually using, I can look at how things may need to change in my code.

Here is my suggestion. Build a map showing how the data from the source table maps to the target tables. You can do this using a variety of...

jbnv (7/19/2012)

---

You are really taking this personally. Like I said, I am not attacking any particular person or their views, just imploring that this is another case where a change...

Here is my take away from all this. Read slower, you (meaning me) may catch things you may other wise miss.

In general, it is a good idea to start...

Then I found this (lost between a couple of other posts, and I just missed it):

CREATE TABLE #mytable

(

...

Or is this what you are talking about? Not sure how I missed it.

Declare @Schedule table (Starttm datetime, endtm datetime)

Insert @Schedule values ( '2012-02-16 02:00:00', '2012-02-16 04:00:00')

...

tacy.highland (7/19/2012)

---

I'm confused.

I followed the instructions listed in the Best Practices link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

And posted the code yesterday at 834pm. Aside from the Set Identity statements (which do err out) it...

tacy.highland (7/19/2012)

---

I did provide sample data yesterday, though not much. Capn's data was essentially the same anyway. And the sample data actually was in the smalldatetime format, so...

If you haven't gotten any data loaded into this column yet, I'd consider dropping it and recreating it with the varbinary(max) data type. You may also want to consider...

Here is the problem, I don't know. You didn't provide any DDL or sample data for this problem. The sample data I used was provided by capn.hector.

If you...

jbnv (7/19/2012)

---

Chris.C-977504 (7/19/2012)

---

jbnv (7/19/2012)

---

You don't know me....

tacy.highland (7/19/2012)

---

This is great stuff. Thanks everyone for your contributions.

I have another question now. Since we've been using smalldatetime as the startime and endtime format, (but...