Viewing 15 posts - 4,066 through 4,080 (of 8,731 total)
After reviewing the code, I found that you are referring new_projecttasksBase which isn't included in the query. If you're referencing it, you need to add it to the JOINS.
October 5, 2015 at 11:25 am
Do you have a new_RelatedProjectId column in your new_projecttasksBase table?
That's the error, not really a syntax error on the joins, probably a misspelled column name.
October 5, 2015 at 11:21 am
Yakov Shlafman (10/3/2015)
Thanks for your article.the query for Contains ‘exact word’ will not work if the searched word is the last word on a line.
Thank you, that's actually addressed...
October 5, 2015 at 8:37 am
quagmired (10/1/2015)
This article is just another example of why lack of native "modern" regex support is holding back MS SQL.
You're probably right. I'm not sure what prevents MS to include...
October 5, 2015 at 8:35 am
Just as an FYI for the others, Khanacademy doesn't use SQL Server. Entering to the site, I found this:
Our implementation of SQL is based off of SQLite
That's why the...
October 5, 2015 at 8:02 am
Kim Crosser (9/30/2015)
I hereby take the No-UDF pledge.
From now on, I will never use a UDF. Instead, I will only write Select statements that include...
September 30, 2015 at 10:42 am
Kim Crosser (9/30/2015)
set <output_value> = Try_Convert(<type>, <source_value>);
Try_Convert returns the source_value converted to the...
September 30, 2015 at 10:39 am
Some templates can be inserted by using:
Ctrl+K, Ctrl+X or Ctrl+K, Ctrl+S
Depending on what you have configured in the Code Snippets Manager (in the Tools Menu or Ctrl+K, Ctrl+B).
I know is...
September 30, 2015 at 9:51 am
Peddi Praveen kumar (9/30/2015)
Another Approach for "Like" Search is to Use "DataLength" And "Replace" together, as shown below:
Begin
declare @lv_search_string varchar(100);
select @lv_search_string ='Parker'
SELECT * FROM dbo.LIKETest WHERE DATALENGTH(Name) <>...
September 30, 2015 at 8:21 am
I assumed that PremID was a row identifier, which would handle that when we include it in the partition of the row_number() functions. If it's not, add the TaxYear column...
September 30, 2015 at 7:57 am
ChrisM@Work (9/30/2015)
Brandie Tarvin (9/30/2015)
ChrisM@Work (9/30/2015)
September 30, 2015 at 7:44 am
Brandie Tarvin (9/30/2015)
Ugh. SQL Server is HARD.whimper
I believe HADR is HARD. 😀
September 30, 2015 at 7:32 am
That's what I call keeping your computer safe. Where can I get one of those security devices? 😀
September 30, 2015 at 7:25 am
It might be easier to just add 3 months. 🙂
SELECT PremID,
PolicyID,
DATEADD( MM, 3, CAST(...
September 30, 2015 at 7:24 am
What are you trying to accomplish with the condition WHERE Value LIKE '%' + Value + '%'?
Unless NULL values are involved, that should always evaluate to true.
September 29, 2015 at 1:25 pm
Viewing 15 posts - 4,066 through 4,080 (of 8,731 total)