Viewing 15 posts - 106 through 120 (of 1,048 total)
can you please tell me how merge doesn't process row by row...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 30, 2013 at 10:28 pm
can you please provide definition of your sql procedure
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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 ?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 8, 2013 at 7:20 am
I think you forget to attach the execution plan....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 8, 2013 at 7:11 am
Very good question 😛
Thanks Steve 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 6, 2013 at 9:56 pm
With the use of DISTINCT you can achieve this....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 30, 2013 at 7:26 am
marcjason (10/21/2013)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 21, 2013 at 4:40 am
Viewing 15 posts - 106 through 120 (of 1,048 total)