Hi Stephen,

T-SQL, for that any Microsoft product, is well know for its libraries, and with regard to you, stored procedures and functions. So to answer your question, yes you can...

Hi Stephen,

I doubt there is anything in SQL Server as comparable to Oracle's report generation via SQL*Plus. I know its very quick and easy to build such a report in...

Hi Hemant,

The easiest thing to do would be:

1) Go to Server B.

2) Go to Security--Logins.

3) Right click on the Logins node and create a New Login.

Make sure you dont use THEN at then end of the IF statement because that's only in PL/SQL and *not* in T-SQL. Also, make sure you enclose the logic under...

CUBE and ROLLUP concepts are more appropropriate for Datawarehousing related activities and are far more advanced to use for simple pivoting activities. All you will need is to understand how to...

Hi Kyle,

Let me see if you understand me clearly and then you can help me understand you clearly.

The below mentioned SELECT statement using only those Access functions that have been...

By the way Noel, your query does not return the expected results.

It returns the below:

Field1                Field2             Field3               Field4

---------------------------------------------------------------------

ANONYMOUS...

Noel,

I wrote the query in T-SQL first and converted it back for use in MS-Access because that's what Kyle needs it in. You just converted it back to what I...

SELECT

Mid(ext_tags, InStr$(1,[ext_tags],"@1@",1)+3, InStr$(1,[ext_tags],"~1~",1)-4) AS Field1

, Mid([ext_tags], InStr$(1,[ext_tags],"@2@",1)+3, InStr$(1,[ext_tags],"~2~",1)-InStr$(1,[ext_tags],"@2@",1)-3) AS Field2

, Mid([ext_tags], InStr$(1,[ext_tags],"@3@",1)+3, InStr$(1,[ext_tags],"~3~",1)-InStr$(1,[ext_tags],"@3@",1)-3) AS Field3

, Mid([ext_tags], InStr$(1,[ext_tags],"@4@",1)+3, InStr$(1,[ext_tags],"~4~",1)-InStr$(1,[ext_tags],"@4@",1)-3) AS Field4

FROM <tablename>;