riajain9 (7/20/2010)

---

Hello Mike/Bt...

I cannot use this update as my data is very large more than 100000 and is always increasing...

I there any way to add it in the query as...

Why don't you want to use a stored procedure?

The frequency function in Excel looks to have the first interval be based on what is less than your first data value. In the case of your example, your...

Yes indeed...

Maybe I'm missing something, but isn't your function returning XML? So wouldn't it be:

CREATE function fn_getXML(@url nvarchar(max))

returns XML AS

EXTERNAL NAME [XMLPuller].[XMLPuller.XmlFunctions].[getXML]

GO

(*edit: nevermind ... I looked at...

The Dixie Flatline (7/19/2010)

---

Without data to test, this is a shot in the dark, but....

SELECT COUNT(DISTINCT docid) -- docid is primary key of Table A

FROM [Table A] a

JOIN...

Nevyn (7/19/2010)

---

Just a heads up on this one to watch out for SQL injection vulnerabilities here. Just parsing a querystring in a stored procedure and using it to dynamically...

A lot of times this sort of thing is better done on the interface side.

However, if you need to do this via T-SQL, I would suggest you read this article[/url]...

There are times I will use the GUI in a development environment but then use a tool to generate the T-SQL to make 100% sure I know exactly what the...

There was a very big thread about splitting strings last year on this site.

I'll let you read through that because it covers a lot. Generally, however, the best performance...

You should be using stored procedures anyway. Simply update the new column to GETDATE each time you do an insert/update.

Your way will work, but it is not the most efficient (as you guessed.) I use to use subqueries in WHERE clauses just like you have done, but I've...

If you want something more advanced you need to build the mechanism yourself. Generally you don't want to log everything, just specific data changes, so it's fairly easy to...

It's hard to be sure of the difference without actually seeing T-SQL used to create the tables. If you used the GUI designer there shouldn't be an difference (that...

See the link in my signature for information about how to post a question in such a way that people can and will help you.