I'm not sure I understand the question. But, based on what it seems to be asking, can you create a table of years and the value you want for...

subbareddy542 (7/5/2012)

---

i have developed one report in ssrs.

when i had run that report it was showing out of memory Exception.

when i was run same query in sql server it was...

I've never found Soundex() to be all that useful. It won't find that "Richard" (soundex R263) is the same name as "Rick" (soundex R200) or "Dick" (soundex D200). ...

Follow the logic of your If Else statements.

First, you test if @Degree is not equal to 0, then you have an Else If that tests the same thing, and another...

Whenever I have to modify data in production, I start with "begin transaction" and end with "rollback", run the script, use OUTPUT to check the results, and, when I'm finally...

Do you get an error message? If so, what is it?

Can you define a View that queries what's supposed to be in each file? If so, then you can use that to do one BCP operation per View, and...

See if the data here helps: http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/f11537a5-8dc9-40a8-b2e4-17874685b074

Are you using Windows 2000?

If so, this looks applicable: http://support.microsoft.com/kb/839397

Make a smaller report or get more memory in your server or get a more powerful server.

Why would you want a report with 350,000 rows displayed? Reports are usually...

Can the database be offline while you move it? If so, that makes it easy. If not, it's not too hard, but it is more complex.

If it can...

What determines whether a value goes into Column1, Column2, or Column3?

Automated basics like that are definitely a good place to start.

The most important thing about a database, however, isn't something you can automatically document. The most important thing is...

That means there are two or more records in the file that have the same primary key value.

To be more specific, we'd need at least to see the table definition.

Not free, but Redgate (owners of this site) have data and structure comparison tools for SQL Server. Click the "a community service from redgate" bit in the upper-right corner...