Is there any good way to remove all HTML tags in a string with sql (preferably without function) that looks like this.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xml...
CREATE TABLE WeekDay (DeliveryWeekdays INTEGER NOT NULL);
INSERT INTO WeekDay(DeliveryWeekdays) values (7);
We have a program that stores an int value in a table with which weekdays you have selected in a check box.
{
None = 0,
Monday = 1...
My problem is that I want to sort a list in a special way.
Exempel:
Pos Material Location Level
10 AE Pal1 1
10 AC Pal2 2
10 AD Pal3 2
10 AB Pal3 4
30 AD Pa...
I have a field with Pos in a table. Now I want to create a group value that I will use later in a new column with sql like this:
I've tested functions for last_value and first_value, but I couldn't solve it.
Pos GroupValue
--- ----------
30 1
30...
For some reason, some field names in a table are escaped with quotes. The field names cannot be changed. What I wonder is if I via SQL with execute immediate statement etc., can remove these quotes in the field names?
Today it looks like this:
Select...
Ok, thanks.
A quick question. Your example is very good but I'm probably too stupid to understand it how works.
If I retrieve value 7 from a field in my select, how can I use the Power function to check if the day of the week in datepart (cdw, today ...
You are right, the answer in both my examples is false. I wrote wrong there.
Ok, this is probably what I'm looking for. How do I write this in a sql in a condition?
