Viewing 15 posts - 1,456 through 1,470 (of 2,458 total)
I think Lowell's advice was spot-on. I would definitely go the self-employed route. I started working on my own a couple years ago and wish I had done so earlier....
May 21, 2015 at 4:21 pm
I have been told that numerous applications each today with their own database are to be migrated to a common database thereby requiring that all table/object names be prefixed with...
May 21, 2015 at 3:45 pm
It's hard to guess without looking at what your SSIS packages are doing or seeing the changes in your servers' state throughout the day. Also I'm no SSIS guru but...
May 21, 2015 at 3:13 pm
Day 0 is 1/1/1900. 1 = 1 day...
SELECT CAST(0 AS DATETIME) -- 1/1/1900
SELECT CAST(1 AS DATETIME) -- 1 day afterr 1/1/1900
SELECT CAST((1.1) AS DATETIME) -- 1.1 days after...
SELECT CAST((1.5) AS...
May 20, 2015 at 7:24 pm
joffwilliams (5/20/2015)
May 20, 2015 at 7:11 pm
I'm thinking that this should do the trick:
WITH cntByYrMnth AS
(
SELECT
yr = ISNULL(r1.yr, r2.yr),
mnth = ISNULL(r1.mnth, r2.mnth),
cnt1 = ISNULL(r1.cnt1,0),
cnt2 = ISNULL(r2.cnt2,0)
FROM #raw1 r1
FULL...
May 20, 2015 at 6:05 pm
Rizk.Christopher (5/20/2015)
May 20, 2015 at 5:11 pm
Jason A. Long (5/20/2015)
Alan.B (5/20/2015)
May 20, 2015 at 4:54 pm
Luis Cazares (5/20/2015)
Those questions are there because some people just copy, paste and execute code without analysing what they...
May 20, 2015 at 4:53 pm
I have noticed that in SQL Server 2012 and 2014 (perhaps previous versions as well but I don't remember) Intellisence is just downright flaky. It goes away and comes back...
May 20, 2015 at 4:41 pm
Ditto everything Jason said. Some DDL and an example of what you are doing/trying to do would help.
Perhaps you can use this code as an example of how to...
May 20, 2015 at 3:40 pm
20 GB seems rather large for a table with 4000 rows even with the max data types, and especially since your clustered index and 1-column non clustered index is taking...
May 20, 2015 at 11:10 am
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
Ok, by "any IP address" what...
May 19, 2015 at 2:37 pm
Luis Cazares (5/19/2015)
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. 😛
I guess I didn't :blush:
May 19, 2015 at 2:32 pm
Viewing 15 posts - 1,456 through 1,470 (of 2,458 total)