Search results
3 mar 2015 · I am using MS SQL Server. I have a column, 'CUSTOMER_NAME'. Names are in Last Name, First Name format and some include suffix info such as 'Jr' or 'II'. I was using the below to split into two separate columns, one for first name and one for last name. The problem I run into is with the suffix info. It splits into both first and last name columns.
3 lis 2021 · Learn how to format numbers, dates, time and money using the SQL Server FORMAT function.
17 wrz 2021 · In particular, this tip will dive into using the functions: 1) IIF, 2) SWITCH and 3) CHOOSE. Most folks are somewhat familiar with the iif method, but switch is less common and choose even lesser known. Surprisingly, choose is actually a SQL Construct that can be used in select statements, but the focus in this tip will be on usage in SSRS.
23 maj 2017 · I have a simple tsql select query that returns a user's name in this format: e.g. Doe, John. How do I update the output so that it is in the format John Doe? I have tried using a split string function but it returns multiple rows rather than 2 columns... https://stackoverflow.com/questions/10914576/tsql-split-string
26 kwi 2017 · An introduction on how to implement condition formatting of cells, such as the font and background colour or font weight, within SSRS using SSRS Expressions.
4 wrz 2018 · In this tip, we will look at how to add conditional formatting to a SQL Server Reporting Services SSRS report to make reports even more useful. Solution Let’s take the following report as the basis for this tip.
15 lis 2016 · When doing a rename-based switch or swap, Microsoft SQL Server doesn’t check whether column names, data types, nullability, primary keys, etc., match. At the metadata level, renaming a table to what another table used to be named doesn’t associate the just-renamed table with its namesake’s metadata even if their schemas happen to match.
