Viewing 15 posts - 12,466 through 12,480 (of 26,486 total)
SQLKnowItAll (4/25/2012)
You are creating a backup and have created an automated process to restore this backup to another server. However, since the filename...
April 25, 2012 at 12:28 pm
Great now he-without-any-clues is looking for an SSRS expert. Like he will even give that person the information needed to really help either.
April 25, 2012 at 12:23 pm
SQLKnowItAll (4/25/2012)
deebabat (4/25/2012)
SQLKnowItAll (4/25/2012)
Lynn Pettis (4/25/2012)
April 25, 2012 at 12:21 pm
One, unfortunately we can't see what you see. Two, how are you backing up and restoring the databases?
April 25, 2012 at 12:13 pm
Grant Fritchey (4/25/2012)
April 25, 2012 at 10:58 am
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.
April 25, 2012 at 10:54 am
Not sure. I can run your code with no problems (other than not having your database), but that was easily fixed.
April 25, 2012 at 10:37 am
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 was trying...
April 25, 2012 at 10:08 am
GSquared (4/25/2012)
Lynn Pettis (4/25/2012)
Does anyone see anything wrong with this where clause?
Where PortfolioBaseCode = Replace(@Portfolios,'@','') as reportheading1
"as" then column alias in a Where clause.
Which won't parse.
Which means it's not the...
April 25, 2012 at 10:06 am
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 subtle. 😉
April 25, 2012 at 9:56 am
Does anyone see anything wrong with this where clause?
Where PortfolioBaseCode = Replace(@Portfolios,'@','') as reportheading1
April 25, 2012 at 9:54 am
GSquared (4/25/2012)
Then the error is somewhere else in your code. Post the right part.
Gus, walk away. You will never get a full answer to any of your questions.
April 25, 2012 at 9:49 am
deebabat (4/25/2012)
April 25, 2012 at 9:43 am
If I also remember, the SSN 555-55-5555 is invalid.
Not sure about other single repeating values, but the one above is usually used in various illustrations.
April 25, 2012 at 9:28 am
S_Kumar_S (4/25/2012)
Now the question is: if datatype of column is datetime, then how 29thfeb2011 got inserted in the table. It is not allowed by sql server.
Your thinking wrong, take...
April 25, 2012 at 9:20 am
Viewing 15 posts - 12,466 through 12,480 (of 26,486 total)