grngarlapati (1/4/2010)

---

Hi,

I have a tool in .NET which accepts only views but i have some procedures which returns some result sets but Id is common in all the result set...

Can you explain the context?

adaa_2007 (1/4/2010)

---

insert statement with join or with multiple tables

i hav 3 tables with no unique column. n i want to insert tjhe record in 3 tables in one insert query...

OK, now try running the code I posted a couple of pages earlier. Note that it doesn't do the calculation between the two values yet, but it does show...

Well I'm relieved that we agree on this point because it paves the way to make your query much simpler and...

Hi Paul

Any chance of setting up some sample data for this? Say 12 rows, with just the columns which are referenced in your queries?

Cheers

ChrisM

abcim (12/23/2009)

---

>>Can you answer this: for any one reportID passed into the sproc to retrieve your data, what is the reportID returned by this bit:

... SELECT Top 1 ReportId FROM...

Good Lord, no - functions can be incredibly useful.

Can you answer this: for any one reportID passed into the sproc...

Can you demonstrate how to use the PIVOT T-SQL with an unknown i.e. dynamic column set?

It's always good to see the OP (original poster) posting up their final solution, it's often a source of learning and discussion. However, I feel...

Back to basics...

-- 1. Write a query which returns the rows which you want updated from the table you want to update.

SELECT DISTINCT Confirmed, Attended, R.ParticipantID, NameFirst, NameLast, C.ClassID, Title

From...

SqlUser-369680 (12/23/2009)

---

Hi,

Any info on how to sort and rank 4 columns at the same time.

I have 4 columns

Select Salary, TransAllowance, HouseAllw, Cash from Payroll

1st column should be asc - the...

john.arnott (12/22/2009)

---

Lynn Pettis (12/22/2009)

---

I'm starting to notice a trend in a few questions where people expect tables to store records in a specific order. Anyone else seeing that trend?

(Okay,...

SELECT pickdate,

rownum,

datediff(day, nextd.pickdate, d.pickdate) AS StatusDays

FROM #DaysinStatus AS d

LEFT JOIN #DaysinStatus AS nextd ON nextd.rownum = d.rownum + 1

Gosh that was quick. Here's my belated tardy effort:

-- Create a sample tally table

SELECT IDENTITY(int,1,1) as number

INTO #Numbers

from syscolumns

-- Create a sample data table

DROP TABLE #Sample

CREATE TABLE #Sample (SampleValue...