Viewing 15 posts - 1,951 through 1,965 (of 2,452 total)
never mind.....hope you pass your test! 😉
http://www.boards.ie/vbulletin/showthread.php?p=77157817
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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 ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 17, 2012 at 12:50 pm
you are very welcome...pleased to hear you have got this sorted.
thanks for the feedback.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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"
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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;}...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 17, 2012 at 3:03 am
Jeff Moden (2/16/2012)
bbsr (2/16/2012)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 16, 2012 at 2:05 pm
Ram...total sidebar
but I do think we ought to combine our avatars 😀
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 16, 2012 at 1:56 pm
Thanks for the revised script...
foscsamuels (2/16/2012)
SELECT 'srv-one'...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 16, 2012 at 11:52 am
Viewing 15 posts - 1,951 through 1,965 (of 2,452 total)