Vizzini: HE DIDN'T FALL? INCONCEIVABLE.

Inigo Montoya: You keep using that word. I do not think it means what you think it means.

when ever i see that word...

Lynn Pettis (4/24/2012)

---

Kiara (4/24/2012)

---

Grant Fritchey (4/24/2012)

---

Kiara (4/24/2012)

---

Lynn Pettis (4/24/2012)

---

Nope, too much fun watching now. I can even answer his question on why he keeps getting the...

what happened to '2012-04-29 10:00:00','SOME TEXT' ? or do you want only from table 1 thats not duplicated in table 2??

The Dixie Flatline (4/24/2012)

---

I'm getting a smile this morning just from hearing about a train wreck in the distance. They are much more fun when you don't...

not a problem some times it helps to post on the forums and something we say causes the lightbulb...

as vinu said about the "master" tables. many players can play on a team and a player can play on many teams (not at the same time but could...

did you change the table names. you should have gotten 2 errors if you just ran my query

EDIT: ...

shani19831 (4/24/2012)

---

Ya its giving me weird results but I'm working around it, i will also...

the op might also want to do the following

WHERE CASE WHEN Bla is true then foo > bar ELSE bar < foo END

maby this?? since we need some way to make them distinct add a row number to it then do a full outer join. now only the differences will...

EdwinGene (4/23/2012)

---

I have a query in which a column may or may not be compared to a value in the WHERE clause.

I know how to do this using dynamic sql....

Lynn Pettis (4/23/2012)

---

What I like about my code is that I made the Identifier column a computed column in my test Calendar table. Makes the column dynamic, it updates...

Lynn Pettis (4/23/2012)

---

capn.hector (4/23/2012)

---

Lynn Pettis (4/23/2012)

---

capn.hector (4/23/2012)

---

Lynn i continue to learn from you. my kludge looks awful compared to the datemath you did. {facepalm} for not realizing i...

i find when im doing database design to just start writing every thing on paper. i start with the information i want to store first (players, teams, game stats)...

Lynn Pettis (4/23/2012)

---

capn.hector (4/23/2012)

---

Lynn i continue to learn from you. my kludge looks awful compared to the datemath you did. {facepalm} for not realizing i could just add...