How would I substitute the '%and%' with a variable like:
declare @PWORD varchar(10)
set @PWORD='and'
select title_id,
substring(notes, (PATINDEX('% @PWORD %', notes)-25),
(PATINDEX('% @PWORD %', notes)+24))
FROM titles
where PATINDEX('% @PWORD %', notes)>0
Real rough...
I've never had any issues except maybe with performance.
I try to warehouse transactions after given time frame so my transaction table stays under 1,000,000 records. Even at that size I get very little performance hits.
My archive table now is split in 2, the larger ones has...
In 2000 and 2002 you have to have programming help loaded else you can't get help for programming issues. AllowBypassKey can onlt be manipulated via vba.
Using pubs as an example -
Considering the batch below, how would I loop through the 2nd select statement for the number of rows that are selected in the first select statement? Current of course it returns only the last string.
The point of this is to return a short string from each of the...
What I do in these cases, where I want the user to create their own queries, is to build a metadata table that includes the statements for the partucular query. You can make it as easy on yourself as you wish, when the user clicks a button, they get a result. Or you can allow them to select...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.