Nevermind, I'm an idiot... My variables are too alike (shame on me). I was telling it look for ABC when I really needed it look for 123.... Sorry for...

Thanks everyone; however, I'm still inserting dups... :angry:

I declared my variables and the message (after I execute the script) shows me the values (because I said to print the @x,...

By Keys, I do mean PRIMARY & FOREIGN keys.

The initial order is put into the system with a primary key for that record. That PK is now used...

What is the "Log On As" set to and is the instance ID you are trying to connect to still installed?

(i.e. if the instance name = ABC, is the analysis...

Thank you for the post. It definitely helped me fix my problem! 😀

parthi-1705 (3/22/2011)

Have a look on this

declare @flg tinyint

Select @flg= case when cmptlevel=100 then 1 when cmptlevel=90 then 2 when cmptlevel=80 then 3 end

from master.dbo.sysdatabases

Select @flg

IF @flg=1...

This helps... thank you to everyone for the postings.

As always, greatly appreciated...

The problem (as you have probably already figured out from my previous post) is the ID field can, and does, contain numbers and values (such 1, 2, 6, MD4, XX2,...

Jeffery,

It is a varchar(15) datatype

See if this post helps.

http://www.sqlservercentral.com/Forums/Topic721835-338-1.aspx

You're a genuis, just in case you didn't already know that... I was stuck on this same problem and your post saved my day... THANK YOU... 😀

Thank you very much. This will do it...

http://databaseanswers.org/modelling_tools.htm

I did some research online and found a good site. Here's a great place to try all kinds of data modeling products.

Thank you very much to everyone who posted. All entries were helpful and I was able to use John's post to solve my problem.

For those who stumble on this same problem wirth SSRS R2, I also found my solution in this thread. When I installed SQL 2008 R2 Enterprise Edition, I used...