You can do something like this....

SELECTID, MAX( [1] ) AS [1],......., MAX( [31] ) AS [31]

FROM(

SELECTID, shift_id, DAY( [DATE] ) AS [Day]

FROMdbo.Employee

WHERE[DATE] BETWEEN '01-Apr-2007' AND '30-Apr-2007'

) S

PIVOT

(

MAX( shift_id)

FOR [Day] IN(...

You can't insert rows into table variables in an INSERT..EXEC statement.

Create a temporary table to hold the data instead of table variable.

Using xp_cmdshell to issue SQLCMD, BCP or OSQL is the right way to go but I guess you wouldn't get the required privileges to do that.

Other alternatives could be....

1. OPENROWSET...

If the SQL Server user is logged in using Windows Authentication, the user can read only the files accessible to the user account, independent of the security profile of the...

I'm not sure whether Oracle supports explicit value insertion into a timestamp column, but SQL Server doesn't allow this.

Try inserting a record into the Oracle table with explicit timestamp value.

Though, such constructions are not supported in SQL 7, 2000, but here is what you can do in 2005

SELECTROW_NUMBER()

OVER

( ORDER BY

( CASE WHEN @sort = 'relevance' THEN hits...

Good caught, jeff:D

UPDATE postaladdress SET streetaddresstxt = SUBSTRING( streetaddresstxt, 1, CHARINDEX( '\', streetaddresstxt ) )

FROM postaladdress

WHERECHARINDEX( '\', streetaddresstxt ) > 0

[/code]

Use PIVOT with either dynamic values or fixed values....

Haven't you looked at partitioning data in tables and indexes?

Look for EXCEPT or CHECKSUM in BOL...

Hey Jeff,

Do you mean Books Online 2008?

Its there in Chapter 1 > Page 6

For those who didn't get their hands on the book...

Brief Description of Logical Query Processing Phases

1. FROM: A Cartesian product (cross join)...

GilaMonster (12/4/2007)

---

Ramesh (12/4/2007)

---

Amazingly, SQL Query Processor performs a Cartesian product (a cross join, or an unrestricted join) between the first two tables that appear in the FROM clause, and as...

No, you can't...but you can SQL Query analyzer only to view the objects and data from tables or views.