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: syntax
145 results found
Dump MDX OLAP Query output to a relational table from SSMS
I found two simple ways to dump MDX query output to a table and then dump the table data to excel file or text file as per need. The two methods are: 1. Using OPENROWSET Syntax : OPENROWSET('provider_name', 'datasource'; 'user_id'; 'password', {[ catalog.
Author:
artuladhar
Date: 5/16/2012 Section:
Blog
tags :
dump
,
file
,
MDX data
,
OLAP
,
output
,
query
,
Table
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
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
derived column
Learned something new today... Never used CharIndex in derived column expression before. FindString function replace CharIndex in derived column expression. Syntax : LastName : REPLACE(SUBSTRING(Name,1,FINDSTRING(Name," ",1) - 1),",","") FirstName : SUBST
Author:
meganathank
Date: 8/30/2012 Section:
Forum
tags :
derived column expression
,
FindString
,
SSIS expressions
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
SQL Update Syntax
Any help from members, how to use SQL Update Syntax in SQL. Please help me.......
Author:
fvcdata2011
Date: 1/9/2012 Section:
Forum
tags :
SQL Syntax
,
SQL Update
,
SQL Update Syntax
SQL Server 2012 - Choose Function
As I've shown in my previous posts, there is a bunch of new functions and features with SQL Server 2012. In this thread, I would like to show you how to use the new logical function which select and return data from a specific index of a list of supplied
Author:
marcoadf
Date: 12/28/2011 Section:
Blog
tags :
2012
,
case
,
Choose
,
Denali
,
function
,
IIF
,
logical
,
Server
How to Use SSIS to Loop through First 49 Diagnoses, Procedures and POA Flags
schilders said: Can you reivew and help me identify where my syntax is incorrect? Well, I don't have a table that matches your structure - so I did not test this, but at first glance, it might be the location of the first "ON" clause within the JOIN porti
Author:
KeithHyer
Date: 8/2/2011 Section:
Forum
tags :
data source
,
pivot
,
ssis
SQL Server 2012 TSQL Logical Functions Part 2
Last week I started a 5 part miniseries covering the new TSQL functions in SQL 2012. Last week in part 1 I covered the new string functions. This week we will be taking a look at the Logical functions. The first function we will be looking at today is the
Author:
ChrisAlbrektson
Date: 3/13/2012 Section:
Blog
tags :
SQL Server 2012 Functions
,
TSQL 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
Bulk Insert and Identity Column
Yes, you can. The syntax is show below: USE AdventureWorks2008R2; GO DELETE HumanResources.myDepartment; GO BULK INSERT HumanResources.myDepartment FROM 'C:\myDepartment-n.csv' WITH ( KEEPIDENTITY, FORMATFILE='C:\myDepartment-f-n-x.Xml' ); GO SELECT * FRO
Author:
marcoadf
Date: 1/10/2012 Section:
Forum
tags :
bulk insert
,
Column
,
file
,
format
,
identity
,
keepidentity
,
XML
SQL Server 2012 TSQL Conversion Functions Part 4
SQL Server 2012 TSQL Conversion Functions Part 4 In this forth blog post we will cover the new Conversion functions available in SQL 2012. This is the second to last topic of this miniseries of blog posts covering the new TSQL function in SQL server 2012.
Author:
ChrisAlbrektson
Date: 6/11/2012 Section:
Blog
tags :
SQL Server 2012 Functions
,
TSQL
,
TSQL 2012
SQL Server 2012 TSQL DateTime Functions Part 3
In this third blog post we will cover the new DateTime functions available in SQL 2012. If you have read my previous 2 postings on this subject you probably have noticed only 2 -3 function per category. Well in this posting this changes where we will be c
Author:
ChrisAlbrektson
Date: 3/26/2012 Section:
Blog
tags :
SQL Server 2012 Functions
,
TSQL Functions
INNER JOIN vs. comma join
The preferred T-SQL syntax for joining tables is by using JOIN. The alternate syntax, the comma join syntax, is still being used out there. In my opinion, we should all forget about that old method and embrace the JOIN syntax. Here is an example of the co
Author:
KathiKellenberger
Date: 7/22/2012 Section:
Blog
Substring
syntax
in SQL
Yesterday I was trying to get a part of a string from a field where the first comma occurs. For example there is a field let us call it 'Descriptor' which is a combination of a few fields let us say "full name, Date of birth, unique number of the record"
Author:
indupriya
Date: 5/25/2010 Section:
Blog
tags :
sql
,
SQL Syntax
MDX 101: Introduction to MDX
In this article, Dustin will cover the basics of the Multi Dimensional Expression (MDX) Language and introduce you to writing your first MDX statement.
Author:
DustinRyan
Date: 9/1/2010 Section:
Article
tags :
Introduction to MDX
,
Learn MDX
,
mdx
,
MDX query syntax
Creating a Rolling Date Range Named set in MDX
Creating a Rolling Date Range Named set in MDX One Client I was working with wanted a named set that would give them the last 5 years. Of course this needed to be a rolling 5 years so it automatically moved the years up every January. To create this I use
Author:
MikeDavis
Date: 12/6/2010 Section:
Blog
tags :
Date
,
Date Range
,
Named Set
,
Rolling Date
,
MDX
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
Space function in SQL
Today I had a unique scenario where I had to introduce 2 spaces in between two fields. I came across the space function which I used in my scenario. The syntax is space(integer_expression) The integer expression is an integer. IF a negative value is suppl
Author:
indupriya
Date: 12/13/2011 Section:
Blog
tags :
space
,
space function in sql
Discover the power of Microsoft SQL Server with sql server business intelligence
SQL 2005 or 2008, how do you configure security to allow a user to SELECT data from a table but not view the table definition?
Author:
fvcdata2011
Date: 1/9/2012 Section:
Article
tags :
sql Interview questions and answers
,
sql select statement
,
sql server error 18456
,
SQL Update Join
Intro to MDX at SQL Saturday #130 – Jacksonville, FL
This weekend is SQL Saturday #130 in Jacksonville, FL. On Friday, April 27th, is a great pre-con session by SQL Server MVP, Kevin Kline on Performance Tuning SQL Server 2008 R2. Go here to get registered for this phenomenal opportunity to learn from an un
Author:
DustinRyan
Date: 4/26/2012 Section:
Blog
tags :
free training
,
SQL Saturday
Create filter that displays the last 3 years based on value in TIME dimension
Hey KT, I'm guessing this is in PerformancePoint? If so there are two ways you may do this: You could create time intelligence filter using and an expression that looks like this - (Year -6) http://office.microsoft.com/en-us/performancepoint-server/about-
Author:
DevinKnight
Date: 2/14/2012 Section:
Forum
tags :
PerformancePoint
,
Scorecards
what all are the possible chances for data from datasource is not copied into excel destination
Hi, Jobi. When you use Excel as a destination - you need to create a "table" in the excel spreadsheet destination into which the data can then populate. There is an example in my blog post here: http://www.bidn.com/blogs/KeithHyer/bidn-blog/2512/creating-
Author:
KeithHyer
Date: 1/17/2013 Section:
Forum
tags :
worksheet
SSIS with XLSM excel sheet as source
sure enough - the syntax of my excel connection was incorrect. After pressing "DataLinks", In the "All" tab -> 'Extended Properties' was filled incorrectly. I now have: Excel 12.0 Macro;HDR="YES"; and it WORKS! KeithHyer - i marked your reply as the an
Author:
sherz1000
Date: 9/6/2011 Section:
Forum
Unable to Execute Dtexec in 64Bit Env
Guru, Does "Start" accept multiple parameters for running a file? Maybe try it this way so you're quoting / enclosing the parameters along with the command: Start /Affinity 4 /Min "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTEXEC.exe /F C:\
Author:
KeithHyer
Date: 3/14/2012 Section:
Forum
tags :
32-bit
Page 1 of 6 (145 items)
<< Prev
1
2
3
4
5
6
Next >>
Go to page:
[Go]