risk

Technical Article

RE: getting year from string

  • Reply

well.. what the question really was about was how to get the 4 last charachters (that just happened to mean 'year') from a string that could be 6 or 7 chars total length.ie 1/2005 or 11/2005 where 2005 is the wanted part...  /Kenneth

You rated this post out of 5. Change rating

2005-04-14

Technical Article

RE: query

  • Reply

CREATE TABLE #temp1 (key INT , string VARCHAR(10)) INSERT INTO #temp1 SELECT geoid, CAST(x AS varchar(3)) + ',' + CAST(y AS varchar(3) FROM my_table CREATE TABLE #temp2 (key INT , string VARCHAR(100)) DECLARE @k INT, @temp_string VARCHAR(100) DECLARE c CURSOR FOR SELECT key FROM #temp1 OPEN c FETCH NEXT c INTO @k WHILE @@FETCH_STATUS = […]

You rated this post out of 5. Change rating

2003-06-13

1 reads

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers