DBA (3/23/2009)

---

thanks for your input guys, so if i do it with batches, let 's say 10000 at a time, would it also help to create a temp table and...

J-F gave you a complete working sample. To include the day after the "end" date just add "+ 1".

-- Copied from J-F

SELECT 1

FROM @tbl_holidays hol

...

Hi

2.

You should consider how of the developers really need a dbo account on your production system. I'm also a developer and have a dbo account on our production system but...

Hi Betim

No, I would say to really learn SQL Server you should use another book. BOL are a great reference or to study new features. But basically to learn SQL...

To Gail, Perry (and some other people)

Thanks for your corrections in this thread and others. I'm not from England/America and sometimes I'm tryin' to read faster than my English allows......

!!!!

Sorry, I read over this...! Thanks Gail!!!

naimish:

Could you please explain!

Hi

Here an example which shows how to reset the IDENTITY column.

USE tempdb

IF (OBJECT_ID('test') IS NOT NULL)

DROP TABLE test

GO

CREATE TABLE test (id INT IDENTITY, txt VARCHAR(100))

GO

INSERT INTO test

...

Hi

The SQL query is not the problem. You have to determine if any data have been returned and if the data are not DBNull.

...

Hi Perry

Thanks...

So it seems that you have installed no SQL Server.

You wrote you are running Windows XP. You can only install the SQL Server Developer or Express Edition on a client...

Hi

This should work:

DECLARE @output TABLE (id INT IDENTITY, command NVARCHAR(256))

INSERT INTO @output

EXECUTE master.sys.xp_cmdshell 'bcp YourCriteria'

SELECT *

FROM @output

WHERE id = (SELECT...

Hi

First:

Go to "Start" -> "Programs" -> "SQL Server 2005" -> "Configuration Tools" -> "SQL Server Configuration Manager". Select node "SQL Server Services". In detail view you see the installed components...

Hi

As Gail already replied, sometimes it's faster to press CTRL+F5 than let us be the parser... 😉

For your problem try this:

WITH t2 (column1, column2) AS

(

SELECT t1.column1, SUM(t2.column2)

...

Hi

I did not yet connect to an Oracle via linked server. Because you did not explain special problems, try this (copied from BOL):

EXEC sp_addlinkedserver

@server = 'LONDON Mktg',

...

sol (3/21/2009)

---

While i ask you guys, i also find out one system stored which have the same result as John said, but with a little harder to get full result...