Article:		Creating Cross Tab Queries in SQL Server
Subject:		Great article!
Date:		2005-04-15 01:09:27
From:		AbsoluteVoid
This works really, really fine! Compliments! But I get problems when trying to include a WHERE string. Could you please elaborate or help me? I've given the variable the following value: "WHERE IDProjet=9", but the result is empty and it shouldn't be! Is there something from in my expression? Thanks a lot.

Showing messages 1 through 2 of 2.

• Where clause
  2005-04-15 10:47:54  Michael Schmalz | [View]
  
  
  To get it to work, you will need to put in a space at the front of the Where clause and at the end. Sorry, I forgot to mention that.

• Great article!
  2005-04-15 02:01:36  AbsoluteVoid [View]
  
  
  Update: Now I get the following:
  
  Line 1: Incorrect syntax near '='.
  
  ???