Viewing 15 posts - 16 through 30 (of 52 total)
A good, free T-SQL tutorial is here:
http://www.w3schools.com/SQl/default.asp
Itzik Ben-Gan's Book: Microsoft SQL Server 2008 T-SQL Fundamentals is a great book even if you have some experience.
November 24, 2009 at 10:36 am
Nabha (11/24/2009)
Select * from (SELECT *,
Row_Number() OVER(PARTITION BY CustomerNumber ORDER BY
CustomerNUmber) as row_no
FRom CustomerContactsXref) t
Where row_no > 1
Hi Nabha, I was curious about any differences in perfomance...
November 24, 2009 at 10:00 am
Probably the simplest way to do this.
SELECT mt.CustomerNumber
FROM MyTable AS mt
GROUP BY mt.CustomerNumber
HAVING COUNT(mt.CustomerNumber) > 1
Hope This Helps!
November 24, 2009 at 9:08 am
I got the article. Thanks very much. Very helpful.
November 23, 2009 at 1:56 pm
Try this.
Alter Proc sp_Test (@a varchar(10), @b-2 varchar(10), @C varchar(10) = NULL)
as
Select a, b, c
From TestTable
Where a=@a
and b=@b
and (c=@C OR @C IS NULL)
Hope This...
November 20, 2009 at 2:33 pm
Sending Strong And Healthful Thoughts And Prayers Your Way Josef. You're An Exceptional DBA and I'm Sure An Exceptional Husband, Father, And Friend As Well. Best Wishes To You And...
November 18, 2009 at 10:25 am
In your report parameter properties, if you have chosen "specify values" and supplied Available Values then it should work. Otherwise the parameter will require a dataset (query). Either you must...
October 28, 2009 at 11:56 am
It would help to know what version of SSRS. It may have something to do with your parameter's Default Value settings or Available Values settings.
October 28, 2009 at 11:44 am
I would read up on interacting with the data cache and the procedure cache.
September 23, 2009 at 11:05 am
SUM(coalesce(Case_Count,0)) ...should return 0 when Case_Count IS NULL. I would try it on a narrow result set without the other aggregate and without the other attributes.
September 23, 2009 at 10:56 am
Inasmuch as they both generate GUIDs, they are the same. The question was somewhat ambiguous
September 22, 2009 at 1:59 pm
B-I-N-G-O......I found the original source of where I first saw this term: "COMMA JOINS". So... OK, maybe it's not as clever as I had remembered, but it is very descriptive.
Posted...
September 22, 2009 at 10:41 am
Was it 'ANSI SQL-89 syntax' you were thinking of?
Nope. :crazy: It's a slang term (very descriptive, I think). When I do find it, it'll be a great question...
September 22, 2009 at 10:25 am
Is that what you are after?
No. Thanks. There is a Where clause. The syntax is not the question. I can fix the join. A while back I saw...
September 22, 2009 at 9:44 am
There is a Where clause. It is indeed an "old-style" join. What I'm looking for is the term used to describe the old-style join. I've seen it used here and...
September 22, 2009 at 9:01 am
Viewing 15 posts - 16 through 30 (of 52 total)