If it's to hard...

Dim fso, f, f1, fc, s

Set fso = CreateObject("Scripting.FileSystemObject")

Set f = fso.GetFolder("C:\Work")

Set fc = f.Files

...

QQ-485619 (8/24/2010)

---

Hi,

I am looking for a vbscript to check if there is any file in a folder, C:\test

If there is a file there, then reture failure, and if there...

Do you want to learn SQL or just looking for a quick answer?

If the first, you can have a look two methods:

1. Do insert and then delete in two separate...

thisisdeepthy (8/24/2010)

---

I have little to no SQL experience so bear with me on this.

I have a table say table1 with columns Title,surname,forename,address1,telephone,mobile,country and so on say 40 columns populated...

Could you please specify what is required output of your loop?

And why your input table contains full duplicates?

If you want it to be faster (less scans and less reads) do:

select ac

, SUM(CASE WHEN my_order = 1 THEN bal ELSE...

Use Microsoft Time and you will get 2 sec or whatever you like without much of hassle 😀

SQL_DBA_3 (8/18/2010)

---

Thanks ..

I was looking for an reason why its behaving differently...Is there data mismatch which is foricng it for NOCHECK and then enabling the CHECK....

I wanted the foreign key...

Hornestly, there is no much to advise here...

You believe functionality is the same on both the servers while FK are scripting differently in terms of CHECK vs...

Here it is, to help you:

-- you will need table with two extra columns for DateFrom and CodeFrom

-- "select into" is quite fast even for large tables

select *, CAST(null as...

Use "quirky update"!

Also, you may speed up my query by adding indices on Date and Code columns...

Please test if performance is acceptable in you case:

;with termrec

as

(

select t1.UserId, t1.Date, t1.Code

from #temp t1

left join #temp t2

on t2.UserId = t1.UserId

and t2.Code = t1.Code + 1

where...

You may want to read through these couple of blogs:

http://blogs.msdn.com/b/spike/archive/2008/07/23/ole-db-provider-microsoft-jet-oledb-4-0-for-linked-server-null-returned-message-unspecified-error.aspx

and

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/d92a73c0-9c87-4adf-a6a3-061a48b8dac5

Where do you think this statement is executed? Connecting to SQLServer from Client PC and then executing the SQL statement - does not mean...

Ok.

Then I would advise to use SMO:

http://msdn.microsoft.com/en-us/library/ms162169.aspx