Am I too late for the party? 😀

SELECTNum,

Chr,

REPLICATE(CHAR(65 + (Num - 1) % 26), 1 + (Num - 1) / 26) AS Peso

FROM(

SELECT1 AS Num, 'A' AS Chr UNION ALL

SELECT2...

Don't blame me. Blame rounding... 😀

The DATEDIFF/DATEADD is the only reliable way to get accurate results.

See what happens with pre-1900 dates using FLOAT method

DECLARE@Today DATETIME = '1898-12-31 23:00'

SELECTCAST(CONVERT(FLOAT, @Today) AS INT),

DATEDIFF(DAY, 0, @Today)

Paul White NZ (4/3/2010)

---

Few of issues with this one.

1. Relies on undocumented internal implementation details.

2. Only works with DATETIME - none...

Also asked here

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/d12f8277-d921-4c92-9f03-a7019678cd7e

I answered

SELECT CAST(GETDATE() AS DATE)

GilaMonster (3/28/2010)

---

I assume you mean 'clustered index', not 'primary key'.

The RID's there on all tables, cluster and heap. It's only used in nonclustered indexes if the underlying table's a heap,...

Please post your COMPLETE table structure, including triggers and keys.

All indexes too, please.

Then post your execution plan in "sqlplan" xml...

Paul White NZ (3/28/2010)

---

+1 for that.

All records do have a "hidden" record identifier,...

The good Lord allows you to jump in, huh Jeff? 😀

Short and simple

SELECTABS(CHECKSUM(NEWID())) % 1000000000

Thank you.

Now when I read the code, I see that the "/ 2" is not even necessary...

DECLARE@Sample TABLE

(

MarkPer CHAR(2),

StartDate DATETIME,

EndDate DATETIME

)

SET DATEFORMAT MDY

INSERT@Sample

SELECT'M1', '07/24/2009', '10/02/2009' UNION ALL

SELECT'M2', '10/20/2009', '12/18/2009' UNION ALL

SELECT'M3', '01/04/2010', '03/12/2010' UNION ALL

SELECT'M4', '03/29/2010', '05/28/2010' UNION ALL

SELECT'S1', '07/24/2009', '01/04/2010' UNION ALL

SELECT'S2', '01/05/2010', '05/28/2010'

DECLARE@Today DATETIME

SET@Today...

Are you sure, Jeff?

If you filter for the nullable/unique column

CREATE UNIQUE NONCLUSTERED INDEX UX_Table1 ON Table1 (Col1)

WHERE Col1 IS NOT NULL

You can have how many NULL's you want, but as...

david.c.holley (3/19/2010)

---

Is there a way to do this AND allow Nulls? In other words, the when the WindowsUserId is provided, it must be unique, but it may not exist hence...

Carlo Romagnano (2/19/2010)

---

The main problem is not the format of date (dmy or mdy or ymd) nor if monday is the first day of the week, but identify the day...