9 Topics

Member Avatar for
Member Avatar for haymen.roth.3

This query shows emplName,emplID, totalworking time, InTime, OutTime, DateVisited, Overtime for an employee based on his InTime and Outime, that's OK. Now i am trying to modify it to show only emplID, EmplName, Total Working hours(Per month), total overtime (per month). e.g. Empid EmplName TotalWorkingHours TotalOvertime Month 00001 John 77:00 …

Member Avatar for haymen.roth.3
0
168
Member Avatar for haymen.roth.3

Successfully calculated TotalTime a person has worked and overtime he has done if total working time is greater than 08:00 but if not greater than it puts duration of time person has not worked in Overtime column BUT NOW overtime column should display that time in proper negative format e.g. …

Member Avatar for haymen.roth.3
0
197
Member Avatar for mr0277

I am running a script on our production database reffering two tables : our table of users (3700 of them) and the table of quotes that they have made (280000 of them). Quote is the main object in our application, a very large object, for whom many data tables are …

Member Avatar for lee.m.timms
0
251
Member Avatar for bilnyg

Hello, I have a MSSQL database with a table called "people" and a table called "attendance". The people table contains the person's ID (primary key, identity increment), last name, first name, and active fields (I would only be interested in grabbing fields where active = Yes). The attendance table contains …

Member Avatar for cutepinkbunnies
0
224
Member Avatar for G_Waddell

Hi I have a real conumdrum here - I just can't expalin this behaviour!! A colleague has designed a view that contains the following : `CONVERT (nvarchar(4),YEAR(dbo.SYSFinancialYear.FinancialYearStartDate)) + N'/' + RIGHT ('00' + RTRIM(CONVERT (nvarchar(2), dbo.SYSAccountingPeriod.PeriodNumber)), 2) As YearPeriod` When you are in the design view, of the view and …

Member Avatar for G_Waddell
0
150
Member Avatar for bruceoz

Hi folks I need some help! I have two tables the first contains account information, and the second contains flags that records in the account table may have. These are joined by the account?id. One account record may have several flags from the flag table. ie the following select select …

Member Avatar for bruceoz
0
138
Member Avatar for miweiser

Can I get some assistance with the T SQL syntax required to use the contents of this combo box in a pass thru query in order to improve performance response time over the LAN [CODE] [Forms]![WELCOME]![FILTER_BUILDER].[Form]![Combo28] [/CODE] Apparently TSQL doesn't like the "!" from Access: [CODE] SELECT dbo_A_VIEW_LOWEST_LEVEL.contract, dbo_A_VIEW_LOWEST_LEVEL.[Profit Center …

Member Avatar for miweiser
0
193
Member Avatar for afrofish

Hi All, I am trying to convert the following access update query into TSQL without any luck: UPDATE tblCattle INNER JOIN tblFarmDetails ON tblCattle.strEartag = tblFarmDetails.EarTagNo SET curMartPrice = tblFarmDetails.MartPric WHERE (curMartPrice=0 Or curMartPrice Is Null); First I tried simply pasting in the query with no luck so below is …

Member Avatar for afrofish
0
259
Member Avatar for VIeditorlover

Hi, is there a way how to (in transact sql) catch output from stored procedure which returns set (2 and more) of tables and move through it ??? thanks!

0
98

The End.