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: t-sql
228 results found
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
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
Free T-SQL Training - SQL Lunch #25 (Transact-SQL Development and Deployment)
Join SQL Server MVP, Andy Leonard, tomorrow on the SQL Lunch to learn some snappy tips and tricks on Transact-SQL development and deployment . Go to SQL Lunch and add this event to your calendar or use the link in this posting. To receive notifications ab
Author:
PatrickLeBlanc
Date: 7/13/2010 Section:
Blog
tags :
Speaking
,
T-SQL
,
SQL Lunch
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
Don't be too quick to use a cursor
A quick explanation and example of using the OUTPUT clause of a T-SQL Insert statement to capture an Identity column value for further processing
Author:
jtarnott
Date: 12/22/2009 Section:
Article
tags :
identity
,
Cursor
,
Output clause
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
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
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
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 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
These are a few of my favorite books
IT is an interesting field; you are never done learning. In fact, things move pretty fast and it is hard to keep up. Even if you think you your job is stable, there are no guarantees and it pays to keep your skill sharp. I recently compiled a list of book
Author:
KathiKellenberger
Date: 25 days ago Section:
Blog
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
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
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
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
INNER-JOIN QUERIES WITH INNER PEACE
In joining multiple tables, a valuable lesson I have learned today was to use pen and paper to write down all the primary and foreign keys from the the multiple tables that were involved in writing my T-SQL query statement. This piece of advice (Thank you
Author:
nube07
Date: 12/7/2011 Section:
Blog
tags :
Inner join
,
T-SQL
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
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
Policy-Based Management and Local Password Policy
This post is based on an interesting question/situation that was posted over at ASKSSC.com today . The user asked how to create a policy condition that enforces local sql accounts to adhere to password expiration policies. First off, to create the conditi
Author:
sqlchicken
Date: 5/4/2011 Section:
Blog
tags :
administration
,
policy-based management
,
pbm
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
Page 1 of 10 (228 items)
<< Prev
1
2
3
4
5
6
7
8
9
10
Next >>
Go to page:
[Go]