Viewing 15 posts - 1 through 15 (of 36 total)
Thank you very much! That is what I was looking for. I do appreciate your help.
February 23, 2024 at 5:10 pm
There is a cursor in the SP and in it there is this code:
Select * from dbo.web_Online_Library_Products where RIGHT(PRODUCT_CODE, 3) = 'WFM' and SOURCE_NUMBER = @SN and CHAPTER_NUMBER...
February 22, 2024 at 8:21 pm
I always use SET NOCOUNT ON.
February 22, 2024 at 5:47 pm
In SQL Management Studio Query windows SQLQuery#.sql that was open when the stored procedure was executed.
February 22, 2024 at 5:45 pm
Thank you, Scott, so much. I corrected my data in #xr table and it works. I do appreciate your help.
February 13, 2024 at 8:27 pm
Thank you very much! It works!
January 24, 2020 at 1:36 pm
Insert INTO does work. Thank you.
January 23, 2020 at 4:25 pm
I created temp table and put single quotations:
SELECT *
INTO #tmpTable
FROM
EXEC iMIS_MCLE_Prod.dbo.sp_isg_write_Firm_Data @Start_Date=N'2020-01-01', @End_Date=N'2020-01-22'
Msg 156, Level 15, State 1, Line 12
Incorrect syntax near the keyword 'EXEC'.
January 23, 2020 at 4:05 pm
Unfortunately it did not work.
I tried this way before:
SELECT *
INTO #tmpTable
FROM
EXEC iMIS_MCLE_Prod.dbo.sp_isg_write_Firm_Data @Start_Date=N2020-01-01, @End_Date=N2020-01-22
and I received this error:
Msg 156, Level 15, State 1, Line 12
Incorrect syntax near...
January 23, 2020 at 3:57 pm
Thank you John. I am wondering why should I specify my version of SQL Server or it should be the Database Name?
January 23, 2020 at 3:39 pm
August 29, 2018 at 7:05 am
August 28, 2018 at 12:01 pm
August 28, 2018 at 11:59 am
August 28, 2018 at 11:36 am
Viewing 15 posts - 1 through 15 (of 36 total)