|
I am working with asp.net and MS sql server 2005. I want send an automatic mail to those status is incomplete(In my database table one column has data like either "complete" or "incomplete").
When the status is "incomplete",then send a mail daily once to "so and so email id".
Please help me
|
|
|
|
|
This was already answered in the ASP.NET forum. Please do not spam.
|
|
|
|
|
|
Krishhhhhhhhhhhhhh wrote: Not Fully answered. OK
So wait until it is, please do not crosspost.
|
|
|
|
|
Stop this bloody replies and do ur job perfectly. otherwise close ur forums
|
|
|
|
|
Krishhhhhhhhhhhhhh wrote: Stop this bloody replies and do ur job perfectly. otherwise close ur forums
This sort of language is not acceptable here, if you cannot behave like an adult you should find an alternative playground.
|
|
|
|
|
sure. y not? tell me......
|
|
|
|
|
This thread is at an end.
|
|
|
|
|
go to hell
|
|
|
|
|
Krishhhhhhhhhhhhhh wrote: I want send an automatic mail to those status is incomplete(In my database table one column has data like either "complete" or "incomplete").
When the status is "incomplete",then send a mail daily once to "so and so email id".
There are multiple ways that you can solve this. May I suggest writing a console-application that makes a SqlConnection to verify the status? It would be quite trivial to send an email from C#, and you can launch the application using Windows' task-scheduler.
Krishhhhhhhhhhhhhh wrote: Stop this bloody replies and do ur job perfectly. otherwise close ur forums
We're not being paid to answer you, and these forums are not a "company" that exists to serve others. This is a meeting-space where all kinds of people can trade idea's. Consider it a public market
I are Troll
|
|
|
|
|
Hi All,
I am savitri here.New to this part of forum. I am doing one application for Psion Teklogix Device in VC# 2003.It is Windows CE 4.2. For that i am using Visual Studio 2003. I want to create database in device. I am not getting how to use sqlite operation in device programming. I am not getting any Dll's for that SQLite.
So please tell me how to create and connect in device level programming. Give me some hints or solution.I am searching alot but not got any result.Getting struck here only. please do needful for me.
Regards,
Savitri
|
|
|
|
|
savitri wrote: I am doing one application for Psion Teklogix Device in VC# 2003.
That's probably not an i386-based device. Have you checked whether it is compiled against the correct architecture?
savitri wrote: I am not getting any Dll's for that SQLite.
Here's a sweet alternative; you can download http://code.google.com/p/csharp-sqlite/[^] code, and include them directly in your project
I are Troll
|
|
|
|
|
Hi
I have a program that needs Microsoft Sql Server for my database .
Now i want to create an installer for my program with Installshield Software and i want to know what should i add to my installer for using sql database?
|
|
|
|
|
Please don't crosspost. Answered in the C# forum.
I are Troll
|
|
|
|
|
|
Hi all
i have sql 2005 installed on my m/c.
i want to import txt file which just exported from SQL 2000.
i am using Import/Export wizard but problem is while importing it will automatically change column size and it's datatype.
means it varchar to nVarchar
size 20 to 2000
then i have to go in advanced import option and correct datatype and size for all columns
why this happens ??? where i am wrong ???
is there any setting ???
thanks in advance
koolprasad2003
Rating always..... WELCOME
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
Create the table first with the correct sizes, then import the text file into your table.
|
|
|
|
|
thanks for reply damian
i have done same thing as u told above but still i have to go in advanced import option and correct datatype and size for all columns.
how do u import your txt files ??? or is there any option for the same ???
thanks in advnace
koolprasad2003
Rating always..... WELCOME
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
Hi,
I am trying to convert a table result to a xml. For example, I have a result (Figure 1) and I want to make an xml out of it (Figure 2).
I have tried the FOR XML RAW and FOR XML AUTO but this does not seem to give me the tree structure. Any ideas?
Figure 1:
Parent Id Name
-----------------------
0 1 Root
0 2 Root 2
1 3 Child 1
1 4 Child 2
3 5 Child 3
4 6 Child 4
9 7 Child 5
Figure 2:
<NodeCollection>
<Node rId=1 Parent=0 Name='Root'>
<Node rId=3 Parent=1 Name='Child 1'>
<Node rId=5 Parent=3 Name='Child 3' />
</Node>
<Node rId=4 Parent=1 Name='Child 2'>
<Node rId=6 Parent=4 Name='Child 4' />
</Node>
</Node>
<Node rId=2 Parent=0 Name='Root 2' />
<Node rId=7 Parent=9 Name='Child 5' />
</NodeCollection>
|
|
|
|
|
|
Hi All,
Thanks for those who take an interest in reading posts like these - and I sincerely hope that at least one of you can help me.
I am fairly new at SQL (without formal trianing...) so this might be very noob.
I have inherited the maintenance of a oldish software project. I am only getting to know the code and there is lot of it, so I feel a bit desperate. OK OK I'll get to the point!
My client needs me to solve a problem ASAP. They send out mail merge letters frm the application and they have a very sophisticated piece of code that allow you to filter the client database according to many criteria. When the criteria is entered it generates an integer (iParam below) that is used to filter a few tables. We use a autogenerated SQL statement for every report to populate it. The SP looks like this:
@iParam varchar(100) AS
SELECT
ipkClientsID AS [ID],
tblClients.sClientName AS [Client: Client Name],
(SELECT CONVERT(varchar(8000), sTextValue) FROM tblReportSummary WHERE ifkID = tblClients.ipkClientsID AND iParam = @iParam AND sFieldName = 'Client: Postal Address Group (R)') AS [Client: Postal Address Group (R)] FROM tblClients
WHERE ipkClientsID IN (SELECT ifkSelectedItemsID from tblSelectedItems where sID = @iParam)
as you can see the select statement is quite simple BUT for some reason the performance has gradually deteriorated over time to the point where every report that runs, times out or crashes the application (?).
I am hoping that you can take one look at it and say: That won't work well - try THIS!, as it might be a simple way of improving the select statement.
Much obliged!!! for any help or comments.
regards
Hawk
|
|
|
|
|
You could try
SELECT c.ipkClientsID AS [ID], c.tblClients.sClientName AS [Client: Client Name],
CONVERT(varchar(8000), sTextValue) AS [Client: Postal Address Group (R)]
FROM tblClients c
Left join tblReportSummary r on r.ifkID = c.ipkClientsID
AND r.iParam = @iParam
AND r.sFieldName = 'Client: Postal Address Group (R)'
WHERE c.ipkClientsID IN
(
SELECT ifkSelectedItemsID
from tblSelectedItems where sID = @iParam
)
But I think you can best look at the Indexes on the tables.
Wout Louwers
|
|
|
|
|
Thanks Wout,
I will try your advice.
The indexes was the first thing I checked. There are indexes on both tables for all related fields - I was hoping for a quick fix there, alas my predecessor had already tried that.
I have now run through the code and it is definitely this stored proc that causes the problem. I am going to replace it with your statement and see what happens.
regards
Holger
modified on Wednesday, December 9, 2009 9:37 AM
|
|
|
|
|
30 mins or so later...
Hi Wout,
OK your revised query worked (apart from minor error in line 1).
BUT - and this is interesting - I thought I had this one licked.
However I just ran Wout's suggested statement natively in SQL Manager and it produced results very quick. I tried a different parameter (different report) and it also worked well.
I then tried to run it from code - which actually calls a SP that contains the query as Wout suggested... and ALAS it takes forever...
I tried the original statement in SQL (not from SP) and it works very quick as well.
I then called the SP from SQL manager using "EXEC sp_...." and it also took forever.
It would appear that calling this transaction from a SP dramatically slows it down.
Why is this?
Any other good suggestions?
|
|
|
|
|
Could you look at the differences between the execution plans of the query and the SP?
Wout Louwers
|
|
|
|