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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by ranjtl
-
Stored procedure and @Tablename
looks like the first issue is that you haven't actually @t1 as a table before you try to use it as one. here's a quick demo of using a table variable. declare @t1 table( pkT1 int identity, t1Stuph varchar(50) ) insert into @t1(t1Stuph) values('This is a test. It is only a test') select *...- ranjtl
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Deleting duplicate records
to find a duplicate record do a group by with a having clause. like this: select colA, colB, count(*) from table group by colA having count(*) > 1 where colA, colB is the list of columns that need to be distinct. if you have an identity column, you can then delete the records from the...- ranjtl
- Post #2
- Forum: Microsoft SQL Server: Programming
