Viewing 15 posts - 751 through 765 (of 851 total)
[font="Verdana"]I'm going to differ somewhat from the reponses already presented here.
The combination of default for inserts and triggers for updates will work well. However...
From a database design and even...
February 8, 2009 at 2:23 pm
funkyd (2/6/2009)
They are head of Finance so that's not really an issue.
[font="Verdana"]Tell that to the head of HR.
Some thoughts: you can create a login and grant it the data reader...
February 8, 2009 at 1:56 pm
[font="Verdana"]Ah, gotcha.
My first exposure to 64-bit Oracle was 8i on Solaris. So I don't think it was 64-bit that was the issue.
However, 9i introduced a lot of new features....
February 8, 2009 at 1:50 pm
Gift Peddie (2/5/2009)
February 8, 2009 at 1:24 pm
Gift Peddie (2/5/2009)
You starting in it does not make it relational starting with the data types, aggregate functions and DRI trigger wizard which is actually invalid in...
February 8, 2009 at 1:11 pm
[font="Verdana"]It is, as you suspected, using "some sort of character mapping". In SQL Server terminology, this is known as the "collation". The collation defines not only the set...
February 8, 2009 at 1:03 pm
[font="Verdana"]Thanks for the link! I'll have a look at it.
The way I would have done it (without dropping into CLR) is simply to have a loop through the string...
February 8, 2009 at 12:53 pm
[font="Verdana"]There are sailors in the Navy? Who knew... 😛
One of my tutors (who also became a friend, because we were both nuts of the Acorn technology, which you...
February 8, 2009 at 12:47 pm
[font="Verdana"]Judging by the change in wording in the descriptive section, this looks to me to be some sort of assignment or exam question.[/font]
February 8, 2009 at 12:37 pm
[font="Verdana"]I hadn't thought of using timestamp that way. Clever![/font]
February 8, 2009 at 12:35 pm
APARNA (2/4/2009)
When i use Patindex('ON', mystring) it does not return the string position and when I use Patindex('%ON%', mystring) it considers the ON in vLocation.
[font="Verdana"]Try:
charindex(' ON ', @myString)
[/font]
February 4, 2009 at 6:06 pm
[font="Verdana"]In the front section of your SQL code:[/font]
josephptran2002 (2/4/2009)
SELECT dbo.BOCLEARED.BOCLEARED, dbo.CTCLEARED.CTCLEARED, dbo.MECLEARED.MECLEARED, dbo.NHCLEARED.NHCLEARED,
dbo.TotalCleared.TOTALCLEARED, dbo.TotalCleared.CLEAREDDATE,...
February 4, 2009 at 5:53 pm
[font="Verdana"]Are you sure that's the query that is taking all of the time? I can run it on an instance here, and it returns instantly.
I haven't heard of the...
February 4, 2009 at 5:40 pm
Lynn Pettis (2/4/2009)
Bruce W Cassidy (2/4/2009)
Bob Hovious (2/4/2009)
I just have to blink and be the first to ask.Is this thread dead?
[font="Verdana"]Dunno about the others, but I've been getting therapy.[/font]
But I...
February 4, 2009 at 4:25 pm
[font="Verdana"]Okay. How about:
select convert(varchar(6), convert(datetime, 'AUG2007'), 112)
[/font]
February 4, 2009 at 4:19 pm
Viewing 15 posts - 751 through 765 (of 851 total)