Viewing 15 posts - 106 through 120 (of 1,047 total)
can you please tell me how merge doesn't process row by row...
November 30, 2013 at 10:28 pm
can you please provide definition of your sql procedure
November 30, 2013 at 7:31 am
If you dont want to insert data in Field3 then you can remove it...
OR
you can defined DEFAULT value for Field3 so that you will not get error while inserting data...
November 30, 2013 at 7:26 am
GilaMonster (11/29/2013)
kapil_kk (11/29/2013)
GilaMonster (11/29/2013)
INSERT INTO TableB ...SELECT ...
FROM TableA
WHERE NOT EXISTS (SELECT 1 FROM TableB where <column comparison>)
Sorry to mention that I also have update the record if data from...
November 29, 2013 at 5:53 am
Will it be good if I good if I use a MERGE for this and use that MERGE in a stored procedure, if MERGE not effects the performance ?
November 29, 2013 at 3:30 am
GilaMonster (11/29/2013)
INSERT INTO TableB ...SELECT ...
FROM TableA
WHERE NOT EXISTS (SELECT 1 FROM TableB where <column comparison>)
Sorry to mention that I also have update the record if data from tableA already...
November 29, 2013 at 3:28 am
$w@t (11/27/2013)
Try this
declare @ColumnNameList VARCHAR(MAX)
SELECT @ColumnNameList = COALESCE(@ColumnNameList +',' ,'') + ColumnName
FROM
<<table name>>
select @ColumnNameList
+1 🙂
November 28, 2013 at 7:15 am
David Burrows (11/26/2013)
One waySUBSTRING(@string,CHARINDEX('_',@string)+1,CHARINDEX('_',SUBSTRING(@String,CHARINDEX('_',@string)+1,255))-1)
Thanks David,:-)
I have implemented in the same manner..but I am looking for another solutions for this
November 26, 2013 at 7:03 am
Can you please post what you did to resolve your issue so that others will get benefit from that if they face similar kind of issse in performance?
November 8, 2013 at 7:20 am
I think you forget to attach the execution plan....
November 8, 2013 at 7:11 am
Very good question 😛
Thanks Steve 🙂
November 6, 2013 at 9:56 pm
With the use of DISTINCT you can achieve this....
November 6, 2013 at 9:23 pm
janki0430 (10/30/2013)
when i run this query it will take about more than 1.30 minute
plesae help me in getting recoeds in faster...
October 30, 2013 at 7:26 am
marcjason (10/21/2013)
October 21, 2013 at 5:18 am
Can you please provide some more details like table strucutre and result tant ouput and some dumy data?
October 21, 2013 at 4:40 am
Viewing 15 posts - 106 through 120 (of 1,047 total)