Search results

For the majority of businesses out there not doing major e-commerce and pretty much sticking to in-house needs, I believe SQL Server is a great product. The support for it is tremendous as the user base is huge. The book I mentioned above is great even for beginners. SQL Server comes with the...

Structure is integral. Not having tables indexed correctly, having queries performing cartesian joins, nested aggregate queries ... all of this will affect the performance of your queries. I would also ask about the throughput with your webhost. You could have everything optimized but only...

Well, you need to requery your recordset to get the update from the server. OpenADORS.Open "SELECT * FROM dbo.MyTable WHERE Field2 = 'John Doe'" , objConn, adOpenDynamic, adLockOptimistic OpenADORS.AddNew OpenADORS!Field2 = "John Doe" OpenADORS.Update OpenADORS.ReQuery

Well, I don't see why not, if you create a shortcut to the macro out in a location that the server can get to and this location also needs to have the proper rights as the account that SQL Agent is running under. This may be your issue right there. Under what account is SQL Agent running...

Well, something is always going to happen. Did you refresh the job listings? Your job should have had it's icon change to a red circle with an X in it. Right mouse click on it to view the job history and put a check in the Show Step Details box. This should tell you what is wrong. Also...

For SQL, Inside SQL Server is a good book. Very straightforward with their explanations. As far a tutorials, no. When I started this whole DB thing, I just jumped in by creating a DB that tracked all of my contacts. Personal ... professional ... whatever. Created queries, forms ...

That is funny.

Well ... first off, I have to ask why you are using variables and temp tables for such a simple process ... select Students, Sum(Scores) Total, from members where Students = 'Amy' group by Students Anyhow, you can't use global temp tables in data transformations, which, if you think about it...

Not sure ... This works fine for me, does it for you? declare @ForYear Int select @ForYear = '06' select Convert(DateTime, '01-Oct-' + Convert(VarChar, @ForYear)) What is your call to this proc?

Single # temp tables are dropped with the connection, double # (Global Temp Tables) are seen by all connections and stay alive until they are dropped. Both reside in the tempdb database. if exists(select * from tempdb.dbo.sysobjects where Name Like '##tbl%') drop table ##tbl

That is why I am looking for some personal experience.

Hello all, My Father has always wanted to take his boys (2) fishing up in Ontario, but we have never gotten around to it. This spring, we are determined to make it happen and I am starting my research as to the best lake/resort to go to. Not looking for a fly-in as my Father is now 80 years...

Funny, I just had to do this yesterday. ... & Replace(Me!Person_Responsible, "'", "''") & ... You have to replace the single quote with two single quotes.

Ah string manipulation. One of my favs. But, as you can see from my example, do you realy want. The last line or the last sentence. Some people define this as the same, so I will include both here. I have a table named Tbl_Mem with a memo field named MemField. Some have hard breaks, others...

When you say recognize, do you mean that you are clicking on the dropdown and it isn't there, or you have typed in the name of the server and it says it doesn't exist? You may/will have to type it in the first time ...

Original ASP, eh? :eek: I didn't know there were still any of you out there. :D Come on over ... the water is nice.

In that case, use a data adaptor to fill in the tables and then you can reference each table in any order and go back and forth and up and down and ... with your recordsets.

You can have the SP output several recordsets and then cycle to the next recordset your DataReader in ASP. Here, let me do a quick Google search; http://www.velocityreviews.com/forums/t72012-multiple-recordset-from-a-stored-procedure.html

The language (TSQL) isn't the problem, creating the algorithm is our challenge. I will give you the framework and you can fill in a couple of the areas I noted to create a function: DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @StartTime FLOAT DECLARE @EndTime FLOAT DECLARE...

How do you know if something should be Fax, Phone or Mail? Take a look at the SWITCH function.