Forum Replies Created

Viewing 15 posts - 2,236 through 2,250 (of 2,894 total)

  • RE: Single row to multiple columns

    I don't want to appear to be rude, but with 2,087 visits on this forum you definitely aware of how to post questions here. If not, link in my signature...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 17, 2011 at 6:05 am

    #1369530

  • RE: null to be managed

    Happy to help, but I wonder what scotsman has to do with RosAviaKosmos ? 😀

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 17, 2011 at 6:00 am

    #1369526

  • RE: null to be managed

    Please next time, test your code before posting so its runs without error!

    Also, you've created another thread for the same question!

    You have very strange requirements, but I leave it with...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 17, 2011 at 5:17 am

    #1369504

  • RE: Delete Everything (not really)

    If I'm right you want to search for something and replace it in every column in every user table.

    Ok, if you really determined, that is for you:-D:

    DECLARE @sql NVARCHAR(4000)

    DECLARE cupd...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 17, 2011 at 5:04 am

    #1369500

  • RE: Read from Exchange Mailbox

    checkai (8/8/2011)

    I want people in the field to be able to email a mail generic account with a client's ID number as the subject. Then have SQL generate a dataset...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 17, 2011 at 4:45 am

    #1369495

  • RE: a=b=c?

    SQLSandwiches (8/17/2011)

    ...

    As for commented code, do you guys enforce it in your workplace? I was able to use policy management for object naming but didn't find a way to enforce...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 17, 2011 at 4:32 am

    #1369494

  • RE: null for parent data

    Could you please clarify what you want top be displayed as: a.id a.name b.num

    There are no such columns in your sample table setup.

    But as general answer: most likely you...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 17, 2011 at 4:25 am

    #1369489

  • RE: Fulltext not working while i removed all words from noiseenu.txt

    Try to remove everything from the noise file you changed, will you see any effect for other words?

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 17, 2011 at 2:41 am

    #1369466

  • RE: Returning row count as output in CTE

    SELECT Col1 AS Column1

    ,Col2 AS Column2

    .....

    INTO #t

    You can see...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 16, 2011 at 8:35 am

    #1369116

  • RE: open query rolling dates

    Where?

    In Sql Server - Yes, you can. I'm sure you have a high chance that T-SQL will work there 😀

    But I'm not sure about Informix... You can try and...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 16, 2011 at 8:18 am

    #1369102

  • RE: Returning row count as output in CTE

    bwoulfe (8/16/2011)

    ...It's setup with temp table right now and the performance is just ok. I may just need to stick with a temp table but rewrite it...

    Using temp tables...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 16, 2011 at 8:05 am

    #1369094

  • RE: Returning row count as output in CTE

    How you want your count to be returned then?

    Returning the count in the column would be the best option, client app can read this value from first row and then...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 16, 2011 at 7:34 am

    #1369074

  • RE: nothing returning for date

    Vlad-207446 (8/15/2011)

    well the issue is not the start date but the end date.

    "31/12/2004" is not a valid date in SQL server unless the server default is set to a...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 16, 2011 at 7:20 am

    #1369064

  • RE: Returning row count as output in CTE

    Cadavre (8/16/2011)

    Is there any problem with just using @@ROWCOUNT ?

    DECLARE @RowStart INT

    DECLARE @RowEnd INT

    SET @RowStart = 1

    SET @RowEnd = 100

    ;WITH CTE AS

    (

    SELECT *, ROW_NUMBER() OVER(ORDER BY (SELECT...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 16, 2011 at 6:49 am

    #1369041

  • RE: Trigger to insert records on a linked server else in a local server

    kbsk333000 (6/23/2011)

    Hi,

    1. There is a plan to write a trigger on a table in Server1 which inserts records on a table in linked server Server2.

    ...

    I wonder what would cause you...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 16, 2011 at 6:28 am

    #1369034

Viewing 15 posts - 2,236 through 2,250 (of 2,894 total)