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...

Matt Miller (4/15/2008)

---

gkruchten (4/15/2008)

---

I was asked to develop some data base recommendations for the development team to reference. One of my recommendations was:

"Consider using BIT data type columns for Boolean...

Also out of curiosity, did changing the index have an impact on performance of the query?

😎

We have a linked server setup to access a MySQL database. The view that queries the MySQL database accesses the data with the following format: FROM MySQLServer...MySQLTable.

Hope this...

Just a very simple example using just 12 rows of data. Look at the difference between how they are sorted (i.e. stored in the index).

The first data set is...

This is just a guess, but I would not be surprised that if you looked at the Execution Plan, that the query is doing an Index Scan, and if you...

A perspective employer could argue that a history of increasing salaries is a measure of competency. If you were doing the hiring and saw someone had remained at the...