I was a lawyer, and before that, I worked in television production, directing local newscasts and such. I worked my way through college as a sound engineer and lighting technician...

imranx101 (10/26/2011)

---

Hello All

New to this forum. Exciting!

I can develop basic reports in SSRS and been using it for few months. Now I have a query.

Lets say I need to create...

JD Gonzalez (12/27/2010)

---

Got it! I had to change the SRID in my variable to match the one in the data.

set @geo = Geometry::STPolyFromText('Polygon((40.315260 -75.329130,40.308720 -75.320540,40.297590 -75.310240,40.264330 -75.357620,40.293660 -75.389210,40.327300 -75.372900,40.326910...

See the following from BOL:

If two spatial instances do not have the...

I second the suggestion that you confer with your own lawyer about your obligations and potential liability around signing such a statement. The company's lawyers represent the company, not you...

Mr. Holio (9/30/2011)

---

Hi all,

I'd like to add new / tune existing indexes on a specific table in order to achieve some performance improvements.

The problem is that the time stats returned...

wolfkillj (9/30/2011)

---

I certainly sympathize with you for having to work with suboptimal requirements with no ability to change them!

Do you really need the hyphen separators when you convert @inDDMMYYYYHHMMSS to...

I certainly sympathize with you for having to work with suboptimal requirements with no ability to change them!

Do you really need the hyphen separators when you convert @inDDMMYYYYHHMMSS to @TextDate?...

marty.seed (9/27/2011)

---

We have many reports that our users export to excel and perform additional filters, often times when the report is exported columns that seem to be perfectly lined up...

RichardBo (9/27/2011)

---

Thank you for your thoughts. It seems that there isn't an easy way to validate a date within a function (if ISDATE doesn't work for you). The CLR solution...

Well, since you can't use a TRY-CATCH construct in a user-defined function and you can't use SET DATEFORMAT in a user-defined function, either, what about setting up the code that...

Unless I missed something or the OP left out some information,...

Using a scalar function in SELECT statements like this also tends to slow things WAY down because SQL Server has to call the function separately for each input parameter value....

Tom.Thomson (9/15/2011)

---

DugyC (9/15/2011)

---

Great question, but I got it wrong because I jumped too quick and didn't properly think it through.

I deliberately chose 1222 because it "Returns the resources and types...

Tom.Thomson (9/14/2011)

---

Since a correct answer wasn't possible (I though "insert into cuss2 returns an error" and "insert into cuss2 doesn't return an error" couldn't both be ticked, that would be...