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 TouchToneTommy 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 gtr111
-
Query to order data from one table (rows) and another table (colums)
Copernicus98, Maybe you can just normalize the BCOrder table to BcId (numeric to sort the values) BcVal (the char value) join SegBc to BCOrder and order by BcId If you can't play with BCOrder (maybe because BCOrder is used, as is, in too many other places) perhaps you can just create a...- gtr111
- Post #3
- Forum: Microsoft SQL Server: Programming
-
a SELECT statement using exec
stiej, Just look up 'SQL User-Defined Functions' in books on line. The bottom line is that you can create a function whose return value is a table - and you can use that return value just as if it were a table or view as in select * from dbo.myUdf(parm). There were many, many improvements from...- gtr111
- Post #7
- Forum: Microsoft SQL Server: Programming
-
a SELECT statement using exec
If you are using sql2k - you could employ a user defined function that returns a table- gtr111
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Reporting on differences in data
select distinct tab1.account from tab1 left join tab2 on tab1.account = tab2.account where tab2.account is null- gtr111
- Post #3
- Forum: Microsoft SQL Server: Programming
