You're welcome.

Always Happy to help.

SQL is simply a query language. It would give you all the results depending on the query you ask. So, it is upto you to ask the right query. If...

The Update Syntax seems fine.

Have you tested the Select Query??....If the Select Query works fine then I think that $desiredProduct, $desiredYear and $desiredMonth would not be the ones causing problems...

Considering the urgency of the requirement and the vagueness of the question, the following link seems to be an apt solution:

SSIS Tutorial

ColdCoffee (4/16/2012)

---

How about this?

Setting up the sample data

DECLARE @tab TABLE

(

ID INT

,Tym TIME

,Axn INT

)

INSERT @tab

...

This might help:

Pivot two or more columns in SQL Server

Does Case matter in SQL Server?

Anyways, you can rename the column as follows:

sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN'

Try these for Distinct:

SET @Project_ID =...

Windows Explorer....Can you see it at the location where you saved it?

capn.hector (4/14/2012)

---

vinu512 (4/13/2012)

---

Seems like ETL to me. The various branches can accumulate the data in XML form or in the form of Excel sheets. This data can then be mailed...

PaulB-TheOneAndOnly (4/14/2012)

---

You cannot do it.

A Primary Key is a Referential Integrity constraint that exclusively allows unique values and does...

Grass (4/14/2012)

---

I think I actually found out which part of the code is giving the error. It is on the first two SET statements when I pass the three variables...

+1 on dat Fitz.

Forgot to add the part about Clustered Index Views.

Views are virtual parts of one or more Physical tables. Following is a good article about Views:

Views in SQL Server[/url]

Although Views are present in a Database they do not consume...

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 Company',...