SYSTEM_USER is available in a trigger, just enable kereberos delegation on the application pool running under IIS so that the IIS server authenticates the web user to the sQL server...

Hugo Kornelis (5/10/2012)

---

I'm sure people will find some issue with the above version as well, but at least I think I have dodged the issue that has confused jalvarocrespo, Tom,...

WayneS (5/10/2012)

---

Excellent question Mark. Actually, in the Qtr column in the CROSS APPLY, I use this calculation to determine what the month number is at the beginning of the quarter...

And now of course... after reading the explanation to Tom, I understand my mistake at reading but not trying to fully comprehend the question. 🙂

Koen Verbeeck (5/9/2012)

---

Good question, learned something.

However, the question itself was a bit weird to read (at least for me, a non-native English speaker). I had to read it a few...

I don't get how DATETIMEFROMPARTS can tell if I want the first day of the quarter, or the first day of a month based on the portion of the article...

Good question... thanks!

I saw a CREATE UNIQUE CLUSTERED INDEX on a Nullable column (ID2), and said no based on that.

Why not start a project to move the data into a single database?

The Oracle downloaded data could be put into one schema, and each developer or whatever is necessary could...

Bob Cullen-434885 (5/4/2012)

---

Got it right! Seems I was paying attention during the Always On session at SQLBits, after all!!

But from my perspective, the most serious disadvantage is that to take...

Koen Verbeeck (5/3/2012)

---

mtassin (5/2/2012)

---

cderosier 16389 (3/22/2012)

---

I have installed the 32 bit providers. I get an error when trying to install the 64 bit. It tells me that I have to...

aaah jeez... that will teach me...

I had a bunch of little queries at the end of my little window of SSMS

stuff like

SELECT CAST(DATEADD(n,DATEDIFF(n,0,'9999-06-05 21:13:49.907'),0) AS TIME)

Next time I'll remember to...

Lynn Pettis (5/3/2012)

---

I know others have already said this, but I'll stress it again. Jeff does show how to pull actual data, but when we ask for sample data,...

Hmmm it's not working for me though when I try to make it work with my table.

Table

CREATE TABLE [dbo].[ScreenViews](

[UniqueID] [int] IDENTITY(1,1) NOT NULL,

[UserName] [varchar](30) NOT NULL,

[ScreenName] [varchar](30) NOT NULL,

[TimeStamp] [datetime]...

That's pretty crafty,

I submitted it as a bug to connect. I like the work-around, but I believe they should have used a bigint instead of an int for...