Technically you do not need the DLL at all, even in the first place. When you build and deploy a SQL CLR project from Visual Studio the assembly is serialized...

I agree, but I would choose to use ORIGINAL_LOGIN() instead of SUSER_SNAME() to provide for cases when impersonation is employed.

A cross-tab query should do what you need, PIVOT will too, although cross-tabs are generally accepted as the better performer. Here is a great article explaining and comparing the two:...

Grant Fritchey (4/20/2011)

---

Stefan Krzywicki (4/20/2011)

---

opc.three (4/20/2011)

---

Stefan Krzywicki (4/20/2011)

---

I went to the latest SQL Server Saturday in Boston and had a great time. I'm mentioning it now because I've been using...

What about something along these lines?

SET DATEFORMAT MDY ;

DECLARE @date DATETIME ;

SET @date = '2011-03-01 13:10:29.817' ;

SELECT CONVERT(VARCHAR(30), @date, 101) +

RIGHT(CONVERT(VARCHAR(30), @date, 0), 7)...

Indeed, nice catch!

Syed Jahanzaib Bin hassan (4/20/2011)

---

MetaData should be MS SQL Server 2005 or Later because SQL Server 2000 is not a schema base database

and use this new JDBC driver 2.0 by...

I'm thinking it could be as simple as launching Task Manager and examining the...

That's the same article I linked to above.

So my present understanding is that the...

Nothing personal...I do have qualifications, I just don't display them on my shirt sleeve (or in my forum signature). What's in a qualification anyway?

Syed Jahanzaib Bin hassan (4/20/2011)

---

There is no 32bit Native client install on the 64bit OS and 64bit SQL Server installation,There is only 1 Native client available in the DSN window......

From MSDN http://msdn.microsoft.com/en-us/library/ms131321.aspx

You can run processes in 32-bit mode on a 64-bit server. In...

Here's how I usually do it:

SELECT SYSTEM_USER -- should show me

EXECUTE AS LOGIN='login_to_test' -- allows me to impersonate the test login's security context

SELECT SYSTEM_USER -- should show login_to_test

-- test the...

Syed Jahanzaib Bin hassan (4/20/2011)

---

Is your OS 32-Bit,Installation of SQL Server 2008 is same for both bits,it will automatically check the OS then install the required version,Its depend on the...

Stefan Krzywicki (4/20/2011)

---

I went to the latest SQL Server Saturday in Boston and had a great time. I'm mentioning it now because I've been using a little trick I learned...