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 gkittelson 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: zubinbalsara
- Order by date
-
variable worksheet name in openrowset
HI Guys, Is there a way to use a variable worksheet name in the openrowset. I need to open an excel file in my cursor, my worsheet name is not constant all the time,so i need to place a variable instead. Here is a snippet from my code declare @mysheet varchar(200) set @mysheet='sheet1$' Declare...- zubinbalsara
- Thread
- Replies: 1
- Forum: ANSI_SQL
-
How to join this 3 tables
CART ---------------- CartID ProductID 1 15 2 17 3 15 3 24 3 89 KITS ------------- Kitid(PK) ParentProductID ChildProductID 1 15 56 2 15 58 3 15 59 4 17 56...- zubinbalsara
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
