Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: ManivannanD
- Order by date
-
SQL to return if a single row(can be>1) and certain criteria
The Following query is Generic Query, you can do it for any keyword, Select Distinct ID, KeyWord From ( Select ID, KeyWord, (Select Count(Distinct KeyWord) From Ta Sub Where Sub.Id = Main.Id) KeyWordCount From Ta Main ) as Data Where KeyWord = 'ISV' And KeyWordCount = 1- ManivannanD
- Post #3
- Forum: ANSI_SQL
-
query to copy specific records and append to table with changes
Buddy, Write a query something like this, Insert INto facility Select facilityID + 1000, othercolumns From facility; Note: You can add any number which doesnot create any duplicate with the existing record. here I added 1000..- ManivannanD
- Post #4
- Forum: ANSI_SQL
-
Inserting Records 5000 At A Time
Hey Mark I froget to add few Steps in my posting, Wrap those Insert Statements with Begin Transaction; & Commit/Rollback Transaction;- ManivannanD
- Post #5
- Forum: ANSI_SQL
-
Inserting Records 5000 At A Time
Hey mark1110, You can do it with out using DTS. If the both tables are in same tables, Insert Into Address Select * From Temp_Address; If the both tables are in same server & different Database, Insert Into [DataBaseName]..Address Select * From [DataBaseName]..Temp_Address; If the tables are...- ManivannanD
- Post #4
- Forum: ANSI_SQL
-
CHARINDEX(), comma, and stored proc ... puzzle
Stop Guys.... @BadPattern2 is declared as Char(10) so @BadPattern2 = '713,' will be stroed as '713, ' "713," with 6 Spaces... Hey warelock, use varchar instead of char for BadPattern2- ManivannanD
- Post #5
- Forum: ANSI_SQL
