Forum Replies Created
Viewing 15 posts - 301 through 315 (of 1,468 total)
-
Reply To: Filtering Customer Specific Data
Just a thought ...
What about an exclusion table (or set of tables) that you can populate per customer. Then modify your queries to exclude data based on the config table.
As...
-
Reply To: MERGE with (SERIALIZABLE) deadlocks occasionally
giga123 wrote:Thanks for the suggestions. I am still curious to know why the MERGE statement deadlocks though. Any ideas?
Here is a page with a long list of known issues with...
-
Reply To: UTF8 and varchar lengths
On my SQL 2019 instance, the behaviour does not match your explanation
-
Reply To: Getting the top unique value by group
This should get you going in the right direction
;WITH cteBase AS (
SELECT TABLE1.ID, TABLE2.Processingnumber
, rn = ROW_NUMBER() OVER (PARTITION BY TABLE1.ID... -
Reply To: Dividing data equally in 4 sessions
The following code will not divide the values exactly. But since you have a large number of records, it uses the card number to split the records. It will guarantee...
-
Reply To: Textfield comparator.
I believe that you are looking for fuzzy matches. I have never had to do it before, but this looks like it might get you started
-
Reply To: How to get these description from XML into the table?
You can take this further and split the rows into columns like this
DECLARE @XMLData xml;
SET @XMLData = '<PlaceDescriptions>
<descriptions>0|Home</descriptions>
<descriptions>1|Office|False</descriptions>
<descriptions>2|Play Ground</descriptions>
<descriptions>3|School|True</descriptions>
<descriptions>4|Movie Hall</descriptions>
</PlaceDescriptions>';
WITH cteXML AS (
SELECT descriptions... -
Reply To: How to get these description from XML into the table?
Firstly, you don't need to use sp_xml_preparedocument and OPENXML.
Secondly, your xml is not properly formed - There is an extra ">" before "</PlaceDescriptions>"
Below is code that will extract the descriptions...
-
Reply To: Count the Number of Weekend Days between Two Dates
-
Reply To: Count the Number of Weekend Days between Two Dates
I love the use of math to solve this. However, I am stumped as to why/how the math works. An explanation for Dummies would be greatly appreciated.
y /7 -- Full...
-
Reply To: Help With a Dynamic Pivot Returning All Nulls
It appears that you may have a mismatch between your @ColumnName and your @sql
- @ColumnName returns [April-19], [August-19], etc
- @sql returns MonthYearOf as [April 19], [August 19], etc
How to post data/code on a forum to get the best help.
Reply To: Need help. Find matchng Substring
You will need to test, but using PATINDEX *might* give you slightly better performance.
SELECT T1.DocumentNo, T2.LongSentence
FROM Table2 T2
INNER JOIN Table1 T1 ON PATINDEX('%' + T1.DocumentNo + '%',...
Reply To: case statement
Since your query is returning no results, it cannot display a yes/no answer.
What you need to do is change it so that it always returns a result
SELECT...
Reply To: case statement
Looks like you are missing a closing quote in the WHEN part of your case statement.
Reply To: Count the Number of Weekend Days between Two Dates
Here's my version, also no recursion, with added alias names for more clarity:
SELECT
start_date, end_date,
full_weeks * 2 +
...
Viewing 15 posts - 301 through 315 (of 1,468 total)