Forum Replies Created

Viewing 15 posts - 361 through 375 (of 1,473 total)

  • RE: Temp Table to Gather Data

    Glad you got it working ezlikesundaymorning-573799, but I'll have to follow up with a few comments as well. I fully understand your point of view that you are coming...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    December 1, 2009 at 8:01 am

    #1085827

  • RE: error 8180 - statement could not be prepared

    Hah, you're not kidding. It was like a 7 hour dry spell across all the forums I watch. I figured it had to be actually broken, that's way...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    December 1, 2009 at 7:20 am

    #1085778

  • RE: How do I group columns

    Welcome back. Just as a refresher, you might want to take a look over the article on posting sample data in my signature for any future posts.

    If you're going...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    November 30, 2009 at 8:06 pm

    #1085620

  • RE: Moving tables between servers

    You can probably hack something together with sp_helptext(which gives you the code of a stored procedure) or find a script online to do it.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    November 30, 2009 at 7:55 pm

    #1085619

  • RE: Moving tables between servers

    You can use SSMS to generate scripts for all the stored procedures and then execute it on as many servers as necessary. That's not doing it through straight T-SQL,...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    November 30, 2009 at 5:55 pm

    #1085606

  • RE: error 8180 - statement could not be prepared

    You're still using ODBC drivers coming the other way though aren't you? Via system DSN's? It's definitely not an exact match the article and you're probably right, it's...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    November 30, 2009 at 10:54 am

    #1085572

  • RE: error 8180 - statement could not be prepared

    Hrm... while your problem does not exactly fit this, it's a close enough parallel that the work around proposed for this might be worth trying.

    http://support.microsoft.com/kb/936223

    Is it an option to attempt...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    November 30, 2009 at 10:17 am

    #1085529

  • RE: Delete statement with joins

    I personally nest all update/delete statements to real data in transactions as well, just to be extra cautious.

    something like:

    BEGIN TRAN

    --Your Delete Statement

    ROLLBACK TRAN

    --COMMIT TRAN

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    November 30, 2009 at 8:58 am

    #1085473

  • RE: error 8180 - statement could not be prepared

    Is that the only error or is it followed by an error 107 as well?

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    November 30, 2009 at 8:56 am

    #1085469

  • RE: help add column of repeating numbers 123412341234

    Joe's code could also be made into one statement like this:

    update @rank_test

    set sales_man=

    CASE WHEN (id+3)%4=0 THEN 1

    ...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    November 30, 2009 at 8:50 am

    #1085464

  • RE: Query with MIN and MAX

    My pleasure Alan, thanks for the feedback.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    November 30, 2009 at 8:38 am

    #1085450

  • RE: Qty values for each day

    Unfortunately, I'll have to guess at what 'and so on...' means, but this should point you in the right direction:

    ; WITH

    t1 AS (SELECT 1 N UNION ALL SELECT 1...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    November 30, 2009 at 8:36 am

    #1085446

  • RE: Qty values for each day

    You should be able to use the same method, but the logic will get slightly more complex. Post back any specific questions if you have difficulty adapting it.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    November 29, 2009 at 10:56 am

    #1085148

  • RE: how to delete the duplicate records from a table?

    sherifffruitfly (11/27/2009)

    I'm no sql genius or anything, but is anyone concerned that the poster apparently has 2+ versions of the truth running around in his or her database?

    Besides the technical...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    November 27, 2009 at 10:29 pm

    #1085068

  • RE: Qty values for each day

    Very nice, and very close. A slight alteration will give you what you need.

    ; WITH

    t1 AS (SELECT 1 N UNION ALL SELECT 1 N),

    t2 AS (SELECT 1...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    November 27, 2009 at 10:20 pm

    #1085066

Viewing 15 posts - 361 through 375 (of 1,473 total)