Search Results | SQL Server Performance Forums

The sorting is not working

Thread by: alisag, Mar 18, 2010, 5 replies, in forum: SQL Server 2008 General Developer Questions

Hi all, i have the following code SELECT CASE WHEN [Service Header].[Document Type] = 0 THEN 'Quote' ELSE 'ORDER' END AS [Doc Type], [Service...

Data Types variance

Thread by: alisag, Feb 9, 2010, 8 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I have the following query in which i have one integer type field called Status. But what i want to display is some meaningful data on this...

Use of Sum function

Thread by: alisag, Feb 8, 2010, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, I wrote the following Query SELECT Item.Description,Item.[No_],POC.[Qty on Component Line] FROM [Company Name$Item] AS Item LEFT OUTER JOIN...

Using Agg Function within subquery

Thread by: alisag, Jan 31, 2010, 1 replies, in forum: SQL Server 2008 General Developer Questions

I wrote the following code. But i m getting error that MIN is not a recognized built in function.SELECT [Prod_ Order No_],[Location Code],[Item...

A small Doubt

Thread by: alisag, Jan 28, 2010, 5 replies, in forum: SQL Server 2008 General Developer Questions

Hi All, I wrote one query as SELECT ProdOrder.No_, ProdOrder.Description, ProdOrder.Status, ProdOrder.Quantity,ProdOrder.[Location...

Where to apply filters

Thread by: alisag, Jan 27, 2010, 2 replies, in forum: SQL Server 2008 General Developer Questions

I have the following query SELECT Item.No_, Item.Description, Table1.Inventory, Table2.[Qty on Sales Order], Table3.[Qty on Blanket Order] FROM...

A newbie question :)

Thread by: alisag, Jan 21, 2010, 14 replies, in forum: SQL Server 2005 Reporting Services

Wats wrong in this query? SELECT [Transfer Line].[Document No_], [Transfer Line].[Transfer-from Code], [Transfer Line].[Item No_], [Transfer...