Forum Replies Created

Viewing 15 posts - 136 through 150 (of 1,473 total)

  • RE: Query Performance with multiple joins

    No way to tell from the information provided. Do you need all the joins? How many rows in the main table? It's possible you could carve the...

    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]

    April 29, 2010 at 3:04 pm

    #1160065

  • RE: How to Reference HTML Meta Tag in a Stored Procedure or Insert Query

    Sid Childers (4/29/2010)

    Garadin (4/29/2010)

    Sid Childers (4/29/2010)

    This client is stuck on ASP.NET 2.0, unwilling to consider 3.5/dynamic data because he feels that 2.0 can do the job. I'm afraid 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]

    April 29, 2010 at 11:38 am

    #1159943

  • RE: How to Reference HTML Meta Tag in a Stored Procedure or Insert Query

    Sid Childers (4/29/2010)

    This client is stuck on ASP.NET 2.0, unwilling to consider 3.5/dynamic data because he feels that 2.0 can do the job. I'm afraid it will be a...

    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]

    April 29, 2010 at 10:53 am

    #1159904

  • RE: comparing table schemas - query to return columns

    Refactoring that query a little bit:

    ;WITH

    T1 (Table1Columns) AS

    (SELECT name FROM DB1.dbo.syscolumns WHERE OBJECT_NAME(id)='Table1'),

    T2 (Table2Columns) AS

    (SELECT name FROM DB2.dbo.syscolumns WHERE OBJECT_NAME(id)='Table2')

    SELECT *

    FROM T1

    FULL OUTER JOIN T2 ON...

    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]

    April 29, 2010 at 10:41 am

    #1159888

  • RE: How to Reference HTML Meta Tag in a Stored Procedure or Insert Query

    You could probably improve it by actually making it dynamic =). Did they give you a reason they don't want data driven pages?

    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]

    April 29, 2010 at 10:30 am

    #1159879

  • RE: Removing Non-Alphanumeric Characters in a Query

    It's 2K =)

    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]

    April 29, 2010 at 10:26 am

    #1159875

  • RE: How to Reference HTML Meta Tag in a Stored Procedure or Insert Query

    By "moved", you mean manually deleted and hard coded into the other page?

    The hidden values need to match the values you want sent to the DB.

    Can you give an actual...

    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]

    April 29, 2010 at 9:43 am

    #1159831

  • RE: Linked server to Oracle - how to query?

    Does oracle handle schemas the same way as MS SQL? (Totally clueless about all things oracle)

    The other option to try might be:

    select * from myLinkedServer...[mySchema.myTable]

    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]

    April 29, 2010 at 9:40 am

    #1159827

  • RE: Removing Non-Alphanumeric Characters in a Query

    How about a function that goes in a utility database. That way you can just recreate the utility database when you upgrade the server and don't have to worry...

    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]

    April 29, 2010 at 9:36 am

    #1159821

  • RE: view always returning date time of enquiry instead of time creaed

    Two words. "Lookup Tables".

    As an example: Instead of that long case statement for sce_sclc, create a table in your database with 2 columns, such as sce_sclc and...

    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]

    April 29, 2010 at 7:13 am

    #1159648

  • RE: How to Reference HTML Meta Tag in a Stored Procedure or Insert Query

    It doesn't really work that way. You don't 'read' objects like that from SQL Server, you use the .NET page to send the data to the SQL Server and...

    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]

    April 29, 2010 at 7:05 am

    #1159638

  • RE: Trying to use variables in a view.

    As Lowell said, providing the code will allow us to help you refactor it or tell you a better way to go... but barring that:

    You can't use variables in a...

    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]

    April 29, 2010 at 6:58 am

    #1159626

  • RE: Removing Non-Alphanumeric Characters in a Query

    Why are you against using a function?

    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]

    April 29, 2010 at 6:54 am

    #1159623

  • RE: Query 5000 Tables for data

    You *may*, emphasis on *may* get better performance creating a bulk staging table where you copy all the data into... then create indexes on it, and run your queries off...

    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]

    April 16, 2010 at 4:11 pm

    #1153196

  • RE: Query 5000 Tables for data

    How much data?

    How often does it change?

    Is a snapshot ok?

    Are all the tables identical schema wise?

    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]

    April 16, 2010 at 3:23 pm

    #1153176

Viewing 15 posts - 136 through 150 (of 1,473 total)