Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query Help
Sorry for the vague subject line, but I dont know the terms to describe this problem. As I've begun trying to use this data for reporting, I've been running into a few 'issues' as the users did not go for a standardized format. Anyways, I am working on a report and having trouble getting...- JustABob
- Thread
- Replies: 8
- Forum: Microsoft SQL Server: Programming
-
Creating an ID or counter
Is there a way to create a unique ID to return in a rowset that is an integer? I know there is the newID() function, but it returns something much larger and is non-numeric. What I am basically looking to do is return: Select JobNumber, Name, StartDate, EndDate From Table The thing is, this...- JustABob
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
-
question about sums.
I am having some difficulties with this query and was wondering if anyone know what was wrong. The data I am working with can be setup 2 ways - Master job only - all data on one line, perfect! Sub Jobs and master job - Data can be in the MJ line and the SJ line. I need to roll up all data...- JustABob
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
