Click here to Skip to main content

Database

How to update records of a table automatically based on date

Krishhhhhhhhhhhhhh10-Dec-09 7:05

Krishhhhhhhhhhhhhh

10-Dec-09 7:05

Am using MS sql server 2005 database.

Table has 3 columns:
1)Id
2)Status
3)ExpireDate

If Expire Date is today then status has to become false otherwise true.
It has to done automatically. How to do it?

Please help me

Re: How to update records of a table automatically based on date

Bassam Saoud10-Dec-09 8:37

10-Dec-09 8:37

Create a sql job[^]

How to send an auto mail

Krishhhhhhhhhhhhhh10-Dec-09 7:00

Krishhhhhhhhhhhhhh

10-Dec-09 7:00

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

Re: How to send an auto mail - [ REPOST ]

Richard MacCutchan10-Dec-09 7:22

Richard MacCutchan

10-Dec-09 7:22

This was already answered in the ASP.NET forum. Please do not spam.

Re: How to send an auto mail - [ REPOST ]

Krishhhhhhhhhhhhhh10-Dec-09 7:28

Krishhhhhhhhhhhhhh

10-Dec-09 7:28

Not Fully answered. OK

Re: How to send an auto mail - [ REPOST ]

Richard MacCutchan10-Dec-09 7:34

Richard MacCutchan

10-Dec-09 7:34

Krishhhhhhhhhhhhhh wrote:
Not Fully answered. OK

So wait until it is, please do not crosspost.

Re: How to send an auto mail - [ REPOST ]

Krishhhhhhhhhhhhhh10-Dec-09 7:43

Krishhhhhhhhhhhhhh

10-Dec-09 7:43

Stop this bloody replies and do ur job perfectly. otherwise close ur forums

Re: How to send an auto mail - [ REPOST ]

Richard MacCutchan10-Dec-09 7:53

Richard MacCutchan

10-Dec-09 7:53

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.

Re: How to send an auto mail - [ REPOST ]

Krishhhhhhhhhhhhhh10-Dec-09 7:59

Krishhhhhhhhhhhhhh

10-Dec-09 7:59

sure. y not? tell me......

Re: How to send an auto mail - [ REPOST ]

Richard MacCutchan10-Dec-09 8:06

Richard MacCutchan

10-Dec-09 8:06

This thread is at an end.

Re: How to send an auto mail - [ REPOST ]

Krishhhhhhhhhhhhhh10-Dec-09 8:09

Krishhhhhhhhhhhhhh

10-Dec-09 8:09

Laugh | :laugh:

go to hell

Re: How to send an auto mail - [ REPOST ]

Eddy Vluggen10-Dec-09 11:08

10-Dec-09 11:08

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 Smile | :)

Smile | :)

I are Troll Suspicious | :suss:

Suspicious | :suss:

Sqlite Database

savitri10-Dec-09 1:04

10-Dec-09 1:04

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 Frown | :(

Frown | :(

Re: Sqlite Database

Eddy Vluggen10-Dec-09 11:20

10-Dec-09 11:20

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 Smile | :)

Smile | :)

I are Troll Suspicious | :suss:

Suspicious | :suss:

farokhian9-Dec-09 22:28

9-Dec-09 22:28

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?

Re: database [crosspost]

Eddy Vluggen10-Dec-09 0:36

10-Dec-09 0:36

Please don't crosspost. Answered in the C# forum.

I are Troll Suspicious | :suss:

Suspicious | :suss:

Niladri_Biswas10-Dec-09 0:39

10-Dec-09 0:39

First of all this is a wrong forum to ask.

Second is that , you did not specify the front end tool ythat u are using.

However, if it is dotnet application, this link will help you

Creating a .NET Windows Installer [^]

If java, this may help

MAKE AN INSTALLER FOR YOUR JAVA APPLICATIONS[^]

Niladri Biswas

problem while import TXT file

koolprasad20039-Dec-09 19:48

9-Dec-09 19:48

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

Re: problem while import TXT file

_Damian S_9-Dec-09 20:23

9-Dec-09 20:23

Create the table first with the correct sizes, then import the text file into your table.

I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!!

Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!!
Do something wonderful - make a donation to Camp Quality today!!

Re: problem while import TXT file

koolprasad200310-Dec-09 22:24

10-Dec-09 22:24

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 Smile | :)

Smile | :)

Rating always..... WELCOME

Be a good listener...Because Opprtunity knoughts softly...N-Joy

Table result to Xml

Fayu9-Dec-09 5:31

9-Dec-09 5:31

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>

Re: Table result to Xml

Riaan Booyzen9-Dec-09 20:05

9-Dec-09 20:05

Hi Fayu,

Have a look at trying for xml explicit, try this article for some help http://www.eggheadcafe.com/articles/20030804.asp[^]

Hope you get it working

SQL query optimization

Member 46483709-Dec-09 1:59

9-Dec-09 1:59

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

Re: SQL query optimization

WoutL9-Dec-09 2:30

9-Dec-09 2:30

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

Re: SQL query optimization [modified]

Member 46483709-Dec-09 3:02

9-Dec-09 3:02

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

General News Suggestion Question Bug Answer Joke Praise Rant Admin

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.