Viewing 15 posts - 616 through 630 (of 1,246 total)
DROP TABLE #Players;
GO
CREATE TABLE #Players (
p_id int IDENTITY(1,1) PRIMARY KEY,
p_username varchar(50)
);
GO
INSERT INTO...
September 3, 2017 at 8:15 pm
You can use something like the following... If the "/" delimiter is present, then it will split the value into FirstName & LastName. If the delimiter is not present then...
September 3, 2017 at 7:36 pm
A permanently disabled FK serves no purpose.
Just a though... Would it be possible to dump the orphans into an orphan table and keep them there unlit the parents...
September 1, 2017 at 2:46 pm
Here is a dynamic sql solution...
IF OBJECT_ID('tempdb..#TEST_TABLE', 'U') IS NOT NULL
DROP TABLE #TEST_TABLE;
CREATE TABLE #TEST_TABLE (
id int NOT NULL,
employee_id...
September 1, 2017 at 11:47 am
I've not done a deep dive but I think the difference in estimates...
September 1, 2017 at 9:22 am
Heh... I've said it before and I'll say it again, great minds think...
August 31, 2017 at 9:36 pm
I suppose I throw in a solution myself...CREATE TABLE #OutputResultSet (
value INT,
dataitemuniverseid INT,
startdate DATETIME,
Pubsourceid VARCHAR(50),
PubsourceName VARCHAR(50)
);
INSERT #OutputResultSet (value, dataitemuniverseid, startdate, Pubsourceid, PubsourceName)...
August 31, 2017 at 8:31 pm
August 31, 2017 at 6:40 pm
If you're only interested in getting the first & last values from the string, there should be no need to use a splitter function.
See if the following returns the...
August 31, 2017 at 10:54 am
See if this is going in right direction...IF OBJECT_ID('tempdb..#EquipmentBooking', 'U') IS NOT NULL
DROP TABLE #EquipmentBooking;
CREATE TABLE #EquipmentBooking (
xRow INT NOT NULL PRIMARY...
August 31, 2017 at 10:02 am
August 30, 2017 at 12:38 pm
Looking at the code, at least at first glance, it looks like this doesn't need a cursor at all.
You should be able to these updates in sets....
August 30, 2017 at 11:12 am
Viewing 15 posts - 616 through 630 (of 1,246 total)