Viewing 15 posts - 121 through 135 (of 210 total)
FreeHansje (10/11/2011)
I know about the DateDiff and DateAdd functions, but how do I add the sysjobhistory..run_duration to a date?
check out this post:
October 11, 2011 at 8:57 am
chauchs (10/11/2011)
I would do something like this
select t1.f1, t2.f1
from table1 t1
join table1 t2
on t2.f5 = t1.f5
and t2.f3 = t1.f3
join table1 t3
on t3.f5 = t1.f5
...
October 11, 2011 at 5:32 am
raphael.kong (10/10/2011)
What I dont understand is why when I write the sql insert from the sql management studio, the trigger runs properly, with every data as...
October 10, 2011 at 10:05 am
raphael.kong (10/10/2011)
I'm new to this forum ;I'm new to SQL Server 2005 programming to. I guess I could find some help about my issue.
Here my environnment :
I have a...
October 10, 2011 at 9:32 am
In my experience with VMware and sql server, the problem is usually in shared disk. So your virtual hard drives are probably not dedicated physical hard drives. You...
October 10, 2011 at 5:56 am
venoym (10/7/2011)
Try the function by Jeff Moden that uses a Tally Table, much cleaner and faster.
That article just talks about tally. This one has a function that...
October 7, 2011 at 11:31 am
mdvlinquest (10/7/2011)
I have a database backup file (.bak) taken from SQL Server 2005 Express which was running on a 32-bit Windows XP. Now I have 64-bit windows 7 installed on...
October 7, 2011 at 11:04 am
GJ-238291 (10/7/2011)
I'm searching for a simple solution (no store-proc) for such a simple (or so I think) problem.
I have some field named GL_GETLOST which contains this kind of strings...
October 7, 2011 at 10:33 am
jondy87 (10/6/2011)
All i can do is run the SP and store the result...
October 6, 2011 at 12:53 pm
jondy87 (10/6/2011)
I have a stored procedure that returns two result sets which needs to be
inserted to two physical tables
Is there a way to do this using SQL statements
Thank...
October 6, 2011 at 12:27 pm
Here is what I tried and it seemed to work:
CREATE TABLE #DateTest( id int identity(1,1),
...
October 6, 2011 at 11:03 am
Sapen (10/6/2011)
Hope all is well.
I have a situation where I am seeing that the size of the indexes that I have on my production db is equal to or...
October 6, 2011 at 10:55 am
JimS-Indy (10/5/2011)
INSERT INTO tblBoMDetail
(BoMID,
BoMItemDescription,
BoMEItemQty,
BoMEItemfactor,
BoMEItemUOM,
BoMItemUnitMaterialCost,
BoMItemUnitLaborHrs,
BoMlaborComplexity,
BoMvendorName,
BoMvendorPartNbr,
BoMItemID)
SELECT...
October 5, 2011 at 9:41 am
usharani.t (10/4/2011)
how to print all records in grid view without scrollbars.
When I have done this in the past, I created a new web form, put a repeater control on it....
October 5, 2011 at 9:29 am
Domestos (10/5/2011)
What...
October 5, 2011 at 9:24 am
Viewing 15 posts - 121 through 135 (of 210 total)