[font="Verdana"]

Try this ...

Procedure:

alter procedure sp_list_orcon_cat_a

@start_date datetime

as

declare @lErrorNo integer

declare @lRowsAffected integer

set @start_date = convert(datetime, '24/07/2007', 103)

begin

select convert(varchar(10), report_date, 103) AS rep_date,

priority_text,

dt_switch,

dt_arrive,

datediff(minute, dt_switch, dt_arrive) as timediff

fromdbo.cadcasedetails

where (dbo.cadcasedetails.dt_arrive...

[font="Verdana"]

shamshudheen (4/2/2008)

---

ramadesai108 (3/28/2008)

---

Hi all,

I am trying to insert a new record in true db grid with bound data from a vb6 application. The bound control is...

[font="Verdana"]Hopes, the below URL might help you.

http://www.mssqltips.com/category.asp?catid=9

Even I am blank in this area. Let me know the solution you get.

Thanks in adavace,

Mahesh[/font]

First execute the select subquery and confirm whether you are getting desired resultset. Error describes itself that your subquery is returning more that one records.

Let us know,

Mahesh

ramadesai108 (4/1/2008)

---

Mahesh,

I have a stored procedure that does only select. Then In the application I have a bound true db grid that displays the data. When...

Through DTS (Data Transfer Services) you can Import-Export data. Search Book On Line for details.

Refer below url as well.http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/dtssql2k.mspx

Thanks,

Mahesh

blahknow (3/25/2008)

---

Hi everyone

My sp recieves name of table as parameter and is supposed to show its' number of rows.

Since the table name is a variable i do it wherby Dynamic...

[font="Verdana"]

It...

ramadesai108 (3/29/2008)

---

All,

I don't think you understand how bound true db grid works. It displays data from the select query and tries to update the database using...

🙂 Don't try to do the things you like to do in project. Try those which project like. (I am talking in performance context, as Jeff has mentioned using tally...

[font="Verdana"]Better you check whether the record exist into the table before inserting. You can do in inside the SProc.

i.e.

...

If Not Exist (Select {PK column(s) From {Table} Where (where criteria)})

...

hopes it will give you an idea.

http://www.sqlteam.com/article/parsing-csv-values-into-multiple-rows

Thanks,

Refer below URLs as well.

http://www.sqlservercentral.com/articles/Stored+Procedures/2977/

http://weblogs.sqlteam.com/jeffs/archive/2007/06/26/60240.aspx

Thanks,

Better you go for XML. Build one XML string at front end and pass it to the SProc. And inside that SProc use sp_preparexml, sp_removexml system SProcs to prepare and...

[font="Verdana"]try this ...

Insert Into B Select * From A Where (the part you wants to insert into table B from table A)

Go

Insert Into C Select * From A Where...