Thanks. Final question:

SELECT COUNT(*)

FROM [DI81SW].[CNET_EXP].[dbo].[NOYAU_NUM_TELEPHONE] AS CNet WITH (NOLOCK)

WHERE (CNet.[SMS] = 1)

How many rows are returned by this?

This is where it will be run from always?

The other server - DI81SW - this is a linked server?

It's not really appropriate for a function, but a stored procedure could do the job - taking tablename, starting position and ending position as parameters. It would involve dynamic SQL....

ERIC CRUDELI (3/25/2013)

---

I got some errors.

1 - easilyPatId unknow (easilyPadId come from #temp2)

2 -target table ' DI628SW.NOYAU_PATIENT.noyau. TELEPHONE_PATIENT ' of the clause OUTPUT INTO cannot be next to a...

😉

You will probably have to aggregate by date then by month/docname to eliminate multiple visits per day. Follow Sean's advice - read the article, post ddl and dml to provide...

Steve JP (3/27/2013)

---

Steve JP (3/26/2013)

....

The issue with the convert is that the 3rd arguement is the style and is used to set the style when you convert from a datetime...

kayser.b (3/27/2013)

---

Hi all,

I have a problem with my "union" query, this a sample of my query. What I'd like to obtain is my 'effectif_enseignant' and my 'effectif_biatss' in two...

Hover over each of those clustered index seek operators and examine the columns output. What would you want a lookup for?

Steve JP (3/27/2013)

---

Dont totally agree with this as the following will error which is as...

You're welcome.

Taking it one step further (combining both queries into one, using variables for the current and new row id's), you might write something like this:

DECLARE @OldPos INT, @NewPos INT

--...

Here's a guess.

SELECT

CASE WHEN v.[Vendor Name] IS NULL THEN 'No Vendor' ELSE v.[Vendor Name] END AS TD,

e.TimesheetID AS TD,

e.UserName AS TD,

e.WorkOrderNbr AS TD,

format(e.ErrorDate, 'd')...

aaron.reese (3/26/2013)

---

I use ID fields to provide me with an absolutely unique (to the table) value that can be used as the Foriegn key to other tables. Its value...

fergusoj (3/26/2013)

---

I have found a code that brings back a weekly range, but it is not picking up the correct week. Also my week range is Saturday through Friday.

My query:

SELECT...

Experiment with the simple query I posted. Replace the ? with appropriate column names.