Viewing 15 posts - 46 through 60 (of 162 total)
all these 3 tables has relation on ID column; dates are used for validation purpose
March 28, 2017 at 3:07 pm
Yeah,Yes.
It will check for If exists if there is no record it will not go inside right?
I changed the code like below - The issue is after...
March 28, 2017 at 10:05 am
I understand, With this code that you mention I am not able to get any record into insertion part
ALTER PROCEDURE CATOI (
...
March 28, 2017 at 7:49 am
The logic which i did is correct?
ALTER PROCEDURE [dbo].[ICATOU]
@ID nvarchar(40)
AS
BEGIN
SET NOCOUNT ON
IF EXISTS(SELECT 1 FROM dbo.Emp WHERE ID=@ID)
BEGIN
BEGIN TRY
...
March 27, 2017 at 1:24 pm
no that it not situation.@col1 parameter is unique, If the record already exists it will delete and again inserted.
This proc is calling form another proc where it has...
March 27, 2017 at 1:13 pm
TY, quick question suppose if i am using two If exists blocks here can i keep it in same try catch block ?
Alter procedure CATOI
@col1 nvarchar(10)
AS
March 27, 2017 at 11:42 am
Right now the data is showing as
--00000000
--02005523
So with the patindex is there a way to remove only the first 0 from the data which...
March 27, 2017 at 7:43 am
But we are not ready using Merge statement..
In the same way can I use delte from exception and again inserting into std exception table what we are doing...
March 23, 2017 at 2:29 pm
No , My logic is different, I understand his example -
But i have taken that join query outside of the cursor - there is a purpose to take that...
March 23, 2017 at 1:02 pm
I have a question on this Cnt.
This query I make it as outer cursor query
SELECT DNum,LNum,Cd,count([EMployeeUI])
March 23, 2017 at 12:22 pm
Hello Sean,
I forgot to remove paramters in my log procedure after I removed it went successful..Now theissue for me is with date format
March 22, 2017 at 3:34 pm
TY
Resolved the issue..and we are using try catch block in main procedure
Quick question on the Active Column.
In the main procedure I have declared variable called...
March 22, 2017 at 3:22 pm
This is what I have in the package -
In OLEDB Source Output
External columns
From and Todate both are - DT_DBDate
In the Outputcolumns
From and Todate both are...
March 21, 2017 at 8:23 am
Yes, I want to reporoduce the same the same that is happening in our existing system.. The error is created as 547 means it s a violation constraint.
I...
March 20, 2017 at 12:21 pm
Viewing 15 posts - 46 through 60 (of 162 total)