Jared

Forum Replies Created

Viewing 15 posts - 991 through 1,005 (of 2,647 total)

RE: Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #4: Cannot find data type varchar(50)

deebabat (4/25/2012)
SQLKnowItAll (4/25/2012)
deebabat (4/25/2012)
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...

April 25, 2012 at 1:17 pm

#1479303
RE: Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #4: Cannot find data type varchar(50)

deebabat (4/25/2012)
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...

April 25, 2012 at 1:08 pm

#1479295
RE: Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #4: Cannot find data type varchar(50)

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 the...

April 25, 2012 at 12:46 pm

#1479272
RE: Restore of Database Original File Names different

Wait... I think I have it now!
You are creating a backup and have created an automated process to restore this backup to another server. However, since the filename changed,...

April 25, 2012 at 12:18 pm

#1479250
RE: Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #4: Cannot find data type varchar(50)

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 bigvarchar.
+1...

April 25, 2012 at 12:17 pm

#1479249
RE: Restore of Database Original File Names different

Jonathan Marshall (4/25/2012)
Well I tried backing up the database manually and that didn't change the fact that when I try to restore it on another server the original file name...

April 25, 2012 at 12:13 pm

#1479247
RE: Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #4: Cannot find data type varchar(50)

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... To...

April 25, 2012 at 11:03 am

#1479210
RE: Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #4: Cannot find data type varchar(50)

Let me ask you... Why are you changing these columns to VARCHAR? Specifically, the family income? That is money, not character data. I wouldn't make these changes, personally.

April 25, 2012 at 10:52 am

#1479201
RE: Restore of Database Original File Names different

Jonathan Marshall (4/25/2012)
Yes I am backing up with a maintenance plan.
So there lies the problem correct?
You haven't defined the problem. 🙂 For us, having different file names is a...

April 25, 2012 at 10:39 am

#1479193
RE: Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #4: Cannot find data type varchar(50)

Ok, now what is the new code you ran? The code that caused the error. Also, If you can... I would remove all of the spaces from your column names....

April 25, 2012 at 10:35 am

#1479190
RE: Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #4: Cannot find data type varchar(50)

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 was trying to...

April 25, 2012 at 10:07 am

#1479170
RE: Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #4: Cannot find data type varchar(50)

What Lynn is saying is to please post the statements that you ran so we can look at them and help you.

April 25, 2012 at 9:53 am

#1479152
RE: Dynamic sorting; ASC VS DESC

Chrissy321 (4/25/2012)
The code maintenance I was referring to is a stored procedure, server side, not client side.
I need the sorting server side since I am using the top keyword. My...

April 25, 2012 at 9:41 am

#1479133
RE: Dynamic sorting; ASC VS DESC

Chrissy321 (4/25/2012)
The trade off I was referring to would be in code maintenance. Using IF>ELSE I'd have two largely identical blocks of code, one ACS and one DESC. Changes would...

April 25, 2012 at 9:19 am

#1479095
RE: need some help...reporting? analasys?

Would the COUNT(columnName) function help?
SELECT COUNT(columnA)
FROM table
WHERE columnA = 'U'
Please read the article referenced in my signature to help us better help you.

April 25, 2012 at 9:06 am

#1479073

Viewing 15 posts - 991 through 1,005 (of 2,647 total)