Viewing 15 posts - 1,951 through 1,965 (of 2,452 total)
never mind.....hope you pass your test! 😉
February 19, 2012 at 5:41 am
alexei.sviridov (2/18/2012)
I have a test to complete by sunday afternoon........but the one I am given I am not sure if I am approaching it right...
I wonder if somebody could help...
February 19, 2012 at 5:33 am
something along these lines will get you started.
good luck with SQL 🙂
SELECT Employees.EmployeeName,
Projects.ProjectName
FROM ...
February 18, 2012 at 1:06 am
EdwinGene (2/17/2012)
You can ask me specific questions about the tables and indexes that relate to this problem, but I will not publish my table and index structures on this forum...
February 17, 2012 at 1:57 pm
go the link Lutz provided for DelimitedSplit8K
read the article....get the code...create the DelimitedSplit8K function
re run Lutz's code
...pls post back if still having problems
kind regards
February 17, 2012 at 12:50 pm
you are very welcome...pleased to hear you have got this sorted.
thanks for the feedback.
February 17, 2012 at 9:56 am
look up "GROUP BY"
this should help
EDIT:....just seen that this is Access
in query design use the "Totals" option...this will utilize "Group By"
February 17, 2012 at 8:57 am
you have posted in "working with Oracle" forum
are you looking for the schema of an Oracle db...to create in SQL
or vice versa?
February 17, 2012 at 7:53 am
HTML table format
DECLARE @tableHTML NVARCHAR(MAX) ;
SET @tableHTML =
N'<head>' +
N'<style type="text/css">h2, body {font-family: Arial, verdana;} table{font-size:11px; border-collapse:collapse;} td{background-color:#F1F1F1; border:1px solid black; padding:3px;}...
February 17, 2012 at 3:03 am
Jeff Moden (2/16/2012)
bbsr (2/16/2012)
February 16, 2012 at 2:05 pm
Ram...total sidebar
but I do think we ought to combine our avatars 😀
February 16, 2012 at 1:56 pm
Thanks for the revised script...
foscsamuels (2/16/2012)
SELECT 'srv-one'...
February 16, 2012 at 1:55 pm
in order to help us help you....this is the type of set up script that easy for anyone to cut and paste into SSMS and start working on.
if you can...
February 16, 2012 at 1:40 pm
take a look at "SQL Server Import and Export Wizard".....
its reasonably intuitive and you can save the results as a SSIS file for future mods and also schedule with SQL...
February 16, 2012 at 12:46 pm
foscsamuels (2/16/2012)
note - in the end i'll be running this in a MS Access database
before we go any further.....will this be an Access mdb/accdb....or is it an Access Front End...
February 16, 2012 at 11:52 am
Viewing 15 posts - 1,951 through 1,965 (of 2,452 total)