antonio.collins (1/7/2008)

---

if mcfarland is using that field as legal notation, then parent-child columns don't really help if the hierarchy exceeds two levels. using the legal notation column as an...

Since you have cracked your brains out, can you post your attempts thus far?

PS This has "homework" written all over it. While there is nothing wrong with that, if you...

My "Whahuh?" was directed at the OP, not your link. 🙂

I can't tell what they want to accomplish no matter how many times I read it.

Whahuh?

If I understand what you're trying to accomplish, it's pretty straightforward. Everything to the left of the period is the parent, so look for that.

Without actually seeing the code, my best suggestion would be to use INSERT/EXEC functionality to populate a temp table, and then combine that with the additional data that you want.

There...

While I agree with Kenneth that Isnumeric will likely solve your problem, keep in mind that it's borked, to put it nicely. If your data isn't too bad, it should...

You can't assign a non-deterministic value as the default parameter like that. Instead, assign it something like NULL, and then inside the stored procedure, set it to Getdate() if it's...

Maybe I'm misunderstanding you, but if not, the answer is one. A table can only have a single primary key constraint.

ETA: To be quite specific, it can also have zero,...

You need to alias your derived table.

Jeff Moden (12/22/2007)

---

I have to admit, I'm confused as to why the question was even asked... the OP had a "Last day of the Month" formula... surely it's an easy...

I'd also highly recommend reading this article[/url].

You still didn't tell us if there is a varying time value in the date_fld column.

If there is, I'd do this:

SELECT

*

FROM

tb1

WHERE

date_fld >= DATEADD(d,-2,DATEADD(mm, DATEDIFF(m,0,getdate()),0))

ANDdate_fld < DATEADD(d,-1,DATEADD(mm, DATEDIFF(m,0,getdate()),0))

and if not,...

Assuming that the date_fld has a datatype of datetime, are there varying times in the field, or are they all 00:00:000?

Since the rows you're inserting are based on the other table, lose the "VALUES()" portion of the query. The INSERT/SELECT method is what you need, and you seem to be...