Viewing 15 posts - 1,696 through 1,710 (of 2,469 total)
Tony - so I cheated - so WHAT ?! Here's something from BOL for you: actually BOL is really your one-stop-shop to get you started on most everything so you'll...
**ASCII stupid question, get a stupid ANSI !!!**
July 22, 2005 at 6:53 am
have you tried querying sysservers ?!
what view are you talking about ?
**ASCII stupid question, get a stupid ANSI !!!**
July 22, 2005 at 5:59 am
"Seeing employees as stakeholders? Brilliant!!! Will it ever happen in the US?..."
It's happening with SAIC...one company I know of that is actually supposed to be a real-life working...
**ASCII stupid question, get a stupid ANSI !!!**
July 22, 2005 at 5:42 am
what verson of excel are you using ?! I just tested this with 3 different tables having varchar data types and couldn't recreate what you're seeing!
have you tried deleting the...
**ASCII stupid question, get a stupid ANSI !!!**
July 21, 2005 at 10:10 pm
Is it not possible for you to parse the string and store each value in a separate field ?!
**ASCII stupid question, get a stupid ANSI !!!**
July 21, 2005 at 9:58 pm
Hey wer - I just found out that your error is caused when using sql server 7.0 - is this the version you're using ?!
Here's the url that has more...
**ASCII stupid question, get a stupid ANSI !!!**
July 21, 2005 at 2:47 pm
I think he means 10 characters long....not char(10) - right ?!
If so, do you have any business rules that dictate how they should be generated ?!
**ASCII stupid question, get a stupid ANSI !!!**
July 21, 2005 at 2:25 pm
ok Ray - now I see where you got your black eye - good thing Remi's on vacation - else it might've been 2 (black eyes ie)..
btw - you are...
**ASCII stupid question, get a stupid ANSI !!!**
July 21, 2005 at 2:21 pm
what a shame work kept me from jumping in on the fray...who knows Tony - you might have even seen some blood....
noel - I would NEVER fight with you -...
**ASCII stupid question, get a stupid ANSI !!!**
July 21, 2005 at 2:08 pm
I changed @@IDENTITY TO SCOPE_IDENTITY() (apologies about that...)
A few options:
a) change to scope_identity and see what happens ?!
Also try:
b) SET @NumberID = IDENT_CURRENT('dbo.REJ')
&
c) SET @NumberID = SELECT MAX(IDfield)...
**ASCII stupid question, get a stupid ANSI !!!**
July 21, 2005 at 7:20 am
I have a "comments" section in every stored procedure where I note the date that any changes were made - I also store my procedures in source safe - &...
**ASCII stupid question, get a stupid ANSI !!!**
July 21, 2005 at 7:03 am
I don't know of any way this setting can be changed....you can work with QA instead as an alternative...the results don't vanish annoyingly every 5 minutes...
**ASCII stupid question, get a stupid ANSI !!!**
July 20, 2005 at 7:40 pm
Ray - I had no idea you could do an insert and select as you did....I took it one step further with:
rs_SQL = 'INSERT INTO Spa (LastMaintID, LastMaintDate) Values ('"&...
**ASCII stupid question, get a stupid ANSI !!!**
July 20, 2005 at 7:31 pm
where are you executing your procedure ?!
**ASCII stupid question, get a stupid ANSI !!!**
July 20, 2005 at 7:14 pm
"I will be more than happy to make their travel arrangements..." - unfortunately these people not only make their own travel arrangements - they also decide to take along as...
**ASCII stupid question, get a stupid ANSI !!!**
July 20, 2005 at 7:12 pm
Viewing 15 posts - 1,696 through 1,710 (of 2,469 total)