What about:

SELECT 'a'

UNION

SELECT 'b'

UNION

SELECT 'c'

Regards,

Iulian

Thanks a lot.

About:

that is nice, I have not thought about it. Unfortunately...

Nice one, thanks.

Iulian

Hi, sp_makewebtask is nice but is a a deprecated feature.

The recommendation is to use SSRS. See:

http://msdn.microsoft.com/en-us/library/ms175576%28v=SQL.90%29.aspx

Regards,

Iulian

There are some possible solutions here: http://www.sqlservercentral.com/Forums/Topic128881-24-1.aspx

MS explains the error here: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q288577

Regards,

Iulian

You can get a new unique identity with NEWID() function.

Regards,

Iulian

With linked server you can build distributed queries.

In case you need to connect to both SQL and Oracle servers and query them from SSMS on a regular basis...

Nice one, thanks.

Iulian

after you transferred the data once then you can save the package and schedule it every hour, as you like.

Iulian

Hi,

You can try looking after "SQL Server 2005 Import / Export Wizard" in msdn or google.

Here is an article about it: http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm

Regards,

Iulian

Nice one, thanks.

Iulian

You can try this:

SELECT

EmployeeID,

Department,

Branch,

MIN(StartDate) AS StartDate,

MAX(EndDate) AS EndDate

FROM TABLE_NAME

GROUP BY EmployeeID, Department, Branch

Regards,

Iulian

I missed this one but nice question thanks.

I was thinking that the row can be updated since on insert operation with trigger on it:

first inserts the row into the table,...

Hi,

You can try this query:

SELECT * FROM

openrowset(

'Microsoft.Jet.OLEDB.4.0'

, 'Excel 8.0;database=PATH\FILE_NAME'

, [SheetName$]

);

there...

Nice one thanks.

Here is an article on this regard with more details:

Managing the Number of VLFs in your Transaction Log[/url]

Regards,

Iulian