Viewing 15 posts - 1,126 through 1,140 (of 1,409 total)
It looks like a file on your local harddisk has become corrupt. Check the files in the following location:
%appdata%\Microsoft\Microsoft SQL Server\100\Tools\ShellIt might help if you copy the ..\90\Tools\Shell folder to...
June 4, 2013 at 5:06 am
Make sure you have "database mail" set up correctly. Most solutions rely on this feature.
In the scripts section of SQLServerCentral many solutions can be found. Just look around whats available.
You...
June 4, 2013 at 4:28 am
I can't reproduce your NULL value with the sample data you provided.
A NULL value in the EXCESSTIME column will be generated if one (or more) of the parts in, CAST(ABS(datediff(minute,...
June 4, 2013 at 2:44 am
I can't reproduce this error with your sample data. Please check all the data in your tables to see if there is a mismatch somewhere.
And like I said before: you...
June 4, 2013 at 2:34 am
Of course now you never forget to make (and check) back-ups from the system databases :w00t:
Without a backup you'll need to re-install SQL and manually adjust all changed settings to...
June 4, 2013 at 2:11 am
With all the data you have provided, it looks like the statement below will get your required results. But the JOIN in the below query on table [Shift_employee] is just...
June 4, 2013 at 2:00 am
I have created all the DDL and DML statement in the correct format and put the code at the end of this post, so other readers can use this.
For now...
June 4, 2013 at 1:14 am
looking at the errors I guess the parameters are passed as commands instead of parameters. Are you sure the "test.bat" accepts parameters?
I use below code a lot, so passing parameters...
June 3, 2013 at 7:15 am
immaduddinahmed (6/3/2013)
Sir You are right but in our factory we have 2500 employee.its very difficult to insert a eid in shift table.
please tell me the solution thank you
The basic question...
June 3, 2013 at 7:08 am
I think you'll have to add "eid" to the shifts table as well.
The [shifts]-table should have the same column (or columns) that make a row in the [attendance]-table distinctive. If...
June 3, 2013 at 6:55 am
I'm sorry, but it's getting very unclear at this moment. Please provide us with complete sample data of both tables instead of just a single row from one table. And...
June 3, 2013 at 6:36 am
GilaMonster (6/3/2013)
HanShi (6/3/2013)
Empty the second logfile with DBCC SHRINKFILE ('name' EMPTYFILE) and follow this statement with a delete file statement (alter database [...] remove file ...)
DBCC ShrinkFile with the emptyFile...
June 3, 2013 at 6:33 am
Your output indicates each row has a different value in the TotalTime column. How many rows are in the SHIFT table with ID related to emplyee 26446?
please give us the...
June 3, 2013 at 6:13 am
We'll need the OUTPUT of the select statement and not the statement itself. Execute the statement and post the excel-like output. It would even be even more helpfull if we...
June 3, 2013 at 6:01 am
Could you include the TotalTime column to your query and post the complete results of your SELECT statement?
June 3, 2013 at 5:55 am
Viewing 15 posts - 1,126 through 1,140 (of 1,409 total)