Search Results: case

• 
  SQL Server Reporting Services - Colour graduation function

  I needed to highlight date information dependant on it's proximity to today's date. Using colour graduation, greater emphasis is placed on dates near today and those in the future, while less emphasis is placed on historical dates. Here's a function I cre

  Author:  domhorton     Date: 1/13/2011     Section: Blog

  tags : Colour graduation, Select Case, Sql Server Reporting Services, SSRS
• 
  SQL University: Architecture for Small Businesses

  Welcome back to SQL University! This week we’re going to be discussing architecture. In previous weeks we’ve discussed architecture at a high level ( Capacity Planning Week ) but this week we’re going to get a little more focused. SQL Se

  Author:  sqlchicken     Date: 9/19/2011     Section: Blog

  tags : administration, Architecture, azure, Cloud Computing, Licensing, SQL Azure, sql university, sqlu
• 
  The CASE of the missing non-NULL T-SQL Error: None of the result expressions in a CASE specification can be NULL.

  Recently, while doing some data scrubbing for a customer I got an interesting error in SSMS with one of my CASE statements. The error received was: None of the result expressions in a CASE specification can be NULL. It was a long T-SQL script (and a long

  Author:  JoseChinchilla_SQLJoe     Date: 11/16/2011     Section: Blog

  tags : case, case statement, Error, sqlserver, syntax, T-SQL
• 
  Case Transform from Task Factory

  Below I will show you how to use the Case Transform (CT) that’s available from Task Factory. The (CT) provides a way to properly case, upper case or lowercase all the text in a source column. This is great tool that will help you clean up your sourc

  Author:  ChrisAlbrektson     Date: 11/9/2011     Section: Blog

  tags : Case Transform, task factory
• 
  Setting proper case in SSIS with a Script Task

  The Derived column transform can make a lot of changes in a data flow in SSIS. In about 95% of the time the derived column can take care of any data cleansing issues with text changes. There is one thing that is does not have and that is proper case. The

  Author:  MikeDavis     Date: 1/15/2010     Section: Blog

  tags : C#, Proper Case, Script Transform, VB, SSIS
• 
  SSIS 2008 Setting proper case with a Script Component

  There is a command in VB that can be used to character data to proper case. This is the first letter of each word is capitalized and the rest is lower case. This is a great way to clean up a data base or is great to use when loading a data warehouse. Drag

  Author:  MikeDavis     Date: 2/17/2010     Section: Blog

  tags : .NET, 2008, c#, ProperCase, Script Component, VB, sss
• 
  Introduction to the CASE Expression By Andy Warren

  I have used case statements before several times but there were some new learnings from the SQL Share video of Andy Warren Here are my learnings of the case statement summarised: People often get confused whether to use if else statements or case statemen

  Author:  indupriya     Date: 10/3/2010     Section: Blog

  tags : sqlshare, video, case statement
• 
  Ignoring Zero Values When Finding an Average in SSRS

  Last week, I was writing reports for a client who wanted to see averages for particular columns. The problem was that some of the rows contained zeros and he did not want that factored into the average. To fix this, I had to make a change to the query. I

  Author:  ShawnHarrison     Date: 3/22/2011     Section: Blog

  tags : Average, Expressions, NULL, SSRS
• 
  MCTS (70-448) and MCITP (70-452)

  In the last September 28th I've passed my 1st microsoft certification. In fact, I've passed 2 microsoft certifications!! Yes, I was able to do both certification exams in the same day. It was my very first experience in certification exams. I've got 1000/

  Author:  marcoadf     Date: 12/26/2011     Section: Blog

  tags : 70-448, 70-452, being, Certification, exams, Marco, marcoadf, MCITP, MCTS, measured, microsoft, skill, study, testking, training
• 
  SQL Server 2012 - IIF Function

  In earlier versions of SQL Server, when you were writing T-SQL, how many time you asked yourself "is there a if function?". Even when you used CASE function, how many time did you said "if there was a if function, this was a lot easier". Well, finally wit

  Author:  marcoadf     Date: 12/19/2011     Section: Blog

  tags : case, function, if, IIF, limitation, nested
• 
  Installation Blocked in Windows Server 2003

  Yesterday, I assisted a client who was trying to install a thrid party app to use in Visual Studio. He was using RDP to log on to a remote machine running Windows Server 2003 and run the msi. Each time he tried, he received an error message telling him he

  Author:  ShawnHarrison     Date: 3/31/2010     Section: Blog

  tags : 2003, applications, Enhanced, network, security, Server, Windows
• 
  Split column with condition

  A conditional split is simply a case statement that allows you to redirect the different cases (i.e. ZPENPO=1) down different output flows. You might be better off doing this logic in TSQL with an UPDATE statement with Cases.

  Author:  sqlchicken     Date: 7/28/2011     Section: Forum

  tags : Conditional Split, tsql, T-SQL, ssis
• 
  Can't execute package from remote machine

  I've seen this before - it was in SQL 2005 and may be a different issue you're seeing. I believe what you want to Google / research is called something like "multi step active directory authentication". You might add Kerberos in there somewhere too as I r

  Author:  KeithHyer     Date: 3/19/2013     Section: Forum

  tags : anonymous login, authentication, Kerberos, remote
• 
  Intellisense - Case Sensitive

  Intellisense is case-sensitive. I spent some in-between time trying to figure out why my intellisense would was case sensitive. There is a sqlservercentral.com article that explain that intellisense runs on binary and therefore is case-sensitive. It may b

  Author:  ogonzalez     Date: 6/7/2011     Section: Blog

  tags : Case Sensitive, Intellisense
• 
  SSIS: Two issues while import excel data into three db tables

  Well, to correct the issue in #1, Try something like this: SELECT DISTINCT Id , Name , Sales_Stage , Primary_Sales_Rep_Login , Product , [Description] , First_Name + Last_Name AS Full_Name , CASE WHEN Street_Address IS NULL THEN '' ELSE Street_Address END

  Author:  KeithHyer     Date: 4/5/2013     Section: Forum

  tags : Excel, NULL, ssis
• 
  Task Factory - Case Transform

  The Case Transform, an SSIS component in the Task Factory suite from Pragmatic Works, allows you to easy correct the capitalization mistakes found in many source systems. This video demonstrates how easy it is to use.

  Author:  arcanecode     Date: 8/7/2011     Section: Blog

  tags : Pragmatic Works, SQL Server Integration Services, SSIS, Task Factory
• 
  Want the Functionality of a CASE Statement in a WHERE Clause?

  You may find yourself wanting to apply the functionality of a CASE statement inside a WHERE clause in one of your SQL scripts or stored procedures. Although you might get you case statement working with a lot of finagling (I have never got it to work the

  Author:  kylewalker     Date: 5/10/2011     Section: Blog

  tags : AND/OR logic, TSQL
• 
  Assistance Needed in Correctly Scoping a SSRS 2005 Calculation

  Hi All, I have created a SSRS 2005 report that is based on a stored procedure. The goal of the report is to group the data first by physician, then by discharge federal fiscal year and finally by MSDRG. The metrics of the report include total cases, avera

  Author:  schilders     Date: 6/29/2011     Section: Forum
• 
  SQL Server Reporting Services - Green bar matrix report

  Here's how I've created a 'green-bar' style cross-tab/matrix report. I'm basing the new report on this one: 1) Create an inner row grouping, in this case named 'Count' and given a grouping expression of =1 2) for the cell 'Count', set the property Value =

  Author:  domhorton     Date: 1/27/2011     Section: Blog

  tags : RunningVal, CountDistinct, Green Bar, Green Bar Matrix, Matrix, Sql Server Reporting Services, SSRS
• 
  SSIS: How to know/log each step duration and errors (inside DTS with Logging)

  In my previous post, I've shown how you could extract the time duration of a DTS. Assuming that you have selected the DTS witch is the slowest among the others, how could you know wich of the steps is the worst? Imagine that you have 20 steps inside the D

  Author:  marcoadf     Date: 1/30/2010     Section: Blog

  tags : DTS, Event, File Connection, Logging, OnProgress, Progress, SSIS
• 
  SSIS Case Sensitivity

  One of the most frustrating learning curves for a DBA going to SSIS is the case sensitivity of the environment. Many developers are quite used to this due to option explicit .NET programming languages. The case sensitivity can in some cases create behavio

  Author:  BrianKnight     Date: 11/7/2009     Section: Blog
• 
  Renaming Project Collections in Team Foundation Server 2010

  Team Foundation Server is a powerful tool that seamlessly integrates the Visual Studios with Source Control, Work Item Tracking, Automating Builds, Test Case Management, Reporting, and Virtual Lab Management. As such, it's necessary to develop Collections

  Author:  Tyler     Date: 9/7/2011     Section: Blog

  tags : 2010, Collections, foundation, Project, renaming, Server, Team
• 
  Using aggregates in a case statement. Is that possible?

  Working on case statements today I thought of a possible business requirement that an executive might look for. Instead looking for something specific: when '1' then 'beverages' Can you have an aggregate in between the when and then? Select shipname, ship

  Author:  ogonzalez     Date: 6/7/2011     Section: Forum

  tags : case, equations
• 
  a query to assign the condition

  Asmi28, I too would need more information. From what you have so far, I think you're looking for a SELECT with CASE statements. My guess is something like the following. Without more information, I cannot say this is the answer for sure. SELECT CASE WHEN

  Author:  KeithHyer     Date: 10/28/2011     Section: Forum

  tags : case statement, NULL or Empty, query
• 
  SSAS performance tuning (Case Study)

  In the previous post , we have seen that only few smart moves/changes can make cube processing time far less than the current cube processing time. In this post, we will explore the way to identify the performance bottleneck and different ways to resolve

  Author:  sirfnet     Date: 3/16/2011     Section: Blog

  tags : Tutorial, Performance Tuning, SSAS