Who is online?  0 guests and 0 members
Home  »  search results

Search Results: COALESCE

13 results found
  • Avoiding dynamic SQL - COALESCE( ) and your parameters
    Problem: Everyone that's programmed a system that users will interact with has run across a statement like this one in the fact-finding stage. "I want to be able to search on phone number. I can't imaging needing to search on anything else.. Well, ok mayb
    Author: KeithHyer KeithHyer     Date: 8/31/2010     Section: Blog
  • Comma Delimited List with COALESCE
    There may be a day when you need to create your own comma delimited list from data contained in a SQL table. Sure you could build a cursor and go through each row adding a comma after each record. The good news is that there is an alternative. The better
    Author: BradSchacht BradSchacht     Date: 6/23/2010     Section: Blog
    tags : SQL
  • Parameters
    syale said: Unfortuneatly I only have read privileges on the datasource. Getting a stored procedure instantiated in a data sensitive area will take weeks. I'm with Brian, get the procedure modified - or at least get the process started. As a stop-gap, you
    Author: KeithHyer KeithHyer     Date: 9/15/2011     Section: Forum
  • COALESCE FUNCTION??
    is there an updated approach on how to use the COALESCE keyword? Or if there is a NEW keyword that will replace COALESCE on SQL 2005/2003? thank you
    Author: reymon26 reymon26     Date: 11/25/2010     Section: Forum
  • About Mapping
    Sounds like something you could map in your data source query. Either use a CASE statement or a COALESCE() function to pull first ShortName, then LegalName. Sounds like you're going to have potential problems down the road if you ever get multiple custome
    Author: paschott paschott     Date: 7/16/2010     Section: Forum
  • Migrate Data - Programmatically
    As Mike said, this is pretty hard-coded within the package. What exactly are you trying to update? I could see this possibly being done w/ some form of Dynamic SQL built using an expression, but that might be painful to write. If it's always the same sour
    Author: paschott paschott     Date: 7/1/2010     Section: Forum
  • SSIS HELP GUYS
    If there's definitely only one date column used per row, you can use a COALESCE or a series of ISNULL tests to grab the first non-NULL value in your source query. If multiple columns can contain values, you need to work out the business logic to determine
    Author: paschott paschott     Date: 1/19/2011     Section: Forum
  • Specifying the default value of a parameter who's available values are loaded by query.
    I'm loading a parameter called OrderType using the following SQL Statment: SELECT coalesce(nullif( fcpopval,''),'..None') OrderType ,coalesce(nullif(fcpoptext,''),'..None') AS OrderTypeDesc FROM cspopup WHERE fcpopkey = 'SALESCODE' ORDER BY fnorder This r
    Author: DavidStein DavidStein     Date: 8/17/2010     Section: Forum
  • Parameters
    If I understand coalesce correctly, it works like this: if it encounters an input from the parameter it takes the first non null value and runs the query with that. The user may enter multiple parameters and require the where clause to have all of these.
    Author: syale syale     Date: 9/21/2011     Section: Forum
  • merger rows into 1 row
    You ca use a function like: Create function product_name_list_get ( @qty int, @company_name varchar(100) ) Returns varchar(MAX) AS BEGIN DECLARE @listStr VARCHAR(MAX) Select @listStr = COALESCE(@listStr + ', ' ,'') + product_name from product where compan
    Author: jmontani jmontani     Date: 1/23/2013     Section: Forum
  • need to change the column data based on reference from two other tabel's in ssis etl framework
    i'm trying to migrate a database table to csv format using ssis in this table its ID column is the primary key and there are about 100 columns in it and most of the columns have shortform (for example there is a column salutat in which the data is dr ,and
    Author: pvkr pvkr     Date: 11/18/2011     Section: Forum
  • Modified Insert Unknown Row to Dimension Table
    A little over a year ago Patrick LeBlanc wrote a blog post about inserting an unknown row into a dimension . This is a great script and i've used it dozens of time, but this week I made a few modifications to it that I thought I would share. First I chang
    Author: DevinKnight DevinKnight     Date: 7/29/2011     Section: Blog
  • Select NULL As Max or Min in SQL Query
    By default the functions MAX and MIN do not count NULL in their evaluation of your data. If we have a column containing only dates for instance and there is a NULL date, MAX and MIN will both ignore that value. For instance, take the following data set as
    Author: BradSchacht BradSchacht     Date: 8/24/2010     Section: Blog
    tags : COALESCE, SQL
Page 1 of 1 (13 items)