Browsed by
Tag: T-SQL

Validating email string without using sp_OACreate in T-SQL

Validating email string without using sp_OACreate in T-SQL

I wanted a way to validate that an email address in a SQL query was well-formed, and found a lot of resources suggesting to create a scalar function that invokes sp_OACreate among others, and return a bit indicating if it was valid or not. ¬†That works great, but not for those of us in heightened security environments, where granting execute permissions to system stored procs and functions is not permitted. ¬†After searching around I came up with the following function:…

Read More Read More

24 Hours of PASS registration open

24 Hours of PASS registration open

Registration is open for 24 hours of PASS in March! Go to http://bit.ly/fMzarY to register. This one is “Celebrating Women in Technology” and has some great sessions lined up, including discussions on T-SQL, SSRS, SSIS, performance, MDX, even Twitterdata in Azure! You don’t want to miss this!

24 Hours of PASS – March 15-16 2011

24 Hours of PASS – March 15-16 2011

The 24 Hours of PASS is returning March 15th-16th 2011, and they’re looking for feedback on which sessions to include! If you’d like to participate, the link to the survey can be found here. I chose the ones I’d like to see, be sure to stop by and make your selections for your favorites! I’m looking forward to another great set of informative sessions! If you haven’t done the 24 Hours of PASS yet, it’s definitely worth attending! If you…

Read More Read More

Case expressions may only be nested to level 10

Case expressions may only be nested to level 10

I was working on a rather lengthy query that used a typical CASE WHEN THEN ELSE END sequence, but it kept telling me “Case expressions may only be nested to level 10”, even though I wasn’t nesting or doing something unique with them, just like this: case when field1 = ‘data’ then ‘data1’ when field1 = ‘datax’ then ‘data2’ when field1 = ‘datay’ then ‘data3’ when field1 = ‘dataz’ then ‘data4’ when field1 = ‘dataa’ then ‘data5’ when field1 =…

Read More Read More

24 Hours of PASS…again!

24 Hours of PASS…again!

To some it may seem like I post about 24 hours of @PASS regularly, but is it a bad thing? Free web-based SQL information and training from industry professionals? You won’t hear me complaining! This set seems like it’s a little better than before, the link to the event is here. The sessions I will be attending are: WHY DATA WAREHOUSING PROJECTS FAIL (AND WHAT YOU CAN DO ABOUT IT). IDENTIFYING COSTLY QUERIES SQLBI METHODOLOGY T-SQL BRUSH-UP: THE BEST THINGS…

Read More Read More