Viewing 15 posts - 4,906 through 4,920 (of 8,731 total)
Search for "Linked Servers" and "Openquery".
May 20, 2015 at 7:05 pm
Reactions like this make me wonder if I should change my signature.
Those questions are there because some people just copy, paste and execute code without analysing what they do. I'm...
May 20, 2015 at 12:14 pm
Brandie Tarvin (5/20/2015)
Grant Fritchey (5/20/2015)
AAARRARARRGGGGHHHH!!!
Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of it ignored. Apply a random query hint....
May 20, 2015 at 11:40 am
If you want a database environment to practice, download and install SQL Server in your local computer and then install Adventureworks databases. Many sites use them for examples (the main...
May 20, 2015 at 10:38 am
Grant Fritchey (5/20/2015)
Ed Wagner (5/20/2015)
Brandie Tarvin (5/20/2015)
Grant Fritchey (5/20/2015)
AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!Dare we ask?
How about a link? You're normally so patient that it ought to be good. 😛
We've been beating this person...
May 20, 2015 at 8:54 am
pdanes (5/20/2015)
Thanks, I've looked at them. Interesting results - an order of magnitude difference from the slowest to fastest.
This might be caused by the safer method, as Dwain already...
May 20, 2015 at 8:49 am
You don't need a subquery. I did it like that to have some sample data without creating a table.
SELECT IPAddress,
PARSENAME(ipaddress, 4) + '.' + PARSENAME(IPAddress, 3) + '.' + PARSENAME(IPAddress,...
May 19, 2015 at 3:25 pm
TJT (5/19/2015)
Sorry, I should have provided more information. The IP Addresses could be any IP addresses.I was trying to use REPLACE with RIGHT statement
The solutions posted will work with...
May 19, 2015 at 2:26 pm
And an example on how to use it with a table.
DECLARE @Sample TABLE(
FileNumb int,
startdate date,
enddate date);
INSERT INTO...
May 19, 2015 at 2:22 pm
You could create a function that uses a calendar table.
Here's an example.
CREATE FUNCTION DaysBetweenInMonths(
@StartDate date,
@EndDate date
)RETURNS TABLE WITH SCHEMABINDING
AS
RETURN
WITH E AS(
...
May 19, 2015 at 2:19 pm
Alan.B (5/19/2015)
You could do this:
DECLARE @ipaddresses TABLE (ip varchar(30));
INSERT @ipaddresses VALUES
('175.139.45.127'),
('175.139.45.12'),
('175.139.45.1'),
('10.10.10.100'),
('10.10.10.10'),
('10.10.10.1');
SELECT ip = PARSENAME(ip,1)+'.'+PARSENAME(ip,2)+'.'+PARSENAME(ip,3)+'.0'
FROM @ipaddresses
Alan, that's cheating. You didn't test your code. 😛
May 19, 2015 at 2:07 pm
These are a few options to do what you're asking for.
SELECT ipaddress,
PARSENAME(ipaddress, 4) + '.' + PARSENAME(ipaddress, 3) + '.' + PARSENAME(ipaddress, 2) + '.0',
...
May 19, 2015 at 2:05 pm
SQLRNNR (5/19/2015)
If you are hiring for a senior position, you create an exam for the position, you require...
May 19, 2015 at 9:48 am
Viewing 15 posts - 4,906 through 4,920 (of 8,731 total)