xoom (10/3/2012)

---

Hi,

i have to solve the following problem. We used DoubleTake for the event of a disaster in SQL Server 2008 R2 environment. The prod database server is mirrored 1:1...

select *, ROW_NUMBER() over (PARTITION BY cStudentId Order by dtEnrollmentDate) as RowNum

from #temp1

surma.sql (10/3/2012)

---

Thanks for Your reply

My question is,

Is it possible in SQL, I increment Row Number while i am...

This should do it.

ROW_NUMBER() over (PARTITION BY cStudentId, Order by tEnrollmentDate)

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