logicinside22 (1/22/2014)

---

Hi Guys ..

I am looking for How can track logins in SQL Server. Does it create new record each time in system Database ?

Like to know...

Still not totally sure what you are trying to do. I will take another shot in...

Pretty sparse on details here. I am guessing at...

What that errors says is that it is trying to insert a row into Incidents with a primary...

Have you considered changing those columns from nchar to char? One of them has 9 possible values and the other seems to be US States. With a billion rows it...

That is because there isn't a "best"...

info 63254 (1/21/2014)

---

I'm a real SQL newbie but i have an issue i think should be easy to solve - i just can't do it!!!

I have an SQL database (SQL...

dquirion78 (1/21/2014)

---

Hi l've a small bug with my formula

price : float type

qty : int type

rate : float type

formula : round(round (price* Qty,2) * rate ,2)

round( round(71.97 *1, 2) *...

TheSQLGuru (1/21/2014)

---

Sean Lange (1/21/2014)

---

SQListic (1/21/2014)

---

i All,

I want to Update column A1, when column A2 and A3both are NULL or have invalid data.

If A2 has Valid Data ignore next steps...

@mike-2 (1/21/2014)

---

Thanks Luis. Normally this would be perfect. However, in this case I cannot specify the columns. In one database, there may be 10 dimensions and 10...

@mike-2 (1/21/2014)

---

Thanks for the reply Sean. I posted example tables and data in the original message, which is consumable. I did not comment inline but it...

Remember that a query is like a table definition. It defines the columns returned. You are wanting different columns to appear in a given row. About the only way you...

SQListic (1/21/2014)

---

i All,

I want to Update column A1, when column A2 and A3both are NULL or have invalid data.

If A2 has Valid Data ignore next steps ,if A2 it...

Kurt W. Zimmerman (1/21/2014)

---

Sean Lange (1/21/2014)

---

Another option is to store the images in a varbinary(max) column. There are advantages and disadvantages to any of these options.

Kurt mentioned something about storage....

kalyan.ch (1/21/2014)

---

Thanks everyone for providing your inputs.

How it comes and what it is:

This data (Excel Sheet) comes from a manually prepared report for the leadership that provides them with...