Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to have my spreadsheet connect to SQL Server with variables...?
I have this Stored Procdure but don't know how to incorporate variables into
it. I've added the declare statements and what I think the variables should be and where I think they should go. I have an example of the code for Excel, if I can just get these variables to work.... Any help would be appreciated Kelvin ++++++++++++++++++++++++++++++++++++++++++++++ set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO -- CREATE PROCEDURE [dbo].[CIT_SV_TechLaborByRo] ALTER PROCEDURE [dbo].[CIT_SV_TechLaborByRo] AS BEGIN DECLARE @RoNumber (this would be equal to the [SlsId]) DECLARE @TechID (this would equal [EmpIdLbr]) SELECT SVSLSITM.HrsActual FROM SVSLSITM WHERE [SVSLSITM].[SlsId]= @RoNumber AND [SVSLSITM].[EmpIdLbr]= @TechID; END ++++++++++++++++++++++++++++++++++++++++++++++ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to have my spreadsheet connect to SQL Server withvariables...?
No one will be able to understand the code. Paste the actual code. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Connect to SQL Server | Excel Programming | |||
Connect to OPC / DDE server | Excel Worksheet Functions | |||
How can I use VBA to connect to a SQL server? | Excel Programming | |||
connect to an oracle server | Excel Programming |