Viewing 15 posts - 991 through 1,005 (of 2,458 total)
The UpdateDt column in the Users table is DATETIME so I wouldn't expect any datatype conversion issues.
Perhaps... To know for sure check the query plan (the actual query plan, not...
February 17, 2016 at 2:31 pm
Sergiy (2/17/2016)
Make the PK on UserID non-clustered and create a clustered index on UpdateDt.
Unless UpdateDt is not unique. Then perhaps a clustered index on composite key consisting of UpdateDt and...
February 17, 2016 at 2:25 pm
The SQL Server Analysis Services (SSAS) Tutorial[/url] on mssqltips aint bad as it uses adventureworks as an example which is available online for free. If you are serious, I strongly...
February 17, 2016 at 2:20 pm
Did what I posted help?
February 17, 2016 at 1:58 pm
Implicit conversion is treating your '' value as a zero and making the column a numeric column. When you query a numeric column:
WHERE Column3 = ''
is the same...
February 17, 2016 at 11:23 am
Eric M Russell (2/17/2016)
Local user group meetings offer a similar experience. Also, you can find tons of recorded presentations on sites like YouTube and SQLBits.
+1
There's so much good free...
February 17, 2016 at 10:45 am
Luis Cazares (2/17/2016)
You might want to reduce your varchar length. I've never heard of a common use for such large numbers.
haha - I missed the comment about converting to varchar(100)....
February 17, 2016 at 10:40 am
When Redgate SQL in the City comes around that's similar to SQL Saturday. I know this was not your question but it's worth mentioning.
I don't know about the other...
February 17, 2016 at 10:01 am
Here's two options:
DECLARE @table TABLE (CashFlowCoverage int);
INSERT @table VALUES (1),(2),(-999),(999);
SELECT CashFlowCoverage = NULLIF(NULLIF(CashFlowCoverage,-999),999)
FROM @table;
SELECT CashFlowCoverage = NULLIF(ABS(CashFlowCoverage),999)
FROM @table;
EDIT: changed the column name
February 17, 2016 at 9:54 am
It's been awhile since I wrote an LDAP query...
If you can post some sample data for what of #tempAD I'm sure I can help you.
February 17, 2016 at 9:32 am
Luis beat me to it. Note the code/comments below.
DECLARE @table TABLE (NumericColumn int);
INSERT @table VALUES (1),(2),(-999);
-- This WONT work because blanks on numeric columns are returned as 0's
SELECT NumericColumn...
February 17, 2016 at 9:27 am
SQL!$@w$0ME (2/17/2016)
Thanks.For VARCHAR [varchar(MAX) & varchar(800] fields on two different tables. This fields are intended to use in WHERE CLAUSE (using 'like').
You can't add a nonclustered index with a varchar...
February 17, 2016 at 7:04 am
trvlbabie (2/16/2016)
It is giving me the following error: SQL API: [SQLExecDirectW], SQL RETURN: [-1], SQL STATE: [42000], SQL NATIVE ERROR:...
February 17, 2016 at 6:48 am
Viewing 15 posts - 991 through 1,005 (of 2,458 total)