Viewing 15 posts - 1,486 through 1,500 (of 2,038 total)
Gift Peddie (4/9/2009)
I am not using .NET by all my apps. I hv many apps developing in VB, ASP, ASP.NET, Delphi... i m working at multi-langue platform....
What exactly is...
April 9, 2009 at 7:46 am
Chris Morris (4/9/2009)
DECLARE @Untrimmed varchar(50), @Trimmed varchar(50)
SET @Untrimmed = 'HaveNow!/7896-7'
SET @Untrimmed = 'HaveNow'
--
SELECT @Trimmed = LEFT(@Untrimmed, (SELECT ISNULL(MIN(n.number)-1, LEN(@Untrimmed))
FROM Numbers n
WHERE n.number <= LEN(@Untrimmed)
AND NOT...
April 9, 2009 at 7:35 am
Rob Goddard (4/9/2009)
Nice Flo, much neater! Think I need to go read up on pattern matching... 😉
I'm also learning every day here... 😉
while @CharIndex <= len(@Untrimmed)
I would try to...
April 9, 2009 at 7:28 am
Hi
Thanks for sample data! 😉
Try this:
DECLARE @test-2 table (NameTrim varchar(20))
---Populate with gumpf
insert into @test-2
select 'jones/1234' union all
select 'Jones-1234' union all
select 'McDonald/56780' union all
select 'Goddard-098765'
SELECT LEFT(NameTrim, PATINDEX('%[0-9_/-]%', NameTrim) - 1)
...
April 9, 2009 at 5:30 am
Eswin (4/9/2009)
Hi while creating the view you can use CHECK_OPTION to prevent insert and update option.Check out the example:
http://www.rampant-books.com/t_super_sql_129_check_option_view.htm
Hi Eswin
I didn't know that option. Thanks also from my side!
Greets
Flo
April 9, 2009 at 5:03 am
Hi
In Management Studio Object Explorer select your table "dbo.INVENTDIM" expand the node and expand the "Indexes" node there should be an index called "I_698DIMIDX". Right click and select "Script Index...
April 9, 2009 at 4:43 am
Hi
Maybe my English is too bad, but could you explain me the difference between "median" and "average"?
Edited: Or I just don't get it... 😉
Greets
Flo
April 9, 2009 at 3:44 am
Jeff Moden (4/8/2009)
Florian Reischl (4/8/2009)
It's another concept than Lowell's but might also help in some cases. Keep in mind, if possible use CONVERT due...
April 9, 2009 at 2:52 am
twantoni (4/8/2009)
All,Thank you very much for creating forums such as this for those of us who are, at best, journeymen.
Greets 🙂
""Msg 2601, Level 14, State 1, Line 1
Cannot insert duplicate...
April 8, 2009 at 3:53 pm
Create stored procedures containing your queries and use the ENCRYPT option so they will no be available for anybody at the server. Now create a job which just executes the...
April 8, 2009 at 3:27 pm
Hi kevin
I think the main problem will be the duration of your queries in combination with a web front-end due to the server timeout.
The only way would be a AJAX...
April 8, 2009 at 3:16 pm
Have also a look to this thread:
http://www.sqlservercentral.com/Forums/Topic692679-338-1.aspx
Greets
Flo
April 8, 2009 at 3:07 pm
As first thanks a lot to Lowell for formatting the sample data!!
So Nuts, try this:
DECLARE @DrugDates TABLE
(
Drug_Name varchar(30),
Year int,
Quarter varchar(30),
...
April 8, 2009 at 2:51 pm
Hi sward
Thanks for DDL and sample data ;-).
Try this:
DECLARE @wce_ilr TABLE (
[COMPANY_Contact] [varchar](50) NULL,
[company_name] [varchar](50) NULL,
[Learner_Name] [varchar](50) NULL,
[Learner_Surname]...
April 8, 2009 at 1:17 pm
Viewing 15 posts - 1,486 through 1,500 (of 2,038 total)