Viewing 15 posts - 976 through 990 (of 6,036 total)
I need to check for the presence of a column in a temporary table...
January 23, 2017 at 11:04 pm
Look what date column is used for range selection (like BETWEEN @StartDate and @EndDate) and make that column a first one in a clustered index.
Note -...
January 23, 2017 at 2:54 pm
January 18, 2017 at 5:09 pm
January 18, 2017 at 2:55 pm
January 17, 2017 at 7:25 pm
It's done.
That's why bulk load works when executed from script.
It also works when the procedure is created WITH EXEC AS CALLER.
But it fails when created WITH EXEC AS SELF.
All operations...
January 16, 2017 at 6:28 am
January 15, 2017 at 8:52 pm
> Who fixes it when either the MDF drive or the backup drive get's filled up?
They can do it them self.
They are all sysadmins, if they can execute those...
January 15, 2017 at 5:29 pm
The forum became too difficult to read.
The text inside the buttons is too small comparing the size of the buttons.
Empty coloured (or not coloured) spaces occupy 80% of the...
January 12, 2017 at 5:18 pm
Add a primary key on @WarrPolCusts:
DECLARE @WarrPolCusts Table (
....
PRIMARY KEY (CustomerNumber, WarrantyPolicyType)
)
January 12, 2017 at 4:20 pm
Mr. Kapsicum (1/7/2017)
Output for valuerange column :
select EADPD/EAD AS valuerange from RISK_MASTER
#Output: 0.001264063461775206
You need to keep in mind that what you see as the Output is not the...
January 11, 2017 at 7:15 pm
adonetok (1/11/2017)
One column store date format like varchar below20151025
How to convert to date only (removes the time portion of a DateTime value) format like 10/25/2015?
What is it for?
What data type...
January 11, 2017 at 6:59 pm
set @oid = o.orderid
What is "o.orderid"?
Did you forget about FROM part?
January 11, 2017 at 6:54 pm
SELECT
CONVERT(DECIMAL(18,1), 10.500), -- output as a decimal
LTRIM(STR(10.500, 18,1)) -- output as a string
January 10, 2017 at 9:21 pm
Viewing 15 posts - 976 through 990 (of 6,036 total)