Viewing 15 posts - 46 through 60 (of 284 total)
I made a couple of small changes and it seems to work with your dataset
SELECT l2.RegionID,
STUFF(
(SELECT ','...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 26, 2016 at 3:58 pm
Careful LinksUp, don't depend on the ID column as there is no guarantee that it is the correct order.
😎
I had fully intended to use the ChangeDate as ordering,...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 25, 2016 at 9:20 am
Since you posted in a 2008 forum, here is a simple self-join using a cte that gives you your output. If you had access to 2012 or greater you could...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 25, 2016 at 12:09 am
vfn (10/9/2016)
I did follow what you taught me using this code . . .
but when i try to run it i get
[Microsoft][ODBC SQL Server Driver][SQL Server]Column 'PupilPersonalDetails.Surname'...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 10, 2016 at 10:42 am
vfn (10/8/2016)
i have this select . . .
the above will return this
Pupil IDFname Lname Form House...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 8, 2016 at 9:38 pm
wendy elizabeth (10/7/2016)
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 7, 2016 at 10:58 pm
Please read the link in my signature on how to format and post SQL questions. It will help get better and faster answers.
So, without any idea about the data or...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 29, 2016 at 11:38 am
Sometimes the simplest things trip you up.
Thanks for the extra set of eyes. With a bit of tweaking, it worked perfectly.
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 6, 2016 at 11:48 am
Do you backup the log file on any consistent basis?
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 29, 2016 at 2:23 pm
GilaMonster (6/29/2016)
Just keep in mind that the point of batching isn't necessarily to delete faster, it's to have less impact on other queries (via locks) and less impact on the...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 29, 2016 at 4:11 pm
Sree Divya (6/29/2016)
thankscan you please share the code
how to delete by batch wise
That is something only you can answer. I have no idea what your table looks like and what...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 29, 2016 at 3:47 pm
GilaMonster (6/29/2016)
Gah!!!
My bad. I mis-interpreted what I had read in the docs. It said something along the lines that transactions are logged but that the space used will be...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 29, 2016 at 2:57 pm
Sree Divya (6/29/2016)
we are using below script for delete records.but it is taking time
USE AdventureWorks2008R2;
GO
DELETE * FROM Purchasing.PurchaseOrderDetail
WHERE DueDate = '20020701';
GO
is there any possibility of chance to delete the rows...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 29, 2016 at 2:22 pm
Glad it worked for you.
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 29, 2016 at 11:20 am
This query will work for your test data set. If your real data is different than your sample, then the left join and where clause will have to be tweaked....
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 28, 2016 at 9:58 am
Viewing 15 posts - 46 through 60 (of 284 total)