Sounds like you are being blocked by another process.

Run your insert again

then

exec sp_whoo

You should see the Session you are being blocked by in the 'BlkBy' column.

Either kill it...

Use all dates in the format YYYYMMDD , note not YYYY-MM-DD

Two links for you

http://www.karaszi.com/SQLServer/info_datetime.asp

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/01/05/date-format-inconsistency-yyyy-mm-dd-or-yyyymmdd-when-2007-04-10-is-4th-october.aspx

You could try this...

http://www.mssqlserver.com/tsql/

Break it down to its component parts

ie

Start with

select convert(varchar(255), D_Date, 120)

then

Select convert(varchar(10), D_Date, 120)

then

Select left((convert(varchar(10), D_Date, 120)), 13)

Which is slightly bizzare , taking the left...

I think i see what you are now saying...

Select newSequentialId()

Errors, Correct ? This obviously fails as it has no idea which table you need the sequentialId for.

If you need...

Im a bit confused by exactly what you are trying to do.

Please post DDL and a reproduction script.

Sounds like you need dynamic SQL See this link or alternatively see this link [/url] for a "catch-all" query.

Any further questions , post back again

Hi ,

This should answer your question

http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

No a trigger will fire on data changes to that table inside the same transaction.

Maybe you can get the trigger to insert to a log table for a job to...

All the 'Inside SQL Server' books by Lubor Kollor , Steve Kass and Itzik Ben-Gan are very good.

http://www.amazon.co.uk/Inside-Microsoft-SQL-Server-2008/dp/0735626030/ref=sr_1_1?ie=UTF8&s=books&qid=1246868148&sr=8-1

This is what you need

declare @User varchar(30)

Select @User ='Domain\User'

Select Case When CharIndex('\',@User) >0 Then

Right(@User,DataLength(@User)-CharIndex('\',@User)) Else @User End

Although this a better solution IMO

declare @User varchar(30)

Select @User ='Domain\User'

Select substring(@User,CharIndex('\',@User)+1,999)

Select @User ='User'

Select...

Looking forward to when he moves on to "Chapter 2 - The Insert Statement " 🙂

Yes

by way of example

select case when 10>11 then 1 else case when 8>9 then 2 else -9 end end

Hi ,

start with this article http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/.

I would advise against using a scalar function and create a inline table function for perfomance reasons

If 2005 +

create table temp(id int,path varchar(1024))

go

insert into temp values(1,'C:\my\')

insert into temp values(2,'C:\my\')

insert into temp values(3,'C:\my\')

insert into temp values(4,'C:\my\')

insert into temp values(5,'C:\my\')

go

with cteRow(id,path,Rownum)

as

(

Select id,path,row_number() over(partition by path...