Wrox Programmer Forums
|
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 7th, 2006, 05:13 AM
Registered User
 
Join Date: Nov 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to pavanpareta
Default SQL SERVER Query

i have a query for SQL SERVER Any body help me.

"a table which does not have any Primary key" ok!
this table have a 100 Rows with same data in every rows or (all table has same data like "pavan").
and i want to have only two Rows; and all 98 will be deleting form the table."


Note:
1) this table does not have any kind of Unique Value in Row
2) this table have only one Column(fldName) which consist a same data like "pavan"
3) we have required only 2 Row from this table, all rows will be delete from this table.



Pavan Pareta
Software Engineer
 
Old December 18th, 2006, 04:47 PM
Authorized User
 
Join Date: Dec 2006
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to devendar
Default

Hai Pavan,

Whatever it may be data, Assign your table as source,then take row sampling with that select 2 rows send it to be Destination,
Same time Take OLEDB Command and assign unselected condition from Row Sampling to OLEDB Command.

Assign connection to OLEDB Command
Click on component properties Delete from Table

enjoy it.

Devendar Reddy

 
Old December 18th, 2006, 04:51 PM
Authorized User
 
Join Date: Dec 2006
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to devendar
Default

Quote:
quote:Originally posted by devendar
 Hai Pavan,

Whatever it may be data, Assign your table as source,then take row sampling with that select 2 rows send it to be Destination,
Same time Take OLEDB Command and assign unselected condition from Row Sampling to OLEDB Command.

Assign connection to OLEDB Command
Click on component properties Delete from Table

This works on SSIS in SQL Server-2005 OK

enjoy it.

Devendar Reddy






Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server 2005 : Query problem wkm1925 SQL Language 1 May 11th, 2008 08:30 AM
SQL server query file naeem.net SQL Server ASP 0 June 22nd, 2007 01:07 PM
SQL Server Crosstab Query elygp SQL Server 2000 2 May 5th, 2007 11:57 AM
ASP- SQL Server..Query help.... cancer10 Classic ASP Databases 5 February 1st, 2007 06:26 AM
Crosstab query in SQL Server Dhodie SQL Server 2000 3 June 17th, 2004 08:53 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.