And I know salesmen who make twice what I do.

Based on all I have read from your posts, you don't belong in IT. Find a different career, one more...

I would also look for a local Microsoft SQL Server Users Group. Get involved and network, and you may find openings that you may miss otherwise.

😎

Mark,

You know, for the right person there is really good money in selling used cars. Your lack of honesty, integrity, and ethics makes a career in IT totally unsuited...

Look at the execution plan. SQL may have converted the IN to an inner join, and when there isn't a match, it returns quickly.

😎

When you pull up the properties, click on the Files page. You will see where your .mdf and .ldf files are located there.

😎

You have an alter table in your post, so I have to ask, what are you trying to do? Are you trying to reseed the identity field? What...

want_to_know (4/17/2008)

---

Hi

I need to select last two characters of a field like the field has codes

Ex:

abcDE

cccDE

bbbDE

and i want to get the codes that has the last...

I actually like Pepper Jack! :w00t:

I have to say this is ridiculous at this point. A lot of good people tried to give you good advice. In this field, integrity and honesty are...

I use either of these two: 'yyyymmdd hh:mm:ss.sss' or 'yyyy-mm-dd hh:mm:ss.sss'

The first should work regardless of regional settings.

😎

You provided some sample data, how about showing us what you would expect the output of the query based on that data? It would help us in developing possible...

-- Personal Opinion

By lying to get a job you have shown a lack of honesty and integrity. Not the character traits I want to see lacking in this career...

Except for a little reformating of code (I made NO changes to the actual logic) I received no errors. Here is all my test code:

create table dbo.CoursePar (

...

Post your query, maybe we will see what's wrong.

😎

Matt Miller (4/15/2008)

---

Lynn Pettis (4/15/2008)

---

#1 is really a "it depends". If the number of 0's and 1's is about even, then yes the selectivity is questionable. I used...