Viewing 15 posts - 8,791 through 8,805 (of 13,882 total)
scottichrosaviakosmos (1/12/2015)
question is how to get the desired output.
What is the desired output?
January 13, 2015 at 12:12 am
DonlSimpson (1/9/2015)
It's interesting that neither of these:
substring('aeiouy', cast(rand() * 6 + 1 as int), 1)substring('aeiouy', cast(ceiling(rand() * 6) as int), 1)
exhibit the same problem.
There is no (implicit or explicit)...
January 9, 2015 at 9:11 am
SQLSACT (1/9/2015)
I came across the following T-SQL query in an article I was reading.
Can someone please explain what type of query this is?
Is this some type of correlated...
January 9, 2015 at 3:51 am
Thank you Jeff, that is an outstandingly good explanation.
Thanks also for the TOP (n) trick to force the generation of a query plan. I wish I'd known that before.
For fun,...
January 9, 2015 at 12:47 am
stucker (1/8/2015)
Well I'm such a newbie I thought SSCertifiable was your screen name. Sorry Phil LOL. And thanks again.
Haha, no problem :hehe:
January 8, 2015 at 12:19 pm
Change it back to
select COALESCE(SUM(WD.WRKD_MINUTES), 0)
and modify the final row:
) < 2400
select E.EMP_ID
,E.EMP_FULLNAME [EMPLOYEE NAME]
,(CONVERT(varchar, DATEADD(DD, - 6, GETDATE()), 101) + ' - ' + CONVERT(varchar, GETDATE(), 101)) as...
January 8, 2015 at 11:32 am
cbrammer1219 (1/8/2015)
I am trying to do thisI have researched many site stackoverflow, here, social.technet.microsoft.com
SELECT * FROM @tablename
Hopefully @Tablename cannot possibly be a table which contains 10 million rows each...
January 8, 2015 at 8:29 am
x 45204 (1/8/2015)
First time here, but have been enjoying the articles for some time now on this site.
But got a query question - I am trying to make a query...
January 8, 2015 at 7:42 am
Priya004 (1/8/2015)
I am new to SSIS..Plz explain.
Assuming you are not also new to Google, please try searching there and then come back here with any specific questions you may have....
January 8, 2015 at 6:20 am
Perhaps you can (incur yet another performance hit and) use LIKE?
January 8, 2015 at 5:55 am
Can you explain how one of the opening balance results is calculated please, from the sample data?
Eg, you have -449999.60 for (LDGR_ID1, 2014-10-01, 4).
January 8, 2015 at 5:47 am
Oliveoil (1/8/2015)
Just got a business-idea: The meta-cloud! :-)) A...
January 8, 2015 at 4:08 am
I think that this query is complex enough to warrant a request for sample DDL, data and desired results. I've reread it a couple of times and still don't fully...
January 8, 2015 at 1:13 am
Koen Verbeeck (1/7/2015)
Phil Parkin (1/7/2015)
mrtrich99 (3/27/2013)
Useful suggestion, but I do hope the OP solved his problem 2 years ago 😉
just like most people suggested, i now request for pipe delimiters,...
January 7, 2015 at 10:42 am
mrtrich99 (3/27/2013)
Useful suggestion, but I do hope the OP solved his problem 2 years ago 😉
just like most people suggested, i now request for pipe delimiters, but sometimes I do...
January 7, 2015 at 10:06 am
Viewing 15 posts - 8,791 through 8,805 (of 13,882 total)