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...

Yes jason, very silly of me.. there were no join in that query.. i just watched that group by and said that.. thanks for pointing it out though 🙂

OMG, so many replies whilst i was decorating my code.. lol...:-D

Great going at SSC...

Cheers..

Buddy, dint your subquery (which u used for the lookup alias) give the result u wanted?

Else, try this.

SELECT

T1.FIELD1 , COUNT(T2.FIELD2) COUNT_VAL

FROM

...