Thanks Gianluca.. what if i dont have a order by clause? still the top operator is processed only after getting the result set?

Do u think SET ROWCOUNT will be...

Try this then buddy...

DECLARE @sql VARCHAR(4000)

SET @sql = ''

SELECT @sql = @sql + 'EXEC MASTER.SYS.XP_CREATE_SUBDIR N'''+ COLUMN_NAME +''''+ CHAR(10) FROM...

Hey Delinda..

Here is the code for you.. this will update if an match is found and will insert if no match is found between the tables..

Tell us if this worked...

LOL 😀

Anyways, thanks and welcome mate 🙂

Oh yeah Paul, apologies..i did not look deeply into the variables assigning part.. u need not do that.. sorry mate 🙂

Please toss over all of the "thanks" to our comrade Paul White from NZ :cool:.....

Again, this is from Paul White's post..the NUmbers function which creates numbers from 1 to N fast, i mean, very fast!! 🙂

CREATE FUNCTION dbo.Numbers

...

hi buddy... i have created one code for you, test this if it works...

IMPORTANT:

I HAVE USED PAUL WHITE NZ'S N-WAY HANDSHAKING COMBINATIONS TO SCRIPT THIS. SO ALL CREDIT TO HIM...

Mate, provide us the create table script and sample rows to insert and check your code... and also i noticed that u are update a table using the count of...

Hello sachin.. here is a sample code that i use for nested cursors...hope this helps u as well, like Dave's 🙂

Try it out and let us know 🙂

IF OBJECT_ID('TEMPDB..#T1') IS...

Do you want to convert a bigint column to datetime (completedtime is in bigint and u want to convert it to datetime and then compare it to getdate() ?? )...

Unfortunately you have not , mate 🙁

Some Create table statements, some sample data, which column of yours...

Be sure taht the account who is going to execute that query had necessary and adequate permissions to create a new folder on the OS..

Please let us know if that...

Hi buddy,

as i dont have any DDLs i can directly use to attend to your request, i am giving u a vague and rogue code 😀

Please test it before...

Exactly... even i was...