Another question: Does anyone write T-SQL queries using non-ASCII characters?

Maybe. How are you cooking them? ANSI or ASCII?

It boggles the mind, eh?

ALZDBA (4/13/2009)

---

did you test this ?

Select datediff(dd, dateadd(mm,-18,getdate(), getdate)

i.e. determine the number of days ( dd ) between the getdate minus 18 months (12+6) and the current date.

It will not...

1.5 years is 547 or 548 days, depending on how you want to count it.

Bob Hovious (4/13/2009)

---

It's not a big deal, Steve. Folks have been referring to Flo as "she/her". I swapped a few cordial posts with Flo...

From the drop down box select constraint and expression (I hope that's the correct wording)

In the text box, enter:

@[your_variable] > 0

Replace your_variable with the name of your variable.

You could add a script block inside the Foreach container that increments a variable on each pass.

Y'all making want to attend the conference. I may get the chance to attend the conference for free but that does not include travel, lodging, or food. Being...

Well said.

Now if I could get Kalen to agree too I'd feel extremely safe. 😀

GilaMonster (4/11/2009)

---

That's often...

oops, I guess I forgot. I did use GOTO with VB6. (On Error Goto ______)

Thanks Bob. FYI, you're doing the presentation next month....

I didn't even realize GOTO was part of T-SQL. I think the last time I used it was on a Vic-20.

I hope that I would never use GOTO in SQL code.

If you have to use that kind of logic then you might want to use stored procedures and use...