Amit,

do you have control over the original stored procedure? I.e. can you rewrite it as a function (either scalar if it returns a single value or table returning function?)

Regards,

...

jaguarxj12l (2/27/2008)

---

I got it solved!

I had the original database scripted into a create script, had some Find and Replace actions executed, ran the script and got myself a new database....

If you...

And one more thing for the purists 🙂 Using SELECT to assign variables in not part of the SQL standard. For some it does matter 🙂 Though sometimes using SELECT...

Or, if you need the data from the second table as a list, you can do that too on SQL Server 2005 like:

CREATE TABLE A ( a INT, b INT...

Please only disable the nonclustered indexes. If you disable the clustered index, you will not be able to access the table.

Regards,

Andras

reg (2/26/2008)

---

I'm running Simple logging.

I have this Index too... and one more questions about that. Is this necessery when I have the clustered [ObjectID+PocketPCID] index? Will a search without the...

Because the column you are updating is part of the clustered index, the update will be a delete followed by an insert. If you are in full recovery mode, this...

Oops, I should learn to type faster 🙂

Anyway, setting it to Autmatic will ensure that it is started every time.

Regards,

Andras

Ian is right, the most frequent reason for the above error is that the SQL Browser Service is not running when you try to connect to a named instance with...

sp_executesql can be parameterized. This is an advantage when you are executing the same statement meny times but with different parameter values. In this case, the execution plan for the...

The new features are summarized on https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5470

There are many new features, so it depends on what you need. If you store large files in SQL Server, migrated from Oracle and...

And something for the future, if you will move to SS2008 🙂

I like using select statements when initializing a large number of freshly declared variables. This results in fewer lines...

terrence_daniels (2/22/2008)

---

My column names are as follows

Application Vendor, Application Name, Version, MS Vista Compatible, Confirmation, Contact, Region,

Business Area, Comments, Unique Identifier.

When I attempt to run the following...

T-SQL is a language which you can use...