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 TouchToneTommy 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. chrisdoesstuff

    delimited text runs together how can I separate it?

    Crystal X, SQL 2008 I have an app that sends data to the db as a pipe delimited varchar so when I query the db I get Jane Doe|John Doe|Mike Smith In crystal it displays as JaneDoeJohnDoeMikeSmith Is there a way I can make it Jane Doe John Doe Mike Smith or the more preferable Jane Doe, John...
  2. chrisdoesstuff

    What is the easiest way to select the Max of a field

    SQL server 2008 Maybe I'm missing something easy, at least it seems so but I have a datetime field that I need to select the max of. I was hoping I could do this as part of my join but it might be more work than that. The data is as follows Table: TeamTable Columns: Team_Name...
  3. chrisdoesstuff

    Question on inserting a single row multiple times based on its value

    SQL express 2008 My data contains a set of values that I'd like to use parts of in a query. (this isn't real data I'm just trying to fully grasp the concept) Ex animals.value and the values are 'Rhino', 'Leopard', 'Cheetah', 'Monkey' I want to insert the data into a table variable but only if...
  4. chrisdoesstuff

    help with a parameter and variable

    SQL server express 2008. I know I'm not doing something correct to pass the parameter to the query but I'm not positive what I'm doing wrong so hopefully you can help me. ALTER procedure [dbo].[Shortname2] @icd91 NVARCHAR (55) AS BEGIN DECLARE @icd92 NVARCHAR (55) SET NOCOUNT ON...
  5. chrisdoesstuff

    Create a group based on values

    Crystal 10 SQL 2005 I need to create some groups based upon values. For example I have the items grouped by values now I need to take the values in the group and put them into another group. they are grouped because the duplicated values need to be removed. Groups would be: Dog1 Cat1 Fish1...
  6. chrisdoesstuff

    2 questions- dynamic page footers and creating a group for formatting

    I have two questions: 1. Can I create a formula for a page footer to display when it is not the second to last or last page in the report. I assume I can use the page n of m special field and calculate based on that but I'm not sure how to do that. 2. I have grouped my items based on a...
  7. chrisdoesstuff

    Question on aliasing a column based on a value

    I am trying to write a query that will end up on a crystal report. SQL 2005 and this will be part of a stored procedure. I have a basically 1 table that contains two rows which have all my information in them but I need to be able to alias the column based on the values contained in a way...

Part and Inventory Search

Back
Top