Can you try by replacing SCOPE_IDENTITY() with @@IDENTITY?

SCOPE_IDENTITY() returns the current identity withing the current scope, while @@IDENTITY is not scope limited.

Regards,

IgorMi

You can find a lot of stuff in here http://www.microsoft.com/en-us/bi/default.aspx

Googling "white paper microsoft bi" will point you to lots of sites...

twin.devil (12/9/2013)

Igor just said there is a try-catch construct available in SQL Server. The OP did not say...

I think you should not worry even if your table...

In SSIS appropriate is DT_R8 for Float,Double.

In the destionation table you'd have Float as data type.

Take a look here http://technet.microsoft.com/en-us/library/ms141036.aspx

Regards,

IgorMi

Yes there is TRY .. CATCH in T-SQL - http://technet.microsoft.com/en-us/library/ms175976.aspx

Regards,

IgorMi

1) You can take a look at this link https://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

2) You can create it via SSIS package and execute the package from ssms.

You can see some results and experiment with queries given in this link http://technet.microsoft.com/en-us/library/bb522495(v=sql.105).aspx

GROUPING SETS is less frequently used, but sometimes it can be useful if you're aware...

Not something to worry about mcuh. Just put everything in the clustered key and all is well.

create table tbl_statistics

(p_key int identity(1,1),

client_id int not null,

client_datetime datetime not null,

constraint...

Check values for all the following

remote access

remote admin connections

remote login timeout (s)

remote proc trans

remote query timeout (s)

in sp_configure to ensure in case something is not set up well.

Is there a Login in the instance for the domain user you cannot log in with?

This code works

DECLARE @x XML

SELECT @x = '

<SystemProfile>

<CardTable>

<Reminder TimeOut="300" isActive="1" />

<Recycle RemovePeriodTime="60" />

<Message RemovePeriodTime="60" />

<Outbox>

<ConsiderNow authorizedCount="" />

<Considered authorizedCount="" />

<NotConsidered authorizedCount="" />

<Reject authorizedCount="" />

</Outbox>

</CardTable>

<Page>

<DocFlowHistoryView default="Graph" />

<SendService viewInOutbox="1" searchItem="role" searchOption="include" />

<Theme default="silver"...

You can use GROUP BY additionally with GROUPING SETS.

If you've been useing GROUP BY for a number of columns, now imagine those columns as sets, and everything is the same....

Try to avoid using hints, unless when you're very...