Forum Replies Created

Viewing 15 posts - 286 through 300 (of 1,473 total)

  • RE: Calculations error: aggregate may not appear in the set list of an UPDATE statement

    Let's back up a bit and take this one step at a time. The 3 part update is a very complicated concept and trying to pull it off without...

    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]

    March 4, 2010 at 4:03 pm

    #1128854

  • RE: Error Handling in SQL 2000

    Out of curiosity, what does this table with 900 fields hold? (Or maybe a better question would be what doesn't it hold)

    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]

    March 3, 2010 at 5:41 pm

    #1128185

  • RE: Help with SUB query

    I know you can use parameters in Excel (or at least you could in older versions, not sure about the newer ones), but I can't remember quite how to do...

    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]

    March 3, 2010 at 3:44 pm

    #1128141

  • RE: Calculations error: aggregate may not appear in the set list of an UPDATE statement

    I appreciate the effort, but unfortunately that isn't quite what I need. The concept of creating the table and the inserts are perfect, but I need that for starting...

    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]

    March 3, 2010 at 3:38 pm

    #1128137

  • RE: OPENROWSET showing NULL for numbers

    Does this setting also take care of using DTS to import spreadsheets in situations where you have a column that looks like this:

    A

    ___________

    A

    AB

    ABCD

    ABCDE

    ABCDEF

    Or maybe the same thing with numbers, don't...

    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]

    March 3, 2010 at 10:48 am

    #1127944

  • RE: Help with CASE statement in my query

    Magy,

    In your original, you're looking for values between '2006-01-01' AND '2007-11-15' for 2006. Is there some significance to that?

    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]

    March 3, 2010 at 10:38 am

    #1127940

  • RE: TRICKY SQL QUERY

    I haven't read the one Chris mentioned, but I would recommend these:

    http://www.amazon.co.uk/Microsoft-Server-T-SQL-Fundamentals-PRO-Developer/dp/0735626014/ref=pd_sim_b_7

    http://www.amazon.co.uk/Inside-Microsoft-SQL-Server-2008/dp/0735626030/ref=pd_sim_b_3

    http://www.amazon.co.uk/Inside-Microsoft-Server-2008-Pro-Developer/dp/0735626022/ref=pd_sim_b_3

    That said, all of the books we just linked target SQL Server 2008. Although the fundamentals books will...

    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]

    March 3, 2010 at 9:46 am

    #1127894

  • RE: Pivot query

    Nice to see you too Lynn.

    Things have been fine, I've just been really busy. Too busy working to post during the day, too busy playing CoD4 to post at...

    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]

    March 3, 2010 at 9:37 am

    #1127889

  • RE: Pivot query

    Check the article in my signature about crosstabs/pivots. It explains how to make a crosstab query which will work in 2000.

    Also, you might want to take a peek at...

    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]

    March 3, 2010 at 9:23 am

    #1127878

  • RE: Help....Hard to explain problem!

    As Vijay said, sample data / table structure is helpful for things like this. (See the article in my signature on providing sample data for tips on how to do...

    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]

    March 3, 2010 at 8:21 am

    #1127812

  • RE: Calculations error: aggregate may not appear in the set list of an UPDATE statement

    No need to apologize, I wasn't trying to give you a hard time, merely noting it.

    What you should basically have is something like this:

    CREATE TABLE A(

    Field1 int,

    Field2 datetime,

    ...

    )

    CREATE TABLE B(

    Field1...

    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]

    March 3, 2010 at 7:36 am

    #1127765

  • RE: Query Execution Time Variance

    Are most of the records 2's?

    Run this:

    SELECT IntRateCode, COUNT(*)

    FROM yourtable

    GROUP BY IntRateCode

    Post the result.

    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]

    March 2, 2010 at 6:55 pm

    #1127488

  • RE: Calculations error: aggregate may not appear in the set list of an UPDATE statement

    This is still very ambiguous. The article in my signature titled 'How to Provide Sample Data' explains how to make this a lot more clear for us, but I'll...

    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]

    March 2, 2010 at 6:36 pm

    #1127486

  • RE: Calculations error: aggregate may not appear in the set list of an UPDATE statement

    Are you attempting to use a 3 part update on a table variable that includes a SUM?

    You can't do that: as the error message says, you can't use aggregate functions...

    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]

    March 2, 2010 at 1:30 pm

    #1127387

  • RE: Installing SRSS 2008 on

    From what I've read, SSRS 2008 will run off of a 2005 database.

    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]

    March 1, 2010 at 3:47 pm

    #1126760

Viewing 15 posts - 286 through 300 (of 1,473 total)