Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
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
Date: 8/31/2010 Section:
Blog
tags :
coalesce
,
optional parameters
,
dynamic sql
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
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
Date: 9/15/2011 Section:
Forum
tags :
avoid dynmaic sql
,
optional parameters
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
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
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
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
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
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
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
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
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
Date: 7/29/2011 Section:
Blog
tags :
Data Warehouse
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
Date: 8/24/2010 Section:
Blog
tags :
COALESCE
,
SQL
Page 1 of 1 (13 items)