Do you mean you need to delete all records where the value = 'Checked' or if any value = 'Checked' you're going to delete all values?

If the former, simply make...

In general terms, it doesn't sound bad, but it all comes down to the code, the indexes and the code, and if I didn't mention it, the code. How you...

Yeah, what he says.

I know you're just learning this stuff. When you get an error, look it up in the Books Online. It'll mostly tell you what's going on. In...

Hopefully this won't kick up too much mud.

I agree with some of what Steve Schmechel is advocating (if not necessarily his approach in advocating it). In working with our...

The thing to remember is that logically, they are different operations. They occur at different points in the query processing and will affect data in different ways. The JOIN criteria...

Nice article. You do a good job of outlining the issues that come up on the database side of things when doing Agile development.

The one thing I'd add is that...

shwetha004 (2/13/2008)

---

hi ppl!!

i tried using the select into statement.however, i cant see how i can actually merge two columns from two tables into one.

maybe i shud explain further.

Table1 has (userid,username,password,email,status)

Table2...

Yeah, 3 votes & one quasi-intelligent post aren't exactly encouraging. Still, you got a response. I posted on Services Center Operations Manager (SCOM) and got zip. Either no one is...

I've used both. In terms of messaging, there's no real difference between them. Blackberries are a bit more sophisticated in terms of actually chatting to other human beings, but when...

Jeff,

Doesn't the fact that floats are imprecise estimates represent a pretty major possible problem in using them in financial calculations? At least that's what I've always been told. I mean...

If you can't purchase tools, here's another option.

Definitely a backup and a restore is the much easier route. All the data, all the structure, all the statistics, just as they are in production. Done.

However, you can create...

There's this company, called Microsoft. Searching their web site can find all sorts of stuff.

I provided a link in the post above to MS's tool. Here it is exposed.

http://www.microsoft.com/downloads/details.aspx?FamilyId=5691AB53-893A-4AAF-B4A6-9A8BB9669A8B&displaylang=en

You really don't need to contact MS. The answer is 99. Matt Miller has not only documented it, he's tested it to confirm. 99 is as high as you can...