Viewing 15 posts - 796 through 810 (of 1,195 total)
Nice and clear question - thanks Ron
-------------------------------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
March 20, 2013 at 2:18 am
If you only want the results for the user have you tried something along the lines of this:-
USE [master]
GO
/****** Object: StoredProcedure [dbo].[usp_who] Script Date: 03/14/2013 14:57:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER...
-------------------------------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
March 18, 2013 at 2:28 am
If you could supply table structure, the queries you have written so far along with sample data - see the first link in my signature for the best way to...
-------------------------------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
March 18, 2013 at 2:20 am
Bad post - sorry
-------------------------------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
March 15, 2013 at 4:44 am
Nice and easy question to end the week on - 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
March 15, 2013 at 1:53 am
OK - Don't have a column with it in on your report.
instead maybe have a textbox at the top with a value of
=first(fields!Supplier)
to remove the supplier from 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
March 14, 2013 at 7:50 am
(Potentially) daft question - have you run the same query in SSMS to see if you get the duplicates 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
March 14, 2013 at 5:05 am
One answer is
SELECT DISTINCT
id ,
mark
FROM
...
-------------------------------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
March 14, 2013 at 4:55 am
Thanks for that but the bit I'm looking for is :-
Enterprise Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
There is a version of SQL server (express) 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
March 14, 2013 at 4:15 am
Run
SELECT @@VERSION
That should give you a whole load of info about your server. Best bet to see all the information is to run it to text (ctrl + t)...
-------------------------------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
March 14, 2013 at 3:55 am
With most of the people here - just because you haven't seen it doesn't mean it can't / won't happen to you.
I wonder if they would take the same approach...
-------------------------------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
March 14, 2013 at 3:12 am
What version of SQL are you using? Developer, Enterprise, Express etc?
-------------------------------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
March 14, 2013 at 2:49 am
Hi - it might be worth checking what other software you have installed on your Dev server - is the hardware the same spec and so on. Otherwise you won't...
-------------------------------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
March 14, 2013 at 2:04 am
SQLRNNR (3/11/2013)
crookj (3/11/2013)
SQLRNNR (3/9/2013)
john.arnott (3/8/2013)
Revenant (3/8/2013)
SQLRNNR (3/8/2013)
opc.three (3/8/2013)
JAZZ Master (3/8/2013)
crookj (3/8/2013)
SQLRNNR (3/7/2013)
crookj (3/7/2013)
Daniel Bowlin (3/7/2013)
HelpSupport
Truss
Tether
Tie
Bolo
Whip
Rawhide
Eastwood
West Side
Story
TOY
(to) infinity
-------------------------------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
March 12, 2013 at 5:52 am
Nice and easy start to the day - 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
March 12, 2013 at 1:56 am
Viewing 15 posts - 796 through 810 (of 1,195 total)