HTML has nothing to do with datatype. You just have to append the value if BIGINT in HTML tags.

When it comes to the ASP.NET, finally IIS converts the ASP.NET page...

Hi Flo,

You are very positive, to give some help on the question:-) I like that...

One question, why can't you generate the Database diagrams on the Production Server when no one is accessing the database? Does is take too many resources and time?? I never...

Hi Steve

I have one question, Is there any way to see how in many questions the person has participated in!!! i.e. leaving answering the Question Of the Day??

Check out the article from Jeff on Cross-Tab[/url]

Hi Vladan

Thank you for your explanation..

Hi Chris,

tahnk you for giving the link to the article it is very good..and very in-depth...

Its a lerning curve for me also 🙂 to get my hands on SQL!!!

forgot to post the table structure:

CREATE TABLE TT

(Year_Purchased NUMBER, Total_Purchases NUMBER)

INSERT INTO TT VALUES(2005,150);

INSERT INTO TT VALUES(2006,400);

INSERT INTO TT VALUES(2007,490);

INSERT INTO TT VALUES(2008,580);

Check out the below query

SELECT a.Year_Purchased, a.total_purchases, sum(b.total_purchases)

FROM TT a

CROSS JOIN TT b

WHERE (b.Year_Purchased <= a.Year_Purchased)

GROUP BY a.Year_Purchased, a.total_purchases

ORDER BY a.Year_Purchased, a.total_purchases

are you going to execute this query in Front-End application or any Reporting system?

In addition to the Gsquard

Couple of questions:

1) Do you know how many records you are exepecting for each "Store Material"?

2) In your output "Qty" is 1000 i.e. Max Qty of...

Casper (4/16/2009)

---

The request came in from a client. We provide them with an extract of the data in Excel format and then the records "repeat" as in my example.

They would...

use BCP

exec master..xp_cmdshell 'bcp database.owner.tablename out outputfilename -c -t "," -S servername -T'

Casper (4/16/2009)

---

Hi,

I am using the Pubs DB as an example to help phrase my question.

Query Example:

SELECT EMPLOYEE.fname, JOBS.job_desc, JOBS.job_id

FROM dbo.employee AS EMPLOYEE

INNER JOIN dbo.jobs AS JOBS

ON EMPLOYEE.job_id =...