Viewing 15 posts - 361 through 375 (of 3,666 total)
Luis Cazares (8/28/2015)
CREATE TABLE #SampleData( num varchar(100));
INSERT INTO #SampleData VALUES
('1000:001'),
('1001:001'),
('1002:001'),
('999:001'),
('998:001'),
('99:001'),
('1:001'),
('2:001'),
('3:001');
--This won't work correctly
SELECT * FROM #SampleData ORDER...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 28, 2015 at 10:46 am
chindilog (8/28/2015)
from woitem
join wo
ON wo.id = woitem.woid
Join moitem
on moitem.id = woitem.moitemid
Join mo
ON mo.id = moitem.moid
LEFT JOIN SYSUSER ON mo.userid = sysuser.id
group by sysuser.username, num
order...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 28, 2015 at 10:21 am
I would use a conditional split and check that the id (as a string) is 10 characters long and has its first 2 characters being numeric, the third character being...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 28, 2015 at 9:50 am
serviceaellis (8/26/2015)
J Livingston SQL (8/26/2015)
TSQL
FROM attribute.PersonMembership LEFT OUTER JOIN USFSA.dbo.SOP10100 AS...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 26, 2015 at 9:29 am
serviceaellis (8/25/2015)
Alvin Ramard (8/25/2015)
Looks like you're using pm as an alias twice; on the 2nd line of Split2 and at the end of Split3.
Does that matter?
Strange thing is nothing has...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 26, 2015 at 6:09 am
Looks like you're using pm as an alias twice; on the 2nd line of Split2 and at the end of Split3.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2015 at 3:13 pm
I remember that Excel is hard to deal with when you have a query that cannot be expressed visually.
I have had to create macros before, that would read the...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2015 at 1:32 pm
TomThomson (8/25/2015)
SQLRNNR (8/18/2015)
call.copse (8/18/2015)
I am probably unusual in that I don't really like FacebookNope - sounds perfectly reasonable to me.
Perfectly reasonable would be an understatement for me. ...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2015 at 12:55 pm
You're talking about redoing an OLTP database using Type 2 SCD?
Type 2 SCD is something that is normally used in Reporting database/Data Warehouse. I've never heard of it in...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2015 at 12:53 pm
J Livingston SQL (8/25/2015)
This code will be used in Excel. Using the External source link.
maybe best if you explain how you are expecting Excel and SQL to interact first....then we...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2015 at 12:32 pm
serviceaellis (8/25/2015)
Alvin Ramard (8/25/2015)
How is the user going...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2015 at 12:00 pm
Create 2 variables for the start and end dates of your range and use those instead of the hard coded dates you used.
How is the user going to interact with...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2015 at 11:47 am
Ed Wagner (8/25/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2015 at 11:36 am
SQLRNNR (8/25/2015)
Sean Lange (8/25/2015)
Alvin Ramard (8/25/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2015 at 10:26 am
blake.hartman (8/25/2015)
Is there an easier way...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2015 at 10:25 am
Viewing 15 posts - 361 through 375 (of 3,666 total)