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 >>
|