Viewing 15 posts - 751 through 765 (of 1,195 total)
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
June 27, 2013 at 7:59 am
HowardW (6/25/2013)
Stefan Krzywicki (6/25/2013)
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
June 27, 2013 at 7:42 am
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
June 27, 2013 at 3:09 am
My favourite option would be bcp (http://msdn.microsoft.com/en-us/library/ms162802.aspx)
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
June 26, 2013 at 2:12 am
Nice back to basics question - thanks
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
June 26, 2013 at 2:09 am
Steve Jones - SSC Editor (6/17/2013)
This week is the first SQL in the City of 2013. Anyone coming?
London?
Yup - I'll be there
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
June 18, 2013 at 1:14 pm
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
June 18, 2013 at 7:01 am
L' Eomot Inversé (6/14/2013)
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
June 14, 2013 at 11:13 am
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
June 14, 2013 at 1:27 am
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.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
June 12, 2013 at 4:37 am
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
June 11, 2013 at 4:16 am
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
June 11, 2013 at 3:59 am
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
June 10, 2013 at 3:01 am
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
May 20, 2013 at 2:33 am
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
May 10, 2013 at 1:34 am
Viewing 15 posts - 751 through 765 (of 1,195 total)