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 Mike Lewis 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: 1209
- Order by date
-
Select statement with Count function on 2nd table
try using the following query select id, name, (select count(*) from table2 where table2.linkid=table1.id) total from table1 Hope this is what you were looking for.- 1209
- Post #3
- Forum: Microsoft SQL Server: Programming
-
How to call Seagate Crystal Report with parameter?
The Parameters for the report can be passed as prompt0, prompt1........... depending upon the number of parameters expected in the report. If ur opening the report as a child window then pass the value for these parameters as a query string. eg...- 1209
- Post #2
- Forum: Microsoft: ASP (Active Server Pages)
-
sp help
what exactly do u want if its number of contibuters who got 1's,2's,3's or is it the list of all those contributers ? If it also includes the multiples of 2's and 3's.- 1209
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Recursive SQL
Can try with this Declare @str varchar(1000), @str1 varchar(1000) set @str='' Select @str=@str + Name + ',' from Tab_Sponsor where Reporting_To = 2 Select @str=substring(@str,1,datalength(@str)-1) set @str1=@str + ',' While Datalength(@str1) > Datalength(@str) begin /*it will be a dynamic...- 1209
- Post #2
- Forum: Microsoft SQL Server: Programming
