CELKO (10/2/2012)

---

>> I have one column that I need split into two, the column holds age value, and the name of the column is age_at_death <<

TOTALLY WRONG! The age_at_death is...

bhushan_juare (10/3/2012)

---

[font="Courier New"]Hi All,

I am monitoring application performance using SQL script where i am using several performance counters. My Counter_Matrix table is in other dabasse where i am inserting data....

NO LIKE is not SARGable so you will get scans. It has to examine every row to determine if it is...

Thanks for the ddl and sample data. It makes all the difference.

This produces your desired results based on the sample you provided.

select UniqueID, ID, Name,

(

select Latitude, Longitude

from tab1

where ID...

Maddave (10/3/2012)

---

Thanks guys, all very interesting stuff. I'm getting more in to how this application is implemented and it's becoming scary. As Sean Lange mentioned, the developers have...

To me this seems like you don't need more than 2 tables. List and TaskList.

create table List

(

ListID int identity primary key,

UserID int not null,

ListName varchar(50) not null

)

create table TaskList

(

TaskListID int...

Vijay_Raju (10/2/2012)

---

Let me explain my requirement in detail.

I have a table A with 20 rows. I need to supply the data for my down stream system in a format...

arpish14 (10/2/2012)

---

Hello,

I am trying to create a stored procedure to perform data retrieval using a table.This table will be accessed by the third party as per the quarter information, the...

Pink123 (10/2/2012)

---

Table A

Id seq

1231

1242

1252

1263

Table B

TAbleBIDAIDAseqService

112311

212312

312313

412314

512315

612421

712522

i want to write a query which will give Table A id 124,125 ,126 as they dont have all of service(1,2,3,4,5)

i...

It doesn't look too bad. I would highly recommend you NOT name your primary key ID in every table. You should give it a descriptive name. ListID for example. Otherwise...

John Esraelo-498130 (10/2/2012)

---

Sean Lange (10/2/2012)

---

additionally, when you have multiple tables having field names of the same, such as LName, FName, Address, etc. that may appear in more than one

table...

additionally, when you have multiple tables having field names of the same, such as LName, FName, Address, etc. that may appear in more than one

table then it would be...

Vijay_Raju (10/2/2012)

---

I have a Table with 20 columns the first 12 columns needs to be same as it is, but from 13th column to 20 column i want it in...

datediff(yy, date1, date2) > 4

If you want some more detailed help you are going to have to provide something to work with. With over 600 points you are by no...

3. If multiple records found in sys.columns you will NOT cause get run-time error and will be set to one of values returned by SELECT (you cannot guarantee which one)...