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 IamaSherpa 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: lobocheese
- Order by date
-
Delete from Multiple tables
perfect, thank-you gmmastros! great little undocumented feature sp_msforeachtable - I've just been looking it up.- lobocheese
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Delete from Multiple tables
Hi there, can this be done - here is the subquery that I'd like to use : SELECT name FROM dbo.sysobjects WHERE (xtype = 'U' AND name LIKE 'd_ord%') AND (name NOT LIKE 'D_Ord_Act_Type') Can this be incorporated into a Delete From clause? if not there is only likely to be less than 100 tables...- lobocheese
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Named Calculations in Data Source Views
Hi there, I'm currently creating a Report Builder model (my first one!) and need to know 1. Can I reference a Named Calc from another Named calc? e.g. if I have a Named Calc called Calc 1 how do I refer to it in this example of a Named Calc called Calc 2 : CASE (Calc 1) WHEN 0 THEN 0 ELSE...- lobocheese
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Reporting Services
