DataSource Controls :: How To Write Query Using Pivot Logic In Sql Server 2005

Jan 7, 2010

i have a table for customer forecast which contains customer, week number and quantit as columns. now i need to write query and list the week as column for each customer and each cell should have a quantity. how to write query for this using pivot logic. i dont want to use cursor.

View 3 Replies


Similar Messages:

DataSource Controls :: SQL-Query, Pivot / Having Trouble Getting It To Work?

Feb 26, 2010

I have a table that could look like the left table in the following picture, but i want to present it as the right table in the picture. http://pici.se/549963/?size=fullsize

So i've found out that i could use pivots to do this, but am having some trouble getting it to work, so if you know how to do this.

View 7 Replies

SQL Server :: How To Write A SQL Query To Present Values Horizontally 2005

Mar 2, 2011

Suppose I have one table called [Code]....:

[Code]....

I want to see the specialist name and his jobs IDs horizontally.

[Code]....

A specialist may have

[Code]....

jobs. Suppose specialist

[Code]....

has 10 jobs where BEN has 5 jobs.

In this way I want to show specialist his jobs horizontally where the number of jobs may vary per specialist.

How can I do this in SQL?

View 13 Replies

DataSource Controls :: How To Write Stored Procedure For Logic

Jan 7, 2010

i have the table with the following fields:

FromGrams
ToGrams
Price
CountryID

suppose consider the table have the value as follows:

FromGrams=10
ToGrams=100
Price=0.25
CountryID=221

if suppose user adding new range that have the value like follows:

FromGrams=50
ToGrams=120
Price=0.95
CountryID=221

then the result table will like this

FromGrams ToGrams Price CountryID

10 50 0.25 221

51 120 0.95 221

like that all conditions have to satisfy

1
0.00
1.00
0.00
13.00
0.99
US First Class
224
True

2
0.00
1.00
0.00
13.00
6.00
US Priority
224
True

3
0.00
1.00
0.00
13.00
1.99
Canada First Class
39
True

4
1.01
2.00
13.01
41.00
1.60
US First Class
224
True

5
1.01
2.00
13.01
41.00
6.00
US Priority
224
True

6
1.01
2.00
13.01
41.00
2.60
Canada First Class
39
True

7
2.01
3.00
41.01
69.00
2.20
US First Class
224
True

8
2.01
3.00
41.01
69.00
6.00
US Priority
224
True

View 7 Replies

DataSource Controls :: Update Query With Sql Server 2005?

May 2, 2010

I have select query like this :

[Code]....

View 2 Replies

DataSource Controls :: Pivot In Sql Server

Feb 26, 2010

I want this result

Id
Name
Service [code].....

View 3 Replies

SQL Server :: How To Pass Parameter To PIVOT Query

Feb 14, 2011

I tried to develop a dynamic pivot query with following code to avoid hard coding. I can got the 'Q1, Q2, Q3, Q4' dynamically and assigned to @(@quarter. But it cannot be passed to the pivot query.

[Code]....

View 7 Replies

SQL Server :: Pivot Query / Unable To Pass Dates As Parameters To Storeprocedure?

Oct 4, 2010

I am using following pivot query but not getting result as single row getting as 4 rows.

One more problem i am unable to pass dates as parameters to storeprocedure something like this

select [@date] .

SELECT 'Forecasted' AS HeadCount,
[8/1/2010], [8/8/2010], [8/15/2010], [8/22/2010]
FROM
(SELECT *
FROM TblEmpCount) AS SourceTable
PIVOT
(
SUM(EmpCount)
FOR StartDate IN ([8/1/2010], [8/8/2010], [8/15/2010], [8/22/2010])
) AS PivotTable;

I am getting result as 4 rows but i want result in single row like this

HeadCount 8/1/2010 8/8/2010 8/15/2010 8/222/2010

Forecasted 191 182 176 169

View 2 Replies

SQL Server 2005: Basic Insert - Record Logic

Aug 11, 2010

I am designing a social networking site that has a "wall" feature like the others out there today. The database has an alerts table that stores some user action worthy of sharing with his friends. For example, when a user updates his status, all of his friends are notified. The below table shows two status updates from two unique users. The first (AlertId 689 and 690) is submitted by AccountId 53. Since he has one frinend - AccountId 57 - that row is added to the table so when this user logs on, he will see Account 53's update on his wall. In the same manner, the other user's status update has four rows because he has three friends.

[AlertId] [AccountId] [CreateDate] [Timestamp] [AlertTypeId] [IsHidden] [Body]
689 57 2010-08-10 0x0000000000018725 10 0 HTML
690 53 2010-08-10 0x0000000000018726 10 0 HTML
691 53 2010-08-10 0x000000000001872B 10 0 HTML
692 52 2010-08-10 0x000000000001872C 10 0 HTML
693 51 2010-08-10 0x000000000001872D 10 0 HTML
694 57 2010-08-10 0x000000000001872E 10 0 HTML

Now, a user can comment on any given item, in this case a statusupdate. When AddComment is submitted, we are using ObjectRecordId (which is the primary key of the alert being commented on) in order to identify which statusupdate is being commented on (fyi - the objectId tells us its a statusupdate):

public void AddComment(string comment)
{
if (_webContext != null)
{
var c = new Comment
{
Body = comment,
CommentByAccountId = _webContext.CurrentUser.AccountId,
CommentByUserName = _webContext.CurrentUser.UserName,
CreateDate = DateTime.Now,
SystemObjectId = _view.ObjectId,
SystemObjectRecordId = _view.ObjectRecordId
};
_commentRepository.SaveComment(c);
}
_view.ClearComments();
LoadComments();
}

Now, the problem is that when a user wants to comment on a friend's status update, he will be using the AlertId (or ObjectRecordId in the Comments table) corresponding to his account in the alerts table. The result is that comments are only viewable by the commenter and none of his friends:

[CommentId] [Body] [CommentById] [CommentByName] [ObjectId] [ObjectRecordId] [Delete]
97 hello world. 57 GrumpyCat 7 690 0

Of course the solution to this is to do something similar to what I did in the alerts table - when somebody makes a comment, make a corresponding row for every friend in the comments table. But how do I access the AlertIds of all of my friend's status updates in the Alerts table and map them to the ObjectRecordId column in the comments table? Since I can only access the status updates corresponding to my account (and their corresponding alertids), I don't know what the alertids are for the same statusupdate in my friend's accounts.

View 1 Replies

DataSource Controls :: How To Write Exception In A Stored Procedure In Sqlserver 2005

Feb 18, 2010

give me a simple example to write an exception in stored procedure

View 2 Replies

SQL Reporting :: Write Query In Run Time In SSRS 2005

Jan 9, 2011

i want to write query in run time in SSRS.is it possible??...

View 1 Replies

DataSource Controls :: How To Write The Sql Query Or Have To Do Programmatically

Mar 3, 2010

I have a table with columns A and B, values as follows..

A B
-- --
1 11
1 12
1 13
2 21
2 22
2 23

View 7 Replies

DataSource Controls :: Sql Server 2005 Installation / Want To Go Back To Sql Server 2005?

Feb 3, 2010

i had the sql 2008 enterprise and i want to go back to sql server 2005 because in 2008 i created new database but when i did some changes in the table , it gave me an eror that i cant save thins and i need to creat new one if some one know what i'm talking aboutif not i need the sql server installation tutorial i tried by myself but probebly i did it wrong and now i cant connect well to the sql

View 2 Replies

DataSource Controls :: Write SQL Query Result To Label

Mar 22, 2010

I have the following code which writes to a Gridview:

[Code]....

Using the same methods of connecting to the database, how can I amend this code to write the result of a second query (which only returns a number) to a label?

View 11 Replies

DataSource Controls :: SQL Query Re-Write In Linq To Entity?

Jan 26, 2010

Need to figure out the correct way to do a simple SUM function in Linq, but also manipulate one of the feilds coming back by doing a Substring on it, here is the original SQL query:

[Code]....

View 1 Replies

DataSource Controls :: To Write The Query - Retrieve The Records?

Jan 16, 2010

i have a table for customer forecast with following fields.. customer, year, week, quantity. now i need to write the SP to retrive the records based on the from week,year and to week,year... like this... from 45th week of 2009 to 25th week of 2010. how can write the query...

View 4 Replies

DataSource Controls :: Write Alter Schema Query?

Jun 18, 2010

how do i write my alter schema query in Asp.net

using the sqlclient object..

View 3 Replies

DataSource Controls :: Optimize My Sql Query In Sql 2005?

Mar 23, 2010

I am working on a project where in one SQL query i am using joins to fetch data from diffrent tables. The execution time of the query is 20 seconds for 80 rows on my local server. How can i optimize this.

View 3 Replies

DataSource Controls :: How To Write A Query Which Reads Data From Optional DDL's?

May 5, 2010

I have couple of DDL's which let user choose couple of different values from it. Once the user has made his selection he clicks on the "Submit" buttion which redirects the user to the other page, which then displays table from backend SQL DB. The pages are named Page1.aspx and Page2.aspx resp. I am using Querystring to carry forward the values of the DDL's to Page2.aspx.

How can i modify the query in such a way that even if one of the DDL's is left blank the Query would ignore that and shall produce the table considering value of DDL2 in the where clause. In case both the DDL's are empty then the query will not have a where clause and shall showcase the complete table as such. I've written a query for this but it's not working the way it shoul.Here is my code for the SQLDataSource: [Code]....

View 3 Replies

DataSource Controls :: Write Select Query To Get Counts In Row Values?

Jun 2, 2010

How to write select query to get counts in row values

View 6 Replies

DataSource Controls :: Write The Query For Finding Second Highest Salary In Employee Table?

May 2, 2010

I want to write the query for finding second highest salary in my employee table how to find it??

View 3 Replies

DataSource Controls :: Sqlserver 2005, Distinct Query Result Options?

Jul 8, 2010

i need record with id 1 and 3 only how do i get in sql server 2005.(means distinct empcod onl.

View 3 Replies

DataSource Controls :: Select Query Doesn't Work When Data Is Present In Arabic MS Sql 2005

Jan 26, 2010

This query does not return any record

[code]....

View 3 Replies

DataSource Controls :: Can't Find Query's / By Right Clicking On Database Created A Query In Server Explorer?

May 17, 2010

By right clicking on my database i created a query in server explorer. But where are this query stored can't find them back. I should aspect that their is a folder query's like there is a folder tables but this isn't the case.

View 10 Replies

SQL Server :: How To Write Storeprocedure Update Special Character In Sql Server 2005

Oct 12, 2010

I am using Sql Server 2005,My table structure is below.

Create Table ComentTable(id int,coments varchar(4000))

insert into ComentTable values(1,'sanjay I don%27t Know Tamil Language')

insert into ComentTable values(1,'sanjay I don%27t Know Kanar Language')

how to write storeprocedure update coments column replace %27 to '

View 4 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved