Forum Replies Created

Viewing 15 posts - 526 through 540 (of 566 total)

  • RE: What else have you done?

    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...

  • RE: Adding extra columns in SSRS as expressions

    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...

  • RE: Geospatial help -- I've got to be doing something wrong here

    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...

  • RE: Geospatial help -- I've got to be doing something wrong here

    jun-1034733 (10/12/2011)


    As a geo newbie, I wonder that do I need to set SRID for geometry (not geography) data?

    See the following from BOL:

    If two spatial instances do not have the...

  • RE: witness statement

    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...

  • RE: Times stats are different for a query

    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...

  • RE: problem using ISDATE in a Function

    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...

  • RE: problem using ISDATE in a Function

    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?...

  • RE: Export to Excel without Merging Columns

    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...

  • RE: problem using ISDATE in a Function

    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...

  • RE: problem using ISDATE in a Function

    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...

  • RE: Question about move of bigint variable from one table into nvarchar variable in other table

    Grant Fritchey (9/14/2011)


    That depends, do you know that the values are unique across systems? If not, you will hit problems.

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

  • RE: SQL - Query takes long time to execute...

    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....

  • RE: Trace flag in deadlock

    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...

  • RE: INSERT INTO

    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...

Viewing 15 posts - 526 through 540 (of 566 total)