yudy.varma (9/1/2012)

---

Can anybody tell me how to hide/show multiple columns based on multivalued parameter.

ex :i have two parameters

1)item

2)option(multivalued - ven,itm,qty) and values are (venr,itm,qty).

i have a dataset...

You have to choose scope of Total value.

rramsey (7/29/2012)

---

One thing I noticed is this: I expected saturday to be returned as day 7 when sunday was day 1 however; the formula, Declare @ThisDay int = (DATEPART(weekday,@ThisDate) +...

vinu512 (4/14/2012)

---

Divya Agrawal (4/14/2012)

---

RexHelios (4/13/2012)

---

Hello All,

I have the following table...

DECLARE @EmploymentHistory TABLE (

CompanyName VARCHAR (100), EmployeeName VARCHAR (100),

EmploymentBeginDate DateTime, EmploymentEndDate DateTime)

INSERT @EmploymentHistory (CompanyName, EmployeeName, EmploymentBeginDate, EmploymentEndDate)

SELECT 'Jack and Jill...

RexHelios (4/13/2012)

---

Hello All,

I have the following table...

DECLARE @EmploymentHistory TABLE (

CompanyName VARCHAR (100), EmployeeName VARCHAR (100),

EmploymentBeginDate DateTime, EmploymentEndDate DateTime)

INSERT @EmploymentHistory (CompanyName, EmployeeName, EmploymentBeginDate, EmploymentEndDate)

SELECT 'Jack and Jill Company', 'John Doe',...

No, its a command prompt cmd which need to...

You can add a stored procedure in your database which will have all the content of the script. Then you can provide the stored proc name to the deployment team...

Koen Verbeeck (4/3/2012)

---

nilesh-652355 (4/2/2012)

---

Hello...

I have following records....

CompanyID.......Quantity......Sales Year

123.................12..............2011-12

123.................34..............2011-12

123.................12..............2011-12

123.................15..............2012-13

123.................12..............2012-13

123.................12..............2012-13

Now, I want to write a view so I can get the following output

with sum of...

Do you require sum of quanity on sale year? in your example output you have two sale year rows..

You can try the query:

select customerid,sum(quantity) quantity, saleyear

from tbl

group by customerid, saleyear

If...

JimS-Indy (12/16/2010)

---

Current Query:

USE [AssetLending]

GO

/****** Object: View [dbo].[AssetsWithCurrentTrans] Script Date: 12/16/2010 11:24:57 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER VIEW [dbo].[AssetsWithCurrentTrans]

AS

SELECT dbo.Asset.AssetID, dbo.Asset.AssetDescription, dbo.Asset.AssetCategory, dbo.Asset.AssetCondition,...

danajao (9/7/2010)

---

Thanks for a very interesting tip ... problem I have though is while my expression provides me with a previous date ... it fails when moving into another month...

danajao (9/7/2010)

---

Thanks for a very interesting tip ... problem I have though is while my expression provides me with a previous date ... it fails when moving into another month...

Thanks again.

I have already written in my first...

Thanks Lutz.

Your solution i have already used for less number of columns.

There are lots of columns around 100's in the table which i need to query. Case will be...

🙂