Viewing 15 posts - 1,216 through 1,230 (of 5,504 total)
duplicate post. no replies please.
Original post: http://www.sqlservercentral.com/Forums/FindPost1145610.aspx
July 21, 2011 at 1:16 pm
The fact it only runs on Windows is one of the biggest concerns to get SQL Server into a production environment:
The production area usually is flooded with *IX OS together...
July 21, 2011 at 12:15 pm
Gianluca Sartori (7/19/2011)
There's someone you all know that deserves your vote here[/url].I'm sure you know who I'm talking about. 😉
Vote added.
Thank you Jeff for all the help you provided...
July 21, 2011 at 11:10 am
Craig Farrell (7/18/2011)
July 18, 2011 at 1:55 pm
a few issues:
a) what do you mean by "not display all the records on the first page, with page count = 10"? Are we talking about a Reporting Services issue...
July 18, 2011 at 1:53 pm
Any chance to post your solution? "Got it" could be explained a little more 😉
July 18, 2011 at 12:43 pm
Glad I could help 😀
And thank you for the feedback!
July 18, 2011 at 11:24 am
Untested...
SELECT [Cust]
,[Item]
FROM [OASISDEV].[dbo].[TT] TT1
WHERE NOT EXISTS (SELECT 1 FROM [OASISDEV].[dbo].[TT] TT2 WHERE
TT1.[Cust]=TT2.[Cust] AND TT2.[Item] = 15 )
GROUP BY [Cust]
ORDER BY [Cust]
July 18, 2011 at 3:47 am
Step 1: search this site for DelimitedSplit8K. You'll find a much better performing function...
Step 2: Use that function together with CROSS APPLY
Something like the following code snippet (untested):
SELECT Graduate.GID, Graduate.GName,...
July 18, 2011 at 2:57 am
It might be your grouping condition needs to be modified (just guessing, though):
SELECT DISTINCT (vulnID), COUNT(vulnid) AS COUNT, MONTH(scandate) FROM [external.vuln_instances]
GROUP BY vulnID, MONTH(scandate)
ORDER by VULNID
Other...
July 17, 2011 at 4:27 pm
Sounds like test or homework. (what other reason would exist that you cannot reformat the question?)
[Edit] hint: in order to find all orders from today you could use something like...
July 17, 2011 at 4:18 pm
duplicate post. noe replies please.
Original post: http://www.sqlservercentral.com/Forums/FindPost1143091.aspx
July 17, 2011 at 9:53 am
You could use
SELECT * FROM OPENROWSET(
BULK 'c:\SampleFolder\SampleData3.txt',
SINGLE_BLOB) AS x
July 17, 2011 at 7:13 am
What SQL Server version do you use?
It might be easier to do it using XQuery, assuming you use SQL 2005 and up:
SELECT
v.value('medFormID[1]','int') AS ID,
v.value('FormName[1]','varchar(50)') AS FormName
FROM @xml.nodes('document') T(c)
CROSS APPLY...
July 17, 2011 at 6:43 am
bsreddy00 (7/17/2011)
And what is your question / comment?
July 17, 2011 at 5:05 am
Viewing 15 posts - 1,216 through 1,230 (of 5,504 total)