SQLKnowItAll (4/25/2012)

---

I think the OP is saying that this is the source table for...

SQLKnowItAll (4/25/2012)

---

deebabat (4/25/2012)

---

SQLKnowItAll (4/25/2012)

---

Lynn Pettis (4/25/2012)

---

You have many of these: [Admission ID] [varchar(255)] NULL . Change the [varchar(255)] to varchar(255) or [varchar](255). Also, no such thing as a...

SQLKnowItAll (4/25/2012)

---

+1 Lynn......

deebabat (4/25/2012)

---

Lynn Pettis (4/25/2012)

---

SQLKnowItAll (4/25/2012)

---

Lynn Pettis (4/25/2012)

---

Dang it,...

Lynn Pettis (4/25/2012)

---

SQLKnowItAll (4/25/2012)

---

Lynn Pettis (4/25/2012)

---

Dang it, I...

Erode P. Satheesh (4/25/2012)

---

"Select Count(*)" will give you only the count of the records in your result.

Adding the count will not cause you this error. The error should...

I posted the query under the "Stored Procedure help". The one you replied to is a reply to an advice given by somebody (Erode).

when i ran the select count (*) statement of the where clause, i got this error message: Msg 8114, Level 16, State 5, Line 1

Error converting data type varchar to...

the question is that i don't know why I am still getting conversion error mesage: Msg 245, Level 16, State 1, Line 2

Conversion failed when converting the varchar value 'MD-101289'...

Here is a better one

DECLARE @num INT = 102

SET STATISTICS TIME ON;

SET STATISTICS IO ON;

;WITH

L0 AS(SELECT 1 AS c UNION ALL SELECT 1),

...

Lynn, thank you so much!

Here is another method I tried and it's worked just fine.

DECLARE @num INT = 1000000

SET STATISTICS TIME ON;

SET STATISTICS IO ON;

;WITH

L0 ...

Thanks for your advice, this is what I have it's just that I am not sure it's right

WITH Numbers(Number) AS (

SELECT 1

UNION ALL

SELECT Number...

MarkusB (4/20/2012)

---

deebabat (4/19/2012)

---

BEGIN CATCH

insert into tblDownload_Import

(Description) values ('error: ' + ERROR_Number() + ' msg: ' + ...