Davor Geci (12/17/2008)

---

I'm new in T-SQL,

can someone help me with big problem for me, but redicilus problem for a T-SQL programmer?

I have 3 tables:

Table1, Table2, Table3

Table1 is having 100 records...

Writing a query to concatenate all of the notes in one row is simple -...

"runs gud" is a relative term.

With a join between a local table and a linked server...

bnordberg (12/16/2008)

---

the location_id needs to maintain the previous value - not the min/max or a cartesian product. And I need each day for each person between their admit and discharge....

sunilibn (12/16/2008)

---

Folks,

As i don't want the users who loged in last 90 days. I want the uesr list who did not loged in in last 90 days.

Also the tbl_PBN_debugging...

A similar question is answered here.

SELECT RRSINV19.REFERENCE, RRSINV19.LOCATION, RRSINV19.RECNO, RRSINV20.PARTNUM,

RRSINV20.DESCRIPT, RRSPRB1.LRETAIL, RRSINV2.ITEMCOST, RRSINV2.LISTPRICE,

RRSINV1.INVCAT, RRSINV2.SHELFLOC, RRSINV1.BARCODE, RRSINV1.PRIMVENREF,

RRSINV1.CONFACT, RRSINV1.PACKQTY, RRSINV1.TAXABLE, RRSINV20.POSTED, RRSINV20.RETPERUNIT,

RRSINV20.UNETCOST

FROM RRSINV2

INNER JOIN RRSINV19 ON RRSINV19.LOCATION = RRSINV2.LOCATION

INNER JOIN RRSINV20 on RRSINV20.REFLINK = RRSINV19.RECNO...

You need to have a key value of @Dependencia which means 'All', then use this:

select d.Dependencia, count(*) as TitulosAdquisicion

from Dependencias D, EjemplaresSolicitados ES, Titulos T

where ES.IDTitulo = T.IDTitulo

and T.IDDependencia =...

The relationship between RRSINV20 and RRSINV19 is resolved in the WHERE clause, but you're referencing both in the FROM list in the joins to RRSPRB1, at which time this relationship...

Use collation casting in the SELECT list and the GROUP BY as follows:

drop table #german

create table #german

(

textdata nvarchar(100) collate Latin1_General_CI_AS

)

insert into #german values (N'daß')

insert into #german values (N'dass')

insert into...

Which server is running the statement?

Is one server linked to the...

nazaninahmady_sh (12/16/2008)

---

thanks

i think i have to use (CAST) for transfering because in Destination the data type of Body is nvarchar(max) and in the Source it is ntext ,

a...

Is it just me or are there a lot of TSQL 101 posts at the mo? Must be start-of-term.

I've heard a rumour that the next version of SQL Server will...

INSERT INTO [Server B].[Destination].dbo.[Table] ([ID], [Title], Body, Level1, Level2)

SELECT [ID], [Title], Body, Level1/1000, Level2/1000

FROM [Server A].[Sourse].dbo.[Table]

Which server is running the statement?

Is one server linked to the other?

Do you want...

ps (12/16/2008)

---

No, I'm not working on same system. It was a concern intended for...