gamer4eva
:D
quoted him.
Printable View
gamer4eva
:D
quoted him.
Tsangpo Gorge
AMD X2 4200+ Manchester
ASUS A8N32-SLI Deluxe ATX S939 NFORCE4 SLI X16 DDR 2PCI-E16 SATA2 RAID Sound 2GBLAN 1394 Motherboard
OCZ Platinum EL PC3200 1GB 2X512MB DDR400 (@ 2-3-2-5)
Corsair HX520 CMPSU-520HX 520W ATX Triple 12V 40A Continuous 24PIN ATX Modular 120MM Power Supply
Antec Nine Hundred Mid Tower Gamer Case
Seagate Barracuda 7200.10 250GB SATA 3GB/S 7200RPM 16MB Cache Hard Drive
eVGA 6600GT PCI-E Video Card
my specs :D
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
ALTER TRIGGER UpdateDaysUpdate ON [dbo].[Order Lines]
FOR UPDATE
AS
Declare @UpDDate as datetime,
@Exists as int,
@ClientId as uniqueidentifier
Select @ClientId = ClientNumber from Inserted
select @Exists = Count (*) from [order lines] where (ClientNumber = @ClientId)
If @Exists = 0 return
If not @clientId is null
Begin
set @UpDDate = (Select Top 1 [Date] from [Order Lines] where (ClientNumber = @ClientId) Order by [Date])
End
Else
Begin
Select @UpDDate = isnull([Date],dateadd(day,-365,Convert(datetime,getdate(),103))) from Inserted
End
Select @Exists = Count(*) from Days where (Date = @UpDDate)
set @exists = isnull(@exists,0)
if @Exists = 1
Begin
Update Days set CDUpdate = 1 where ([Date] = @UpDDate ) And (CdUpdate = 0)
End
Else
Begin
Insert into Days ([Date],CdUpdate)
Values (isnull(@UpDDate,dateadd(day,-365,Convert(datetime,getdate(),103))), 1)
End
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
:ermm:
What the hell is that?
a client merge script ...to merge duplicate clients :ermm:
i love it when you get all technical
:blushing:
i love it when you blush too :wub:
i love it when you post pictures of your boobs :wub:
I'll keep it in mind hawt stuff ;)
that smilie wasnt as sexy as i meant for it to imply
i would like a new one please
you're still my work desktop btw and tony from programming thinks you're hawt :naughty:
is he as hawt as manker says you are?
well no, obviously :pinch:
tony wears a hat even though he's indoors :ermm:
Oyez,
[10:47] <Server> 6 linked servers.
[10:47] <Server> Uptime: 21 hours, 25 min.
[10:47] <Server> Total bandwidth used: 336.668.937 bytes in, 162.243.551 bytes out.
[10:47] <Server> Last minute: 1.5 K/s in, 1.6 K/s out
[10:47] <Server> Last minute: 0 connections, 356 searches, 12 transfers
[10:47] <Server> .
[10:47] <Obscene_Messiah> hij lacht wel maar is niet blij
[10:47] <FileSharingTalk.mensap2p.com> Statistics for FileSharingTalk.mensap2p.com - SlavaNap 3.0.4 (b121)
[10:47] <FileSharingTalk.mensap2p.com> Local: 376/1000 users, 517.326 files, 29.977 GB.
[10:47] <FileSharingTalk.mensap2p.com> Local averages: 1375 files/user, 79 GB/user.
[10:47] <FileSharingTalk.mensap2p.com> Network: 1308/6154 users, 2.101.683 files, 117.821 GB.
[10:47] <FileSharingTalk.mensap2p.com> Network averages: 1606 files/user, 90 GB/user.
[10:47] <FileSharingTalk.mensap2p.com> Maximum users: 407 local, 1326 network.
[10:47] <FileSharingTalk.mensap2p.com> Maximum files: 521.312 local, 2.103.458 network.
[10:47] <FileSharingTalk.mensap2p.com> Maximum GB: 29.980 local, 117.866 network.
[10:47] <FileSharingTalk.mensap2p.com> 2.913 connections, 10.336 transfers (482 transfers per hour)
[10:47] <FileSharingTalk.mensap2p.com> 589 users have been killed for not meeting minshare.
[10:47] <FileSharingTalk.mensap2p.com> 1.601 connections blocked by local leechban table.
[10:47] <FileSharingTalk.mensap2p.com> 374.672 searches, 43.958 successful, 352.661 total hits returned.
[10:47] <FileSharingTalk.mensap2p.com> 385 sockets used.
[10:47] <FileSharingTalk.mensap2p.com> 6 linked servers.
[10:47] <FileSharingTalk.mensap2p.com> Uptime: 21 hours, 26 min.
[10:47] <FileSharingTalk.mensap2p.com> Total bandwidth used: 522.819.570 bytes in, 179.099.725 bytes out.
[10:47] <FileSharingTalk.mensap2p.com> Last minute: 6.8 K/s in, 3.1 K/s out
[10:47] <FileSharingTalk.mensap2p.com> Last minute: 1 connections, 341 searches, 12 transfers
[10:47] <FileSharingTalk.mensap2p.com> .
:-D
then who cares what he thinks?Quote:
Originally Posted by Mr. Mulder
and the other one just sounds mad mad mad
its five am tho i think i should be going to sleep
nite :) (for the four hours until i gotta get up that is)
Mines clear..... sort of. My clipboard has a Photoshop mask on it. :)
nite :wub:
Well, I reckon that's good - that you have to stay til five on Friday. We'll try to get up early so you can make up a couple of hours. I'll cook for you when you get home.
Seriously, I thought you weren't bothered 'cos yesterday you said no first when I said I would (before we decided that I would) and then this morning, you just grunted!
European Championship Qualifying
Function DisplayCurrency(Amount)
Dim currentLocale
Dim original
currentLocale = GetLocale
original = SetLocale("en-gb")
if isnumeric(Amount) Then
if Amount < 0 Then
DisplayCurrency = "-£" & FormatNumber(0-Amount,2)
else
DisplayCurrency = "£" & FormatNumber(Amount,2)
End if
else
DisplayCurrency = Amount
End if
original = SetLocale(currentLocale)
End Function
Function ConvertCurrency(Amount)
TempAmount = Amount
while (not isnumeric(left(TempAmount,1))) and (len(TempAmount) > 0)
TempAmount = trim(mid(TempAmount,2,len(TempAmount)))
wend
if isnumeric(TempAmount) Then
ConvertCurrency = ccur(Round(TempAmount,2))
else
ConvertCurrency = TempAmount
End if
End Function
5968 1558 6384 2512
Can I have your expiry date and security code as well please.Quote:
Originally Posted by enoughfakefiles
Sony Ericsson W810i
you're looking at girls phones for crabgirl, rite? :unsure:Quote:
Originally Posted by Cheese
If anyone would actually like to rewrite this as javascript, I'd be eternally grateful (until tomorrow)Quote:
Originally Posted by Barbarossa
No, I finally had "to succumb to the evilness known as having a mobile phone" so I bought the first one I saw that had a decent offer. Free Wii.Quote:
Originally Posted by Mr. Mulderyou're looking at girls phones for crabgirl, rite? :unsure:Quote:
Originally Posted by Cheese
to succumb to the evilness known as having a mobile phone
The above from my ctrl V was taken from an email from manker after I had to ask him for my girlfriend's mobile number. :pinch:
I'll have a look later.Quote:
Originally Posted by BarbarossaIf anyone would actually like to rewrite this as javascript, I'd be eternally grateful (until tomorrow)Quote:
Originally Posted by Barbarossa
Dunno if I can be bothered to fix the whole thing, but maybe I'll give you a function or two.
Unfortunately, due to the curse of deadlines, it's got to be done this morning :dabs:Quote:
Originally Posted by SneeI'll have a look later.Quote:
Originally Posted by Barbarossa
Dunno if I can be bothered to fix the whole thing, but maybe I'll give you a function or two.
I've more or less done it. In some ways Javascript is kewl. In most ways however it sucks untold amount of bawls :frusty:
Mein Kampf
job 30337
Were you able to use some premade isnumeric thing?Quote:
Originally Posted by BarbarossaUnfortunately, due to the curse of deadlines, it's got to be done this morning :dabs:Quote:
Originally Posted by Snee
I've more or less done it. In some ways Javascript is kewl. In most ways however it sucks untold amount of bawls :frusty:
'cos I remember writing one on my own.
EDit: also, I just got home, so I couldn't have done owt then anyways, posted that after getting out of bed, before I went off adventurin' in the university library.
znomre zhenya tebya pazdra vlayu llubya
http://www.theregister.co.uk/2007/03/29/diamond_geezer/
I think I was going to make a post about that earlier, but I went off to verify its verifibilisitude.
Any calls that are on the F4 I am going to move into stuarth as its getting difficult to see the F4 – I will be keeping an eye on any call and putting them all in stuarth so please go there instead of F4 until the logger starts dying down again
function isnumeric(sText) {Quote:
Originally Posted by Snee
var ValidChars = "-0123456789.";
var IsNumber=true;
var Char;
if (sText.length == 0)
{return false;}
for (i = 0; i < sText.length && IsNumber == true; i++)
{ Char = sText.charAt(i);
if (ValidChars.indexOf(Char) == -1)
{ IsNumber = false; }
}
return IsNumber;
}