CrossTab in T-SQL code - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

CrossTab in T-SQL code

Message

24/08/2007 04:00:02

Kevin Goff
Pennsylvanie, États-Unis

24/08/2007 03:52:52

Bhavbhuti Nathwani
Venus Software Operations
Rajkot, Inde

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: CrossTab in T-SQL code

Versions des environnements

Visual FoxPro:

VFP 9 SP1

Database:

Firebird

Divers

Thread ID:

01250107

Message ID:

01250108

Vues:

Hi, if you're using SQL 2005 as your database (you mentioned T-SQL, but you've specified Firebird as your database???), you can use the PIVOT statement to convert rows of data into columns.

Kevin

"Run, you clever boy....and remember"
https://www.youtube.com/watch?v=8U4Y2Uv8ArM

"My survival...my living proof"
https://plus.google.com/photos/117162300364810952313/albums/5876836271056272097/5876836294121419858?banner=pwa&pid=5876836294121419858&oid=117162300364810952313

Répondre

Fil

Voir

Click here to load this message in the networking platform