Viewing 13 posts - 16 through 28 (of 28 total)
SQLKnowItAll (4/25/2012)
Lynn Pettis (4/25/2012)
Okay, it looks cleaner, but does it work? If so, is there another problem?
I think the OP is saying that this is the source table for...
April 25, 2012 at 1:04 pm
SQLKnowItAll (4/25/2012)
deebabat (4/25/2012)
SQLKnowItAll (4/25/2012)
Lynn Pettis (4/25/2012)
April 25, 2012 at 12:39 pm
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 bigvarchar.
+1 Lynn......
April 25, 2012 at 12:05 pm
deebabat (4/25/2012)
Lynn Pettis (4/25/2012)
SQLKnowItAll (4/25/2012)
Lynn Pettis (4/25/2012)
SQLKnowItAll (4/25/2012)
What Lynn is saying is to please post the statements that you ran so we can look at them and help you.
Dang it,...
April 25, 2012 at 10:49 am
Lynn Pettis (4/25/2012)
SQLKnowItAll (4/25/2012)
Lynn Pettis (4/25/2012)
SQLKnowItAll (4/25/2012)
What Lynn is saying is to please post the statements that you ran so we can look at them and help you.
Dang it, I...
April 25, 2012 at 10:31 am
Erode P. Satheesh (4/25/2012)
Adding the count will not cause you this error. The error should...
April 25, 2012 at 7:40 am
I posted the query under the "Stored Procedure help". The one you replied to is a reply to an advice given by somebody (Erode).
April 25, 2012 at 4:30 am
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...
April 25, 2012 at 4:01 am
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'...
April 24, 2012 at 10:44 am
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),
...
April 21, 2012 at 12:23 am
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 ...
April 21, 2012 at 12:13 am
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...
April 20, 2012 at 11:48 pm
MarkusB (4/20/2012)
deebabat (4/19/2012)
insert into tblDownload_Import
(Description) values ('error: ' + ERROR_Number() + ' msg: ' + ...
April 20, 2012 at 7:44 am
Viewing 13 posts - 16 through 28 (of 28 total)