Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Peager

    To normalize or not to normalize?

    It looks like you are trying to support a 'many-to-many' relationship structure. I would go with the first choice as, even though it will require more 'relationship' tables, it will be cleaner to code against. I believe you will also find it cleaner to implement relational integrity with that...
  2. Peager

    How to force table cell alignment in a SQL Query for XML...

    We are using SQL Agent to send an e-mail via sp_send_dbmail. sp_send_dbmail has the ability to generate an HTML body to the message.
  3. Peager

    How to force table cell alignment in a SQL Query for XML...

    Wow! And I thought I was pretty good at understanding TSQL code. Yes, this exampled does handle alignment. Now if I can just boil it down to something I can get my head around. Many thanks, Paul
  4. Peager

    How to force table cell alignment in a SQL Query for XML...

    ...'', td = wo.OrderQty, '', td = wo.DueDate, '', td = (p.ListPrice - p.StandardCost) * wo.OrderQty FROM AdventureWorks2008R2.Production.WorkOrder as wo JOIN AdventureWorks2008R2.Production.Product AS p...
  5. Peager

    Shredding XML in an SQL column returned to a report.

    Geoff, Thank you for your response. I knew I could get there that way but I found some 2005 MS documentation that led me to believe it could be done the other way and, with painfull persaverance, I found that it could! First of all, the somewhat helpful docs...
  6. Peager

    Shredding XML in an SQL column returned to a report.

    I have a data source to an MS SQL data base that returns an XML datatype column along with a number of other columns I'm using in my report. Is there an elegent way to shred this column with Reporting Services or will I best shred it on the SQL side and return it in a separate data set? Best...
  7. Peager

    SQL Agent - Schedule for 1st Business Day in month.

    I have a need to schedule an SQL Job for the first 'business day' in a month. This would be Monday if the 1st fell on a Saturday or Sunday. Of course holidays also have the potential to mess this one up big time. My only thought was to create 12 '1st day of ...' schedules and update them...
  8. Peager

    SQL Opinion needed.

    OK, I got it working... now we just have a small Kerbos problem which my network guru says he can handle. I did run into a bit of quirkieness that everyone should know about. When using the aliases for Target (T) and Source (S) I found that the order of the fields in the WHEN MATCHED clause...
  9. Peager

    SQL Opinion needed.

    George, is this what you were suggesting? IF DB_NAME() = 'MC_Live' CREATE SYNONYM MFServer FOR [MobileFrame].[dbo].[PPTKTHD] IF DB_NAME() = 'MC_Training' CREATE SYNONYM MFServer FOR [MCSQL2008R2].[MobileDev].[dbo].[PPTKTHD] MERGE MFServer AS T -- Target.... -- This is the record...
  10. Peager

    SQL Opinion needed.

    Thanks George, I'll look into it.
  11. Peager

    dynamically enter records

    ...a CSV string and use a 'split' function to parse them into a table, inserting those values along with your other parameters into your DB. [code] /* ============================================= Author: Paul Richmond Create date: 02/06/2008 Description: Converts a Value String into a...
  12. Peager

    SQL Query to read two prces from table.

    ...that will perform the pivot table. @Lengths holds the -- dynamic part of the script used to determine the columns. SET @SQL = 'SELECT * FROM (SELECT Product, nLen, Price FROM #PrcTbl) AS PT PIVOT(Avg(Price) FOR nLen IN (' + @Lengths + ')) As P'; -- This executes...
  13. Peager

    SQL Opinion needed.

    I have an environment where our live database, (MC_Live), gets backed up and restored to a development environment, (MC_Training), periodically. In this database, there are some stored procedures that update a second database via a linked server connection. When working in MC_Live, we want to...
  14. Peager

    How to find an API_Cursor definition.

    I have a development environment that talks to MSSQL through a 3rd party driver. The driver appears to be setting up a cursor and then 'Fetching' against that cursor. My problem is that I see these in the activity monitor but have no way of identifying the TSQL code that set up the cursor so I...
  15. Peager

    Conditional Triggers - how to.

    Hmmmmmm. I wouldn't have thought that adding a sub-select would improve performance. I tested your solution along with adding 'INNER' to my joins and using the Alias in the UPDATE statement and both solutions appear to be working much better. I can't tell any difference between them but I...
  16. Peager

    Conditional Triggers - how to.

    I have a number of tables with cascading relational constraints. When I update the parent table it cascades down through the whole relational tree perfectly however there is a field that is not part of the relationship that needs to be updated in the child tables ONLY if the related field...
  17. Peager

    How to turn single rows into multiples....

    Markos, Never mind, I got it.... It's a table of integers..... Works GREAT!
  18. Peager

    How to turn single rows into multiples....

    Markos, What is 'numbers' (on the inner join in the last line? Msg 208, Level 16, State 1, Line 11 Invalid object name 'numbers'.
  19. Peager

    How to turn single rows into multiples....

    I need a good set based solution to run a select statement that generates : 131234 2 134321 5 154234 3 I need: 131234 131234 134321 134321 134321 134321 134321 154234 154234 154234 I can think of several convoluted ways...
  20. Peager

    Problem with Excel data source.

    I have an Excel spreadhseet that is giving the following error when previewing: TITLE: There was an error displaying the preview. ADDITIONAL INFORMATION: Index and length must refer to a location within the string. Parameter name: length (mscorlib) Anyone have any clue as to what the problem...

Part and Inventory Search

Back
Top