Jeff Moden (1/6/2010)

---

Nice... I'm curious... why blog these instead of submitting them...

That is a new date/time data type introduced in SQL Server 2008.

Based on the sample data:

insert into users values ('john','doe','test@test.com','N') -- ID 1

insert into users values ('john','doe','test@test.com','N') -- ID 2

insert into users values ('jack','doe','test@jack.com','N') -- ID 3

insert into users values ('jack','doe','test@doe.com','N')...

Previous employer, Retail System was COBOL. When we started using SQL Server for reporting and other activities, we found it easier to complete updates on the SQL side then...

itsmeman (1/6/2010)

---

Say a user exists two times 'John Doe'.

Someone does a accounting review for a customer and a report is generated, there is a window when you search for...

Jeffrey Williams-493691 (1/6/2010)

---

Lynn Pettis (1/6/2010)

---

I don't apply those unless I have a problem that would be corrected by a CU. Those don't go through as stringent testing as the...

Now, based on the above, what should the final result look like?

A picture is worth a thousand words. Or, as I tell people at work, pretend I'm from Missouri...

To continue, I did write a blog about it Comparing Hardcoded functions, In-Line TVF's, and Scalar Functions

Not really sure. I just sort of stumbled on to this method of converting data. We used an scaler UDF to convert dates to a specified format for...

I don't apply those unless I have a problem that would be corrected by a CU. Those don't go through as stringent testing as the service packs (supposedly).

Doesn't...

I don't think it is by design. I have seen The Thread not show up in the Active Threads (recent posts) at times.

storm front, as one is on its way.

From BOL:

Adding a constraint to an existing column:

ALTER TABLE dbo.doc_exz

ADD CONSTRAINT col_b_def

DEFAULT 50 FOR column_b ;

katedgrt (1/6/2010)

---

... Being recognized as a sentient human with a contribution to make is all I'm asking for. Not special privileges, not affirmative action, not preferential treatment. ...