Forum Replies Created

Viewing 15 posts - 1 through 15 (of 30 total)

  • RE: My XML skills are poor when querying SSRS

    Its seems to be multiple "DataSourceReferences" tags are there in the xml content which its failed to convert the value to Varchar(max).

    January 25, 2012 at 12:14 am

    #1438113

  • RE: displaying x y into 5x5 result set

    if you use cross-join then you will get desired result. Let me know if understand wrongly.

    January 25, 2012 at 12:09 am

    #1438110

  • RE: Index fragmentation.

    as said earlier, all details are in sys.Indexes.

    January 25, 2012 at 12:07 am

    #1438109

  • RE: Urgent help with T-SQL - good test!

    Hi

    Please give requirement in a simple english or otherwise a screenshot would be a better choice to make visual relationship amongst tables. I'm not very sure that i understand correctly...

    January 25, 2012 at 12:06 am

    #1438107

  • RE: Execute Stored Procedure with Select Statement as Input Parameters

    We can coalesce the input elements and use it in proc to get the data rather than using cursor. However answer to your question is No, because its unable to...

    February 9, 2011 at 10:38 pm

    #1284947

  • RE: Query for column to row.

    Lynn Pettis (12/28/2010)

    Not sure what you are talking about. The problem you are relating does not appear related to the OPs original question. I suggest posting in a...

    December 29, 2010 at 2:08 am

    #1267054

  • RE: Query for column to row.

    Is it possible to retrieve it in a single query? Please note i'm having dynamic values in the record... but fixed ten columns only

    I've just tried to create xml and...

    December 28, 2010 at 3:34 am

    #1266657

  • RE: GetDate() or CURRENT_TIMESTAMP

    Correct Jack, but its a discussion place and we are discussing it.,.. We did discussed some good information and also i benefited from new answers... 😉

    Current_timestamp is just a alias...

    December 27, 2010 at 3:49 am

    #1266395

  • RE: GetDate() or CURRENT_TIMESTAMP

    Jeff Moden (12/22/2010)

    Which code did you use for that test? If the answer is that you used the same code that you used before, the reason why it differs...

    December 22, 2010 at 7:28 pm

    #1265760

  • RE: GetDate() or CURRENT_TIMESTAMP

    SQLkiwi (12/21/2010)

    Mr Magoo was joking: in SQL Server timestamp is a mechanism for version-stamping rows. It has been renamed to rowversion in recent releases. So, the joke is that...

    December 22, 2010 at 7:24 pm

    #1265759

  • RE: GetDate() or CURRENT_TIMESTAMP

    SQLkiwi (12/21/2010)

    Mr Magoo was joking: in SQL Server timestamp is a mechanism for version-stamping rows. It has been renamed to rowversion in recent releases. So, the joke is that...

    December 21, 2010 at 10:34 pm

    #1265357

  • RE: GetDate() or CURRENT_TIMESTAMP

    mister.magoo (12/21/2010)

    I also don't care that much about portability - whenever I write a query it is on SQL Server and AFAIK there is no plan to remove GETDATE().

    I also...

    December 21, 2010 at 9:25 pm

    #1265345

  • RE: GetDate() or CURRENT_TIMESTAMP

    SQLkiwi (12/21/2010)

    vinothraj (12/21/2010)

    hmm.. Yep, but we may lose continuity.. so we have to keep long thread some time.. 😀

    Not that long. Be reasonable.

    Ok, i will remove some of the...

    December 21, 2010 at 2:45 am

    #1264961

  • RE: GetDate() or CURRENT_TIMESTAMP

    SQLkiwi (12/21/2010)

    vinothraj (12/21/2010)

    I dont know why its gets differs.. attached screenshot.. by the by, my machine is i5

    Do us all a favour and learn how to cut the quoted text...

    December 21, 2010 at 2:35 am

    #1264956

  • RE: GetDate() or CURRENT_TIMESTAMP

    Jeff Moden (12/20/2010)

    vinothraj (12/20/2010)

    Jeff Moden (12/17/2010)

    vinothraj (12/16/2010)

    I've checked elapsing time for each of those and got approximate time is less for current_timestamp than getdate().

    Is current_timestamp better? i think so....

    Please post...

    December 21, 2010 at 2:11 am

    #1264945

Viewing 15 posts - 1 through 15 (of 30 total)