Viewing 15 posts - 16 through 30 (of 620 total)
I'm not sure I see a question, and it seems like homework to me. You say you want 'continuous' id values, yet you also indicate users can delete records....
June 26, 2014 at 12:44 pm
Maybe this will be the time I win something useful...
With Reasons (Respondent, Reason) AS
(SELECT 'John', 'just because' UNION ALL
SELECT 'Joe', 'why not?' UNION ALL
SELECT 'Jane','need comode reading material'...
December 6, 2013 at 12:26 pm
Steve Jones - SSC Editor (9/5/2013)
Strings are a pain in T-SQL.
Steve, I must most humbly disagree. I find it is always fun to re-invent the wheel in just an...
September 6, 2013 at 2:24 pm
Here is another way. And I'll caveat this by saying that I am in no way implying it is any better or worse than what has already been provided...
August 16, 2013 at 1:56 pm
Sean Lange (5/17/2013)
When you don't do this stuff all the time it is the easy things like that which can drive you nuts. 😉
Indeed, I'm in my SQL Server just...
May 17, 2013 at 11:29 am
it.web (5/15/2013)
May 17, 2013 at 11:23 am
dwain.c (3/5/2013)
Jeff Moden doesn't call it that in his article, but here is where it is described: Group Islands of Contiguous Dates[/url]
Ah yes, I do remember reading that now. ...
March 5, 2013 at 6:13 pm
Well, Dwain, I was about to suggest the data should be stored with some sort of identifying element as to indicate whether or not the date indicates a leave or...
March 5, 2013 at 6:10 pm
Chuck112 (2/18/2013)
February 18, 2013 at 6:30 pm
Chuck112 (2/17/2013)
February 18, 2013 at 4:52 am
Chuck112 (2/17/2013)
2. Exported database with phpmyadmin
3. saved as a .sql file
4. class project to create a database in 2008 SQL Server "Planned...
February 17, 2013 at 6:37 pm
akberali67 (2/7/2013)
I have tried SAS, R, MATLAB over the past month but I couldnt work it out.
Akber, I don't mean to stick my nose in here, since it seems like...
February 8, 2013 at 12:50 pm
Greg Snidow
Mark, what is the purpose of the DENSE_RANK(), ROW_NUMBER(), and the CROSS APPLY? This is the fist time I've messed with XML, so it may be something simple.
Okay,...
January 22, 2013 at 9:04 am
Well, looks like Mark beat me to it. Anyhow, this is kind of (I think) the same thing.
DECLARE @xmlData XML
SET @xmlData = ('
<MatchKeys>
<fuzzyKeys>
<key...
January 22, 2013 at 9:01 am
sridhar_kola
if i need to know which invoice has an credit balance then is there any way in the CTE that we can mark it ?
Do you really have customers...
January 18, 2013 at 11:32 am
Viewing 15 posts - 16 through 30 (of 620 total)