zaher_akram (2/11/2008)

---

Hi

Is there any Version Of sql server that i can run on Linux . Or any third party tool that can make it possible to run...

alorenzini (2/8/2008)

---

I adapted your query and it looks like this:

SELECT ConsultantID

, Level

, Title

...

You could use the row_number() function, so in this case you would number the promotions for a particular person to a particular level, and ignore the first promotion to this...

You may want to look at the thread: http://www.sqlservercentral.com/Forums/Topic438574-360-1.aspx

Although it does not give you a way to find out the queries that the suggested missing indexes are based on, it...

Concerning your second question, you can use the style...

JMSM (2/8/2008)

---

Hi,

Can you tell me how can i get table(s) name from one column name that give me to put in a query?

The point is:

- They...

You can enable not sysadmin users to run xp_cmdshell by setting up a proxy account See: http://technet.microsoft.com/en-us/library/ms175046.aspx

Permission wise it will need CONTROL SERVER, so if this is not acceptable, you...

The primary key will use a clustered index, your temptable will most likely be only a heap.

Also, are you the only one accessing the table you are inserting data...

sayan ghosh (2/5/2008)

---

Hi Everybody,

We have to give CREATE, ALTER and EXEC permissions for only the SPs that needs to be created for a particular DB.

It's like we've got a...

mjafar (2/5/2008)

---

Nowadays my database is running very slow.

So I have decided to do re indexing & defragmentation.

I have did shrinking of database.

Here first time I am doing...

mjafar (2/5/2008)

---

Nowadays my database is running very slow.

So I have decided to do re indexing & defragmentation.

I have did shrinking of database.

Here first time I am doing...

rosemary (2/5/2008)

---

I have a requirement where for a given student I need to generate a comma separated field of the courses he/she is taking.

Input

Data ...

You could just use the "WITH...

Not your fault, I've added it later (the title of your post was truncated so I did not see the...

Use the LIKE keyword:

select [Shop Name] from mytable where [Shop Name] like '[0-9]%'

for numbers, or

select [Shop Name] from mytable where [Shop Name] like '[^a-zA-Z]%'

for ones that do not start with...