yisaaacs (1/19/2009)

---

Hi, im trying to send query results as HTML mail. i will setup up a job to run this daily.

its nothing complicated, but im having trouble formatting the resultset...

jack isn't is good to use WHERE EXISTS...

Why don't you go for SSIS?

the same way sp_helptext 'fnc'

C.K.Shaiju (1/19/2009)

---

I have denied VIEW DEFINITION permission of all the objects of a database for a particular user. But he is getting an error like "Object does not exist or...

surya.narayana (1/15/2009)

---

Hi,

I have SSIS package which has 5 dataflows and each dataflow copies around 10 million records. When i execute this package from Business Intelligence studio, It was completing in...

you cannot change it to sys, Sys schema is...

it's not the problem of open transactions, the user does not have permission to view the table(GRANT)

AS said this can be done by usning FOR XML path also....

SELECTSTUFF((

SELECTDISTINCT ', ' + cast(object_id as varchar(10))

FROMsys.objects

FOR XML PATH('')), 1, 1, '') AS 'Ids'

Its not possible to deploy the stored proc w/o script. You have to run the script on client machine.

In simple words...

Inner Join returns matching records from two or more tables.

Cross Join --Returns carteian result. E.g tableA contains 2 record, tableB contains 10 records. using cross join the result...

its wrking used the same query olny retrived distinct records from tmpPoj..:)

SELECT tmp.PojID, tmp.Cat,

SUM(Case...

here's your answer...

DROP TABLE tmpPoj

DROP TABLE tmpCat

CREATE TABLE tmpPoj

( PojID INT, Cat VARCHAR(10), Total INT )

CREATE TABLE tmpCat

( CatIDINT, Cat VARCHAR(10) )

INSERTtmpPoj

SELECT1, 'A', 1 UNION

SELECT1, 'B', 2 UNION

SELECT2, 'C', 10...

As you mention,

For a valid insert the tracks table may contain a record with the same grProductID or the same grRecordingID (as in the source tables), but NOT the same...

can you elaborate it more what operation you want to perform primary key on schema / data?