Viewing 15 posts - 17,236 through 17,250 (of 18,926 total)
I don't have nor know where to get that list, but I think that if you convert the cross join from a delete to a select, that you will get...
June 8, 2005 at 7:30 am
This query returns :
10JohnA
10John1A
20Mack
30Rock
40SilkB
40MannC
if I understand his requirements he wants this (without the __) :
10JohnA
__ John1__
20Mack
30Rock
__SilkB
40MannC
June 8, 2005 at 7:28 am
Totally agree with that Frank. Keep the server serving and the application applicating the presentation
.
June 8, 2005 at 7:22 am
I' surprised nobody saw that mistake :
Replace (html, '<', ' ', '> ')
June 8, 2005 at 7:17 am
Maybe if you can answer this :
how do you invalidate 1 - 5 , 2 - 3 from
1 - 3 , 2 - 5, 1 - 5 ,...
June 8, 2005 at 7:07 am
Try updating less rows at the time. It'll take much less ressource to do this task.
if object_id('Test') > 0
DROP TABLE Test
GO
CREATE TABLE [Test] (
[id] [int] NOT NULL ,
[Name] [sysname]...
June 8, 2005 at 6:53 am
I think that this task would be much easier to handle at the client side. You could use group by on the report to remove some of the doubles,...
June 8, 2005 at 6:38 am
This is not the case for me. I didn't have #temp table or table variables in my trace.
June 8, 2005 at 6:35 am
God I hope he's done by that time (unless it's a 24H shop???).
June 8, 2005 at 6:34 am
Yup, looks like you're stuck with the cast anyways :
Declare @X as datetime
set @X = GetDate()
Select case when @X is null then 'some text' else @X end
--2005-06-08 08:11:26.967
set @X...
June 8, 2005 at 6:26 am
How long does it take to just run the select without transfering to access?
June 8, 2005 at 6:21 am
There's no easy way around this, basically what sql server is telling you is that the insert was rolled back because the primary is already in the table (the PK...
June 8, 2005 at 6:17 am
It would look something like this :
Delete from Table100 where exists (Select * from Table20 B where Table100.title = B.title and Table100.forename = B.forename And Table100.surname = B.surname and Table100.address1...
June 8, 2005 at 6:15 am
There's a little catch with the isnull function. It returns the same datatype and same lenght as the input value. This also means that each paramater must be...
June 7, 2005 at 8:37 pm
Viewing 15 posts - 17,236 through 17,250 (of 18,926 total)