i am working on a web analysis project. i am having difficulty with counting hits and visits (a group of hits without a 30 minute break between hits). i decided to build a cursor in order to calculate visits. however, i have no experience with coding cursors and very little experience with both loops and t-sql.
in the cursor, it gets the data from a table that contains the IIS log (used logparser to transfer the logs to sql server)....
User Profile
Collapse
-
t-sql cursor with loop problem
-
this may work; it seems to work for everyone except for me
Dim oWord As Object
oWord = CreateObject("W ord.Application ")
oWord.Visible = True
oWord.Documents .Open("\filenam e.doc") -
-
formatting output of data
i'm working on a program where one of the functions is to build mailing labels from a list of prospects. i'm having trouble figuring out how to set this up.
i'm using vb.net and an access database. all of the info on the prospects is in one table, and i'll pick out the name and address and have them output into a dataset so that i can export it to excel. i need the output to look like this:
firstname1 lastname1
address1...
No activity results to display
Show More
Leave a comment: