SPROCKING.BLOGSPOT.COM

David Korb's SQL weblog

David Korb's SQL weblog. SAS date in a pass-through query. Currently an IT worker living in San Jose. View my complete profile. Tuesday, August 3, 2010. SAS date in a pass-through query. Dates have to be passed into Teradata as quoted strings and you can't just concatenate single quotes to the macro variable using the native RDBMS syntax. What you need is the %BQUOTE function to mask a quote as you assign it to a macro variable. Here is an example where you want the last 5 days of data. Data null ;.

http://sprocking.blogspot.com/

OVERVIEW OF sprocking.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

7

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR SPROCKING.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

December

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Tuesday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.9 out of 5 with 10 reviews

5 star

9

4 star

1

3 star

0

2 star

0

1 star

0

Hey there! Start your review of sprocking.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

1.6 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT SPROCKING.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

7

SSL

EXTERNAL LINKS

0

SITE IP

74.125.228.236

LOAD TIME

1.553 sec

SCORE

6.2

PAGE TITLE

David Korb's SQL weblog | sprocking.blogspot.com Reviews

<META> DESCRIPTION

David Korb's SQL weblog. SAS date in a pass-through query. Currently an IT worker living in San Jose. View my complete profile. Tuesday, August 3, 2010. SAS date in a pass-through query. Dates have to be passed into Teradata as quoted strings and you can't just concatenate single quotes to the macro variable using the native RDBMS syntax. What you need is the %BQUOTE function to mask a quote as you assign it to a macro variable. Here is an example where you want the last 5 days of data. Data null ;.

<META> KEYWORDS

1 links

2 mylinkinprofile

3 blog archive

4 about me

5 david

6 run;

7 let q=%bquote ' ;

8 proc sql;

9 exec

10 by teradata;

CONTENT

Page content here

KEYWORDS ON PAGE

links,mylinkinprofile,blog archive,about me,david,run;,let q=%bquote ' ;,proc sql;,exec,by teradata;,quit;,posted by,no comments,variables in teradata,commit,preserve rows;,insert a value,select date;,where exists,select *,sequence i as,select,select i

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

David Korb's SQL weblog | sprocking.blogspot.com Reviews

https://sprocking.blogspot.com

David Korb's SQL weblog. SAS date in a pass-through query. Currently an IT worker living in San Jose. View my complete profile. Tuesday, August 3, 2010. SAS date in a pass-through query. Dates have to be passed into Teradata as quoted strings and you can't just concatenate single quotes to the macro variable using the native RDBMS syntax. What you need is the %BQUOTE function to mask a quote as you assign it to a macro variable. Here is an example where you want the last 5 days of data. Data null ;.

INTERNAL PAGES

sprocking.blogspot.com

1

David Korb's SQL weblog: SAS date in a pass-through query

http://sprocking.blogspot.com/2010/08/sas-date-in-pass-through-query.html

David Korb's SQL weblog. SAS date in a pass-through query. Currently an IT worker living in San Jose. View my complete profile. Tuesday, August 3, 2010. SAS date in a pass-through query. Dates have to be passed into Teradata as quoted strings and you can't just concatenate single quotes to the macro variable using the native RDBMS syntax. What you need is the %BQUOTE function to mask a quote as you assign it to a macro variable. Here is an example where you want the last 5 days of data. Data null ;.

2

David Korb's SQL weblog: February 2010

http://sprocking.blogspot.com/2010_02_01_archive.html

David Korb's SQL weblog. Currently an IT worker living in San Jose. View my complete profile. Tuesday, February 16, 2010. As of this writing, I am managing batch scripts that hit Teradata servers. Unlike MS SQL Server, Teradata does not allow functionality such as branching logic or variables. Unfortunately, this means the programmer has to bend over backwards to get work done and the code becomes less readable. Create the temp table. CREATE VOLATILE TABLE process date (. UNIQUE PRIMARY INDEX (batch date).

3

David Korb's SQL weblog: Variables in Teradata

http://sprocking.blogspot.com/2010/02/variables-in-teradata.html

David Korb's SQL weblog. Currently an IT worker living in San Jose. View my complete profile. Tuesday, February 16, 2010. As of this writing, I am managing batch scripts that hit Teradata servers. Unlike MS SQL Server, Teradata does not allow functionality such as branching logic or variables. Unfortunately, this means the programmer has to bend over backwards to get work done and the code becomes less readable. Create the temp table. CREATE VOLATILE TABLE process date (. UNIQUE PRIMARY INDEX (batch date).

4

David Korb's SQL weblog: August 2010

http://sprocking.blogspot.com/2010_08_01_archive.html

David Korb's SQL weblog. SAS date in a pass-through query. Currently an IT worker living in San Jose. View my complete profile. Tuesday, August 3, 2010. SAS date in a pass-through query. Dates have to be passed into Teradata as quoted strings and you can't just concatenate single quotes to the macro variable using the native RDBMS syntax. What you need is the %BQUOTE function to mask a quote as you assign it to a macro variable. Here is an example where you want the last 5 days of data. Data null ;.

5

David Korb's SQL weblog: SQL Server 2005 string search utility

http://sprocking.blogspot.com/2009/08/test.html

David Korb's SQL weblog. Create a tally table using a CTE. SQL Server 2005 string search utility. Currently an IT worker living in San Jose. View my complete profile. Thursday, August 13, 2009. SQL Server 2005 string search utility. A utility for finding strings in compiled objects on an instance of SQL Server 2005. Compiled objects being: user-defined functions, stored procedures, triggers, views, check constraints. This comment has been removed by the author. Subscribe to: Post Comments (Atom).

UPGRADE TO PREMIUM TO VIEW 2 MORE

TOTAL PAGES IN THIS WEBSITE

7

OTHER SITES

sprocki-cup.de

Sprocki Cup e.V. - Home

The term of application has been extended. Everybody who would like to participate in the Sprocki Cup 2015 can apply until Feb. 28, 2015. Presentation of the executive committee’s new concept to the patron. The invitations are dispatched and participants are going to be made certain. Now it's time for the tournament's patron, mayor Ulli Winkelmann, to pay the organization team a visit. Five clubs - one town - one tournament. Tournament May 22 - 25, 2015. Age class 7 - 14. Entry fee juniors EUR 25 deposit.

sprocki.net

Index of /

sprockids.com

Sprockids | Your Ride Starts Here!

Sprockids Leader Training "Eastern Canadian Tour". Sprockids Eastport, Newfoundland. Through the sport of mountain biking young people will have the opportunity to develop the skills, values, and strategies that will guide them throughout their lives and enable them to successfully reach their full potential. Sprockids is all about changing the role and definition of sports in our society. Being active and having fun should be a part of everyday life. Sprockids is all-inclusive!

sprockidstoronto.com

Sprockids Toronto |

If you would like to see this program start again, please contact Cycle Solutions. Designed by Cycle Solutions 2015.

sprockincat.com

Welcome sprockincat.com - BlueHost.com

Web Hosting - courtesy of www.bluehost.com.

sprocking.blogspot.com

David Korb's SQL weblog

David Korb's SQL weblog. SAS date in a pass-through query. Currently an IT worker living in San Jose. View my complete profile. Tuesday, August 3, 2010. SAS date in a pass-through query. Dates have to be passed into Teradata as quoted strings and you can't just concatenate single quotes to the macro variable using the native RDBMS syntax. What you need is the %BQUOTE function to mask a quote as you assign it to a macro variable. Here is an example where you want the last 5 days of data. Data null ;.

sprockit.mobi

sprockit.mobi - Crazy Domains

Search and register domain names. World's cheapest domain names. 700 New generic domains. Move your domains to us FREE. Express cheap domain renewal. Get the domain name you want. Everything you need for your domains. Control your CNAME, MX and A records. Find who owns a particular domain. COM only $9.00 Get yours! Join The Domain Club. Fast, reliable space for your website. Defend your site against hackers. Secure your site and data. Get your own me@mydomain.com. Automatic Spam and Virus protection.

sprockitandrok.com

UNDER CONSTRUCTION

Is currently UNDER CONSTRUCTION. This Web site is currently under construction. Please be sure to visit this Web site again in the near future! This is your current default homepage; it has been setup with your new account. To update this Under Construction page, please replace your index.html file.

sprockitapps.com

Sprockit Apps | Mobile software for professional development

Want to turn your awesome ideas into iPhone or Android apps? You are in the right place. MCAT Review named a top 50 app by Schools.com. Today I’m excited to announce that our MCAT app was named in the Schools.com list of 50 useful apps for test . PTCB Exam Review now available on Android! The #1 bestselling pharmacy technician exam review app is now available on Android! For the past few months, . Interview Questions Pro is here! Need to prepare for an upcoming job interview? Try Interview Question Pro!

sprockitglory.com

SPROCKIT

App Criteria / Apply Now. App Criteria / Apply Now. SPROCKIT was a great home base for us at NAB Show. The physical space, the connections and visibility they helped create gave us a solid launching point to have a successful show. - Mike Folgner, Co-Founder and CEO of SnappyTV. Great opportunity for technology/media companies to meet the movers and shakers in the broadcast and media industries. - Kay Koplovitz, Chairman, Springboard Enterprises and Founder, USA Networks. Fifteen years ago, I first atten...

sprockitz.com

Sprockitz - The Ultimate Maker Controller

It's an Automation Controller. A Web Interface for your projects. An Internet-of-Things App Platform. Shown with optional I/O Connector and Enclosure. Easily Create Complex Animations - NO PROGRAMMING REQUIRED! Configure Your I/O lines.