Viewing 15 posts - 2,011 through 2,025 (of 2,894 total)
MuraliKrishnan1980 (3/7/2012)
I have a staging DB where there are around 100 History tables. These History tables are used to store History values of the updated records for the Main Tables....
March 7, 2012 at 5:21 am
--> IF "Senthil" ID Passes means, no record should display
What about:
INSERT INTO #ReportingToPerson VALUES (4, 'Karthik', 3)
INSERT INTO #ReportingToPerson VALUES (5, 'Sanmugam', 3)
?
Why they shouldn't be returned?
What make them...
March 7, 2012 at 5:15 am
Would me more than happy to help if you could provide some DDL and data setup for your question. Please refer to the link at the bottom of my signature.
March 7, 2012 at 4:49 am
Jeff Moden (3/6/2012)
That's precisely what I was going to tell Eugene... the use of sp_ExecuteSQL doesn't necessarily mean that it prevents SQL Injection when someone uses it incorrectly. If...
March 7, 2012 at 4:20 am
GilaMonster (3/7/2012)
paul.goldstraw (3/7/2012)
March 7, 2012 at 4:13 am
paul.goldstraw (3/6/2012)
...Dynamic SQL is not an option as the industry I work in is quite security conscious, so I am not allowed to code for that...
Are you allowed to use...
March 6, 2012 at 3:08 pm
siva 20997 (3/6/2012)
I accept that the first method is bestCan we leave it at that
No one argued with that :hehe:
But I still advise you to read Jeff Moden's articles about...
March 6, 2012 at 9:47 am
Eric M Russell (3/6/2012)
Eugene Elutin (3/6/2012)
I would go with Eric M Russell's suggestion:Kill the project!
Give your users MS Access if they want to abe able to create tables themselves.
Unless...
March 6, 2012 at 9:43 am
siva 20997 (3/6/2012)
Line by Line code in Applications software is not thought of as good practice. It must be done in logical For next Loops etc and broken down niceley
What...
March 6, 2012 at 9:30 am
I would go with Eric M Russell's suggestion:
Kill the project!
Give your users MS Access if they want to abe able to create tables themselves.
March 6, 2012 at 9:02 am
not much given...
Select AVG(Datediff (day, StartDate, Lastattended)) as AverageTuitionDuration
From PersonalFinance as PF
Inner join PersonalProfiles as PP
on PF.ContactID = PP.ID
Where StartDate < Lastattended
March 6, 2012 at 8:54 am
siva 20997 (3/6/2012)
but there are a few reasons
1) I come from a windows programming background and making the execution plan...
March 6, 2012 at 8:51 am
jcb (3/6/2012)
Eugene Elutin (3/6/2012)
I have a gut feeling that this requirement comes from not very well thought out design.
Me too...
I cannot see why would you want to do what...
March 6, 2012 at 8:24 am
I have a gut feeling that this requirement comes from not very well thought out design.
I cannot see why would you want to do what OP has asked for. Even...
March 6, 2012 at 7:50 am
zeeshandar (3/6/2012)
Q#2: I have MS Access database of size 80 MB. If I move access db data to sql...
March 6, 2012 at 7:41 am
Viewing 15 posts - 2,011 through 2,025 (of 2,894 total)