Hi mccork,

quote:

---

I copy some code from QA and then paste it into a topic reply between "code" delimiters. It pastes ok, but...

Hi Oliver,

quote:

---

I have few questions about indexes.

For example : I have one table with some user data, primary key is on field...

Hi brendthess

quote:

---

Well, I just saw this, and there is a way. Try:

CREATE PROCEDURE dbo.spRef_GetCertifications

(

@activesOnly bit

)

AS

SELECT ID, Name, IsActive, SubmittedOnGMT FROM Certification...

Hi alicejwz,

quote:

---

This stored procedure below doesn't work:

--No records created. No Syntax error

CREATE PROCEDURE dbo.spGet_qty_remaining

AS

Update tblshipping_sched

Set shipped_qty_remaining = shipped_qty_remaining - shipped_qty

where shipped_qty...

quote:

---

You do not need Outlook. You could use the Exchange client and seperately create the profile. This is covered in a couple...

Hi Diane,

quote:

---

Well, yes, QA is free, but hey, if my company will spend the money, what the heck!!

We are looking for something...

Hi Andy,

quote:

---

We can probably support the web space, don't know about letting them upload via Snitz - will have to see why...

quote:

---

Hi guarddata,

quote:

---

I'd be interested to see this one. When I use SELECT CONVERT( INT,...

Hi guarddata,

quote:

---

I'd be interested to see this one. When I use SELECT CONVERT( INT, CONVERT( VARBINARY, '0x8A' ) ) the answer comes...

Hi scking,

quote:

---

I've recently created a SQL Server 2000 database which allows changes to some of the tables but not others. The...

One thing just came to my mind.

Another really bad practice is NOT to use such a think tank as this forum is. You're really lost trying to do all by...

quote:

---

I wish it was that easy. I'm getting an error when I that says I can't convert varchar to int. ...

Hi cross,

quote:

---

I've never tried it but I know with an account and password a person can get to SQL Server tables with...

Hi timingskey,

quote:

---

Thanks Frank. This helps. Th eonly other thing is that I'm trying to do this without putting anything in...

Hi jl75@9online.fr,

quote:

---

Yes but the amount of records is absolutely huge and MsAccess can't take it !

---