From a quick test I got similar results, but then using sys.objects I found the the objects in the second query were all views not tables as you were checking...

HowardW (6/25/2013)

---

Stefan Krzywicki (6/25/2013)

---

Strange as it may seem in this day and age of cheap HD space, there are still places that refuse to provide enough space for their data...

It would depend on the structure of your database.

I would like to hope that alongside your stored customer information you have the currency of the customer (and therefore a currency...

My favourite option would be bcp (http://msdn.microsoft.com/en-us/library/ms162802.aspx)

Nice back to basics question - thanks

London?

Yup - I'll be there

A bit of an update.

I have now found that the reason is one of the servers (where the dll works OK) is 32 bit, the other is 64.

I can only...

L' Eomot Inversé (6/14/2013)

---

This would have been a good question if the author had checked that it produced the expect result before he submitted it, and corrected it when he...

I wonder what version of SQL this was tested against - running it against my Test box (2008 R2) all goes well until INSERT INTO [dbo].[IndexTable]

VALUES(3, 'Value3')

Then I...

As Grass was told - we really need to see the sample data you are running this query against in order to make any meaningful suggestions.

Try this:-

Create table Table1(id int)

ALTER TABLE [dbo].[Table1] WITH NOCHECK ADD CONSTRAINT [CK_Table1_ID] CHECK (([ID]>=(0) AND [ID]<=(3)))

GO

ALTER TABLE [dbo].[Table1] CHECK CONSTRAINT [CK_Table1_ID]

Go

ALTER TABLE [dbo].[Table1] ADD CONSTRAINT [DF_Table1_Id] DEFAULT ((0)) FOR [ID]

Declare...

SQL may not Sean, but it is posted in Reporting Services, which does. However as you rightly say the order needs to be established for the rows returned so that...

Could you post DDL of the table (first link in my sig block shows you how), there might be something missing from your question which will help to get the...

Have you got any examples of the other commands that you are talking about?

There are many valid reasons why a stored procedure wouldn't conform to

Alter procedure Dummy as

Declare variables

Run...

You're dividing an integer by an integer, which will return an integer (no decimal places), then the conversion to decimal takes place. Try:-

select cast (3/2.0 as decimal (5,2)) as 'test'

and...