Search Results: T-SQL

• 
  Sorting Varchar as Number with T-SQL and SSIS

  Learn how to sort a Varchar or any string column as numeric even when there are multiple separators between the varchar numbers. Learn how to do this in T-SQL as well as SSIS.

  Author:  MikeDavis     Date: 8/16/2010     Section: Article

  tags : Number, SSIS, T-SQL, Varchar, Sorting
• 
  SQL Server 2012 - SSIS - New functions

  As in my previous blog posts, I've been posting some new features in SQL Server 2012. In today's post, I would like to show you new features in SSIS. One of them is the left function wich till now you had to use substring to achieve the same result. These

  Author:  marcoadf     Date: 3/16/2012     Section: Blog

  tags : 2012, integration services, LEFT, new features, REPLACENULL, Server, TOKEN, TOKENCOUNT
• 
  BULK INSERT - Format File (skip column)

  « 1 |2| 3 » In my previous post I've shown how to bulk insert a csv file through T-SQL. In that example I've used the same structure to both csv file and destination table. In this post I'll show you how to bulk insert a file wich struture dif

  Author:  marcoadf     Date: 1/18/2012     Section: Blog

  tags : bulk, bulk insert, column, csv, fieldterminator, file, firstrow, flat, fmt, format, identity, identity column, insert, lastrow, rowterminator, Server, skip, txt, view
• 
  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
• 
  Beginning T-SQL

  Today I have attended the free webinar on T-SQL for SLQ Server from Pragmatic Works. This was a fantastic session by Patrick LeBlanc. Even though I had some experience in T-SQL I have learnt a few new things mostly the new features of SQL SERVER 2008. The

  Author:  indupriya     Date: 2/22/2010     Section: Blog

  tags : Grouping sets, Identity_Insert, Inner join, Left outer join, Right outer join, SQL
• 
  How to use a Like operator in MDX

  Hello BIDN Community, As I am sure that most of you know T-SQL fairly well and know how to use the %Like% operator when writing T-SQL. For those of you that don’t know here’s a sample of how you can write a simple T-SQL query using the Like operator. SELE

  Author:  ChrisAlbrektson     Date: 11/24/2010     Section: Blog

  tags : Like, MDX Like Function, MDX Like Operator, SSRS, vbamdx!INSTR, MDX
• 
  Insert Unknown Row to Dimension Table

  When building a warehouse there is a common practice of adding an Unknown row to the Dimension tables. For me, this is a monotonous task that I hate doing. I was recently on a project that had a large number of dimensions and I refused to write a T-SQL St

  Author:  PatrickLeBlanc     Date: 6/15/2010     Section: Blog

  tags : Dimension, Script, T-SQL, Warehouse
• 
  TSQL for the Absolute Beginner Series 1 of hmmm....not for sure

  Let’s learn a little T-SQL. Yes, I am doing a series on T-SQL for the absolute beginner who is interested in understanding how to get specific pieces of information for their company’s data. Do you know what are the top selling products or who

  Author:  SMcDonald     Date: 11/29/2011     Section: Blog

  tags : SQL server Management studio, SSMS, T-SQL
• 
  Replace Your Aggregate Transform With T-SQL

  This article covers some of the basic T-SQL aggregate functions. It is a great way to replace the Aggregate Transform in SSIS and improve SSIS package performance.

  Author:  BradSchacht     Date: 8/24/2010     Section: Article

  tags : Aggregate, COUNT, MAX, MIN, T-SQL
• 
  Vote for SSIS vs T-SQL: Loading a Data Warehouse Session for Pass Summit

  PASS Summit is coming up fast, and my Session with Adam Jorgensen "SSIS vs T-SQL: Loading a Data Warehouse", is one of the comunity choices. Please take a moment and vote for my session. Be sure to vote for my Community Session for PASS Summit http://www.

  Author:  MikeDavis     Date: 7/13/2011     Section: Blog

  tags : PASS, Summit, ssis
• 
  Help Understanding: Keep Identity in OLE_DST

  The keep identity property means that the destination table will allow you to insert to it, like you already know. It assumes that you are maintaining the identity's uniqueness, typically an identity property on a table, SQL Server is maintaining it for y

  Author:  m3crast     Date: 2/23/2011     Section: Forum

  tags : identity, IDENTITY_INSERT, Keep Identity, SSIS
• 
  SQL Server 2012 - Sequence Object

  With the new SQL Server 2012, microsoft added a lot of new features, such as T-SQL function and objects. In the post, I will show you the brand new Sequence object. For those familiar with Oracle/PLSQL, sequence has been a long time used function. But onl

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

  tags : identity column, sequence, sequence object
• 
  Free SQL Server Webinar Series

  Are you new to SQL Server? Do you want to learn about its many features and capabilities? If so, please join me and many other SQL professionals for a series of SQL Server 101 webinars next week. In my session, Beginning T-SQL (Monday, February 22, 2010 1

  Author:  PatrickLeBlanc     Date: 2/20/2010     Section: Blog

  tags : Patrick LeBlanc, Speaking, SQL Server, Webinar
• 
  SQL PASS Summit 2011 The Aftermath

  I just returned from Seattle, WA and my first time speaking at SQL PASS Summit. I did the SQL Smackdown T-SQL vs SSIS Loading a Data Warehouse with Adam Jorgensen. The session was a hit, it was standing room only and the room was full from beginning to en

  Author:  MikeDavis     Date: 10/17/2011     Section: Blog

  tags : PASS, summit, T-SQL
• 
  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
• 
  Function to calculate end of month - SQL Server 2012 - new function EOMonth

  As in my previous blog posts, I've been posting some new features in SQL Server 2012. In today's post, I would like to show you a new T-SQL function wich will lead you to solve a daily problem. So far, when you needed to get the last day from current mont

  Author:  marcoadf     Date: 4/2/2012     Section: Blog

  tags : end of month, eomonth, function, new features, new functions
• 
  Passing SSRS T-SQL Values to SSRS MDX Parameters

  At a recent client engagement we built a SQL Server Reporting Services (SSRS) report with a T-SQL based data source. A requirement of the report was to create an action that drilled-through to another report. No big deal, right? This is SSRS 101. Well, th

  Author:  PatrickLeBlanc     Date: 12/1/2010     Section: Blog

  tags : MDX, T-SQL, SSRS
• 
  Make It Simple With Policy-Based Management

  At work recently, I explained to a coworker the reasons and benefits of having databases in Simple mode in your development environment. Funnily enough, a few hours later, I see my friend Andie Letourneau ( Blog | Twitter ) posted a blog on how to adjust

  Author:  sqlchicken     Date: 7/13/2011     Section: Blog

  tags : epm framework, epmf, framework, pbm, policy-based management, administration
• 
  SQL Smackdown at SQL Sat 85 Orlando

  Are you ready for a knock down drag out fight! Come See SSIS vs T-SQL at SQL Saturday 85 in Orlando on September 24, 2011. Watch Mike Davis (@MikeDavisSQL) take on Luis E Figueroa (@LuisEFigueroa) in a head to head battle. Showing the best practices of ea

  Author:  MikeDavis     Date: 8/29/2011     Section: Blog

  tags : sql saturday. smackdown, T-SQL
• 
  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
• 
  Force a SQL Agent Job step to fail

  I still work with T-SQL in SQL Server Agent jobs on a pretty regular basis. From time to time I want to force a job step to fail based on conditions produced in the step. For example: Sometimes the T-SQL used in a step will run just fine but the data prod

  Author:  Daniel     Date: 11/4/2011     Section: Blog

  tags : force Agent job failure, SQL Agent Jobs, SQL Server
• 
  Stored Proc: xp_cmdshell to exec dtexec utility

  Update: Sql Agent Job runs a T-Sql query that executes via xp_cmdshell, the SSIS package then imports data into the table. That's the theory, tested doesn't work. Question: can Sql Agent Job execute xp_cmdshell? Eliminations: -- Tested SSIS package with d

  Author:  JohnG     Date: 7/29/2010     Section: Forum

  tags : SQL Agent Job, Stored Procedure, sql agent job
• 
  The Filestream Option

  With as many machines as I have had to image for my company, I have installed defualt instances of SQL Server 2008 more times than I can remember. One thing that crosses my mind almost everytime is 'what is filestream and why am I enabling it on every mac

  Author:  ShawnHarrison     Date: 6/20/2010     Section: Blog

  tags : AdventureWorks, BLOB, data types, Filestream, SQL Server
• 
  Defensive Database Programming -- Free ebook

  Defensive Database Programming By Alex Kuznetsov The goal of Defensive Programming is to produce resilient code that responds gracefully to the unexpected. To the SQL Server programmer, this means T-SQL code that behaves consistently and predictably in ca

  Author:  indupriya     Date: 5/18/2010     Section: Blog

  tags : free ebook, database programing
• 
  MDX Puzzle #4

  This puzzle is rather simple, but it does introduce a few new things. Using T-SQL you typically filter queries with a WHERE clause. You can also do the same with MDX, but just like T-SQL there are a few ways to accomplish this. In this puzzle you will see

  Author:  PatrickLeBlanc     Date: 7/28/2010     Section: Blog

  tags : SSAS, MDX