Viewing 15 posts - 61 through 75 (of 1,228 total)
I have a query that I would like to just group by the (LastInteractiveDate -...
February 2, 2017 at 2:12 pm
JALLY - Thursday, February 2, 2017 12:53 PMThanks everyone,I figured it out and used a while loop in a cursor.
Thanks
Jally, are you...
February 2, 2017 at 2:06 pm
I am trying to do a join that isn't bringing in the values as I'm...
February 2, 2017 at 11:13 am
urbanromio2 (11/28/2016)
Material a. ...
November 28, 2016 at 2:10 pm
Jeff Moden (11/28/2016)
urbanromio2 (11/26/2016)
Some one help me to convert the recursive method to iterative function.
To be honest, I just don't have the time to try to science out what...
November 28, 2016 at 11:15 am
Matt.Altman (11/17/2016)
Seems like this workedSELECT COALESCE (n.Application, k.Application) Application
FROM Table1 n
FULL OUTER JOIN Table2 k
ON n.Application = k.Application
GROUP BY COALESCE (n.Application, k.Application)
Looks good to me, Matt.
As a hardcore TSQL...
November 17, 2016 at 4:00 pm
Matt.Altman (11/17/2016)
November 17, 2016 at 2:24 pm
comic_rage (11/16/2016)
November 16, 2016 at 1:04 pm
DesNorton (11/16/2016)
deleted ... somehow my post was duplicated
Because it needed saying twice?
Assuming the gridview can handle this much data, it's got to get there down the wire then presumably...
November 16, 2016 at 12:15 pm
comic_rage (11/16/2016)
I am measuring the time on SSMS.
What will consume the result set?
November 16, 2016 at 11:25 am
comic_rage (11/16/2016)
I have the following query that is returning 1.6 M rows and about 300 columns. I can't change this factor. Here is the current
query
select Column1 ... Column290
from dob.table1
where...
November 16, 2016 at 11:08 am
Transnational replication has been postponed by Microsoft until 2027 and the widedescale introduction of quantum fibre, delayed by confusion regarding the identity of the next Dr Who. If however you...
October 27, 2016 at 1:55 pm
marc.corbeel (10/17/2016)
On the sample data their were no indexes indeed, but on the db I tested the solutions, there are indexes on the currency id and on the date...
That's very...
October 17, 2016 at 11:49 am
Alaster07 (10/14/2016)
October 14, 2016 at 1:50 pm
dianerstein 8713 (10/12/2016)
Is there a way to do the update I want to accomplish without dropping or disable the constraint? If so, how would you accomplish this goal?
Yes. Collect the...
October 12, 2016 at 2:30 pm
Viewing 15 posts - 61 through 75 (of 1,228 total)