Viewing 15 posts - 1,351 through 1,365 (of 2,462 total)
Robin35 (6/17/2015)
yeah refreshing the view will solve the issue but when i query the view after adding a column to table, i get the following result.
c1c2total
533RobinNULL
655SteveNULL
Column Total...
-- Itzik Ben-Gan 2001
June 17, 2015 at 12:55 pm
<Duplicate Post Removed>
SSC Bug? :hehe:
-- Itzik Ben-Gan 2001
June 17, 2015 at 12:54 pm
Great Post Andy.
I have been everything from a DBA at a bank and in the Healthcare industry where there are the tightest controls imaginable and I have worked in...
-- Itzik Ben-Gan 2001
June 17, 2015 at 12:26 pm
This is a classic "it's not a bug, it's a feature" things...
This is one of those funky MS SQL Server View behaviors. Because the view is not Schema Bound...
-- Itzik Ben-Gan 2001
June 17, 2015 at 11:39 am
.Netter (6/16/2015)
I can't provide any code, as I haven't got that far yet.
I have built my UserSettings table where by I will be comparing the values between this table and...
-- Itzik Ben-Gan 2001
June 16, 2015 at 1:52 pm
I have been doing BI for about 8 years now and have never heard of these products. That does not mean they're not good. I looked over the website for...
-- Itzik Ben-Gan 2001
June 15, 2015 at 10:35 pm
I put together a real-life example of where the Levenshtein Distance is used.
Say you had a SQL Job or ETL package that imported data into a data warehouse or data...
-- Itzik Ben-Gan 2001
June 15, 2015 at 9:47 pm
You could apply it to a table like so:
USE tempdb
GO
CREATE FUNCTION edit_distance(@s1 nvarchar(3999), @s2 nvarchar(3999))
RETURNS int
AS
BEGIN
DECLARE @s1_len int, @s2_len int, @i int, @j-2 int, @s1_char nchar, @c...
-- Itzik Ben-Gan 2001
June 15, 2015 at 8:57 pm
sgmunson (6/15/2015)
drew.allen (6/15/2015)
sgmunson (6/15/2015)Also, just as a general rule, almost no one uses RIGHT joins because it's just not intuitive.
I've actually wondered about this. I know this is true...
-- Itzik Ben-Gan 2001
June 15, 2015 at 8:31 pm
Getting the data from Access to SQL Server is pretty easy. From SQL Server you wI'll right click on the DB where you want to import the access data, select...
-- Itzik Ben-Gan 2001
June 15, 2015 at 4:38 pm
Jeff Moden (6/13/2015)
Alan.B (6/12/2015)
It's a bad idea to use RDP to manage a DB server.
If you're going to say something like that, you need to explain why....
-- Itzik Ben-Gan 2001
June 15, 2015 at 12:25 pm
Take a look at this article:
It's a bad idea to use RDP to manage a DB server. MS Windows and SQL Server offer a variety of tools for...
-- Itzik Ben-Gan 2001
June 12, 2015 at 9:21 pm
phosplait (6/12/2015)
@Lynn, I would...
-- Itzik Ben-Gan 2001
June 12, 2015 at 6:02 pm
Check this:
http://blog.revolutionanalytics.com/2015/05/r-in-sql-server.html
-- Itzik Ben-Gan 2001
June 12, 2015 at 4:19 pm
Yes, the Scientific Method is a lot more work than making unsubstantiated claims and hitting publish, but it's also a lot more likely to produce a post that's useful, and...
-- Itzik Ben-Gan 2001
June 12, 2015 at 2:08 pm
Viewing 15 posts - 1,351 through 1,365 (of 2,462 total)