Viewing 15 posts - 1,411 through 1,425 (of 5,109 total)
Have you had a look at ROW_NUMBER? Specifically, you need to make sure you at your PARTITION and ORDER BY expressions. I suggest having a look at the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 22, 2018 at 8:05 am
stiej1977 - Thursday, November 22, 2018 5:32 AMyes i've been using contains. The LIKE does return the row. Contains doesn't.
The post you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 22, 2018 at 5:38 am
Are you not looking for CONTAINS (Transact-SQL)? Even so, if your LIKE isn't returning a result, that means that no rows contain the string "mypartialstring".
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 22, 2018 at 5:01 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 22, 2018 at 1:42 am
I recommend against Overwrite Datasources and Datasets being set to True; especially if you're working with Dev and UAT environments.
If a folder doesn't exist on your server when...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 21, 2018 at 11:56 am
I think the thing that I really care about when i hear a company I use, or I'm looking to, has a data breach is how much that put into...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 21, 2018 at 9:04 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 21, 2018 at 8:49 am
Otherwise, RedGate offer a tool called Data Masker.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 21, 2018 at 8:47 am
If the columns all have the same name, and definition, why not just use some dynamic SQL?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 21, 2018 at 8:45 am
Give this one a go:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 21, 2018 at 7:33 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 21, 2018 at 7:30 am
Why not:
[Code]
SELECT TOP 1 WITH TIES
ID, MY_STATE, EVENT_TS
FROM #TAB1
ORDER BY ROW_NUMBER() OVER (PARTITION BY ID ORDER BY EVENT_TS DESC);[/code]
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 21, 2018 at 6:49 am
Thom,
First of all, massive thanks for the code above - that's totally nailed it!
I...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 20, 2018 at 6:05 am
When posting, you should really show your attempts too; it really helps us understand how far you've got and may mean that we don't have to do all the work...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 20, 2018 at 5:31 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 20, 2018 at 1:38 am
Viewing 15 posts - 1,411 through 1,425 (of 5,109 total)