Hi r.medeiros,

Check the Dynamic Sql ..

Where the Syntax error its showing...

SET @sql = 'SELECT

...

Hi MW,

I am impressed on your answer.

But can you please tell me one more thing,

As per you "Andromeda\Brian_Hippo" is windows user, But if you navigate the Database...

heyy Doba_DBA,

I am bit late due to my current assignment.

today I saw your code and wondering how you executed this code.

I guess you may be post wrong code..

please check this...

I think Grant is Correct..

Only SQl Server 2008 Post should be placed here..

so we can able to analyzes more on Sql Server 2008..

before going to implements sql 2008 in our...

Hi,

I think both are same..no difference..i found...

SQL Server 2000

---------------------------

UPDATE statement conflicted with COLUMN REFERENCE constraint 'FK_COMPETENCYOFUSER'....

haroon waheed

------------------------------------------------------------------

It seems that your are calling the SP in a loop for mulitple inserts.

Calling SP again and again has its cost.

Try calling the insert SP once even for mutiple...

Kev, Its ok,

Can you check for this query in your server?

SELECT * FROM dbo.tblOfMine

SELECT 'x' FROM dbo.tblOfMine

Cheers!

Sandy.

Hi Sandy,

I did

SELECT getDate()

SELECT count(*) FROM dbo.tblOfMine

SELECT getDate()

SELECT getDate()

SELECT count('x') FROM dbo.tblOfMine

SELECT getDate()

And got the same time differences. Guess what I haven't factored in was that I ran the others...

Ok, Good Man..

Cheers!

Sandy.

Kev,

then what is the difference between these two?

SELECT count(*) FROM dbo.tblOfMine

SELECT count('x') FROM dbo.tblOfMine

Cheers!

Sandy.

Yes Lisa,

you can but you have to work a lot...

if you are ready then go ahead..other wise you can make a XPath Query to achieve this...

Cheers!

Sandy.

Ok, got it..

Cheers!

Sandy.

but hemu..

your error...show something different error..

how you got the solution..?

i guess your error was in the line..

======

Msg 203, Level 16, State 2, Procedure AssignVehicles, Line 25

The name 'CREATE TABLE bulkdata.[dbo].gpsdata29...

Are you the (our) Client....;) ?????

your heading make sence like this...(Kidding....:P:D)

he he he..lolz;):P:D

Cheers!

Sandy.

Hi All,

I got a quick solution for this.

Cheers!

Sandy.