Ok thanks

I'll try it out and let you know.

Thanks

Tim

sunder.bugatha (12/11/2014)

---

write t-sql code to check the number of active user connections and kill those exceeding a certain number. You can embed this code in a sql job and schedule...

MickyT, as i said, you are the man.

Thanks so much, you have saved my job.

I'm Greatfull, it works as expected. I'm studying the codes, the place i had small problem...

Hi MickyT,

Thanks for your help the other time.

I want to bring something to your notice, it has to do with the grouping of the advert breaks

I noticed that actually the...

Wow, MickyT, you are the man.

Thanks so much

it worked.

I'm very greatfull.

Thanks

Tim

You could also index the table, it makes running very fast. Use clustered index

Hi Erik, why do you say it's the coolest thing?

Sorry Lynn,

I meant to say that your corrections are noted, and i will make sure, i do it the right way next time.

Thanks

Tim

Hi Lynn,

Thanks for your reply, but i think Mark has solved the problem, just follow his post

Thanks

Tim

Ok Mark, Thanks, that works very fine.

Thanks, i'm very grateful

Tim

import first to access then now import to from access to sql server using your import/export wizard

Tim

Sorry Eugene, i mistook your name for SSCrazy. Lol

Thanks for the reply please check my new challenge above.

Thanks

Tim

Hi guys, please i need another help. Please how can i use this particular data:

Insert into TestTable(AdDate, AdTime, Fk_StationId)

Select 2013-04-01,07:52:00,A1

Union All Select 2013-04-01,07:52:43,A1

Union All Select 2013-04-01,08:05:06,A1

Union All Select 2013-04-01,08:20:45,A1

Union All...

Thanks SSCrazy

It Works

Thanks

Tim

Thanks Mark, you have solved my problem.

Thanks So much

Tim