Groups | Blog | Home


Archived Months
January 2003
March 2003
April 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
April 2008
August 2008


all groups > sql server programming > may 2005 > threads for saturday may 28

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

combine values in view?
Posted by r at 5/28/2005 3:58:17 PM
Is there an easy way to do this? I need to pull sales values for each store and make one record per month. This used to be easy, as I was provided only one sales record per month per store, but now I've been told that SOME of the stores have a "secondary" ID from which to pull sales numbers, a...more >>

There's got to be an easy way
Posted by Chris at 5/28/2005 8:35:22 AM
Hi, I have been at this since 5 am. I still can't even find proper info. I have a sp that takes a while to run and I want to have the sp create an excel file of the result and send it to several users. I created a DTS but how do I execute that DTS from withing my sp and pass a parameter to th...more >>

Debugging Stored Proc
Posted by Krishnaprasad Paralikar at 5/28/2005 3:36:01 AM
Hi, When I go to debug any SP thru Object browser in query analyser .... it starts well ... takes all the required parameters to begin ... but when I click on execute button, it completes the SP execution immediately. It does not allow to use functions like Step into, Step over etc .... Why...more >>

Send Mail with SQL Server issue
Posted by Chris at 5/28/2005 1:17:02 AM
Hi, I have a sp that takes a while to execute and I want the sp to send an email with an excel attachment of a select query from a table. Is it possible to convert the query to an excel file than send as attachment? If so wher can I find info on this. Thanks...more >>

show ???? in datafield
Posted by javad.ebrahimnezhad at 5/28/2005 12:00:00 AM
hello to all i user a sql server database report in some win 98 system the reports show ???? for data field i set " translation data" in crystal reports 8.5 to false and it was true but now in cr 9.2 i dont know where can i set " translation data" thx ...more >>

Can?
Posted by Bpk. Adi Wira Kusuma at 5/28/2005 12:00:00 AM
I make a view that get data from 2 tables (inner join, and there's no group). Can i append/edit data with its view? if I make a function that return tables, so Can i append/edit data with its function? and how also on StoreProcedure? ...more >>

change charset
Posted by Win at 5/28/2005 12:00:00 AM
I changed the charset in a web page using (<META>). Browse IE can see the contents changed. But when I view the source, the charset of data does not changed. Can I change the charset of the data ? ...more >>



DevelopmentNow Blog