Viewing 15 posts - 361 through 375 (of 500 total)
Then this should work
IF EXISTS (SELECT * FROM dbo.user_character WHERE (byPCClass = 0) AND (wlevel >= 170) AND (dwMoney >= (500)) AND (Reborn = 170) AND (dwMoney >= (500)) AND...
May 27, 2009 at 4:33 pm
Jan Van der Eecken (5/27/2009)
Don't say
:kiss:
May 27, 2009 at 4:29 pm
So if an update needs to take place you want to delete all records from table2?
or only specific records from table2. If its the latter, then how do you...
May 27, 2009 at 4:21 pm
In case Frank's answer isn't completely clear you can't do it in one statement, you, but you can do it in one script, you need to use the IF...
May 27, 2009 at 3:43 pm
you can use the javascript window.print() method, however it just opens the windows print dialog box, the user still has to click the "Print" button
If you're using ASP.NET, I...
May 27, 2009 at 3:05 pm
RBarryYoung (5/27/2009)
Heh. My turn: http://www.sqlservercentral.com/Forums/Topic724398-22-1.aspx?Update=1grrrr... :angry:
Very restrained of you in not unleashing the Death Star Mr Vader
May 27, 2009 at 2:34 pm
Heres what I had to do to get an OPENROWSET query working in the end. (no need for the linked server)
exec sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO
SELECT LQ.[ORGROLE], LQ.[INACTIVE]
FROM
OPENROWSET...
May 27, 2009 at 2:12 pm
Roy Ernest (5/27/2009)
Lynn Pettis (5/27/2009)
GSquared (5/27/2009)
I have an outline and structure in mind. Now it's a matter of fleshing it out. Won't be immediate, but should be fast.
If...
May 27, 2009 at 10:23 am
I have a very similar problem at the moment.
What I'm planning to do is add the linkedserver, then use OPENROWSET to select some data from the access database into a...
May 27, 2009 at 9:38 am
GilaMonster (5/27/2009)
David Burrows (5/27/2009)
Lynn Pettis (5/27/2009)
Here is another OMG moment.OK, hang on, I'll get my Ouija board and crystal ball :w00t:
I have a tarot deck if you think that it...
May 27, 2009 at 8:55 am
Gaby Abed (5/27/2009)
Jack Corbett (5/27/2009)
Discussing this, just in jest will get the thread to 5000 posts pretty quickly.
Hmmm...a challenge? Who will be the 5000th post?
Will there be a prize?...
May 27, 2009 at 8:47 am
Grant Fritchey (5/27/2009)
Tom Brown (5/27/2009)
Bob Hovious (5/27/2009)
What's an index?We have a working title!
Chapter headings anyone?
And evidently a volunteer for the head author position. Well done.
I just about know enough...
May 27, 2009 at 8:34 am
Bob Hovious (5/27/2009)
What's an index?
We have a working title!
Chapter headings anyone?
May 27, 2009 at 8:17 am
Lynn Pettis (5/26/2009)
OMG, you really have to be kidding here...
As a complete and totally unrelated aside: -
There's a character called Trigger in the BBC comedy Only Fools 'n' Horses http://www.bbc.co.uk/comedy/onlyfools/uncovered/trigger.shtml
Why...
May 27, 2009 at 5:25 am
Viewing 15 posts - 361 through 375 (of 500 total)