Make sure you refresh all dependent views (see sp_refreshview) if they were using select * (bad practice). Also, if you are not using select $ in these...

Assuming a lot (like that you are trying to add up the order amounts in your Pizzas ordered table and put the value to the Orders table's total_order_price), you could...

Just replace the @a with a regexp...

You can use a user defined function that fixes such newline issues. The function could use Patindex and Stuff. A solution:

CREATE FUNCTION dbo.DoubleNewLine ( @text VARCHAR(50) )

RETURNS VARCHAR(50)

AS BEGIN

...

Hmmm, SQL Server 7 🙁

You could still break up the table into several tables, and then...

You could partition the table.

How frequently do you need to truncate?

You could create a few tables, and create a view over them. Then just rotate the tables underneath.

SQL Server...

Or another solution is to use:

'P' + RIGHT(REPLICATE('0', 10) + RTRIM(MAX(t.a) + 1), 9)

This finds that highest id in the table, adds one to it, adds 0s, and prefixes it...

Hi Manutosh,

this time the XML made it :). I'm wondering if you have an example of the "other format" as well. IF ti is only the nestedness of employees, you...

Looks like your xml did not make it. Please replace all < with &lt;. In Management Studio or Visual Studio: Ctr-H, ...

You can check if the XML displays properly in...

There are places where table variables are a very bad idea, and the other way around. For example, storing much data in table variables on 2005 is usually a bad...

manutosh pandey (12/4/2007)

---

Hi All,

I am using the openxml function sql server 2000.but in this I am giving the hard coded stuff as...

Prakash (12/3/2007)

---

Dear All

I want the output in this way

Days No of.Requests

Mon 5

Tue 6

Wed 7

Thu 3

Fri 2

Sat 1

I will pass only the date to the query

Pls help me to solve this...

Not sure about the internal representation you mean, but basically yes, you need to load the whole document to process it. In order to get a single value you are...

SELECT TOP (1) RememberValue

FROM dbo.Remember

WHERE DBName = @DBName

AND SProcSource = @SProcSource

AND SProcVersion = @SProcVersion

AND RememberKey=@RememberKey

ORDER BY CreatedDate DESC

Regards,

Andras

Ramesh (12/3/2007)

---

I still couldn't understand what you're trying to point...:unsure:

Multiplying the value gives me 3032, whereas I get 12 when divided...

I am curious to know, how the said value can...