Viewing 15 posts - 391 through 405 (of 851 total)
Bob Hovious (3/24/2009)
March 24, 2009 at 1:27 pm
GilaMonster (3/24/2009)
YSLGuru (3/24/2009)
Where did you see this formula listed ofr getting the Start of the month?
I don't recall seeing it anywhere. The version to trim the time off a date...
March 24, 2009 at 1:08 pm
[font="Verdana"]No, database roles are different.
If you are using Windows Authentication, then (hopefully) you have some sort of Windows directory service (Active Directory or Kerberos or something of that nature.)
Create a...
March 23, 2009 at 6:28 pm
Rob Fisk (3/23/2009)
There are a huge number of instances where you would want to format the date within sql or get its various elements.
[font="Verdana"]Agreed. But there are also a...
March 23, 2009 at 5:59 pm
[font="Verdana"]Interesting. I would agree that SQL is not "relational" as Codd envisaged it. I'm not sure that's necessarily such a bad thing, and to point at some failures...
March 23, 2009 at 4:54 pm
[font="Verdana"]Okay, some thoughts:
The first is, do you really need to be formatting dates at the SQL Server level? A lot of the time, this is best left to the...
March 23, 2009 at 4:37 pm
Takauma (3/23/2009)
Bruce:With the user example above, returns:
"TEAMWORK\akruesse" , "DBO", "DBO"
Desired value would be "Agnes_Kruessel"
[font="Tahoma"]
Interesting. Have you tried creating a login for a Windows AD group that has rights to...
March 23, 2009 at 4:31 pm
[font="Verdana"]Okay, so you have used Windows authentication.
I did a quick check on a database here which uses Windows authentication. There's a login created for a group of which I...
March 23, 2009 at 3:07 pm
[font="Verdana"]What is your system doing that it needs to provide the ability to run dynamic functions?
I can think of worse things, because there's certainly a limit to what functions can...
March 23, 2009 at 3:02 pm
[font="Verdana"]Here's a modified form that will work with SQL Server 2005.
Note that I have not reviewed the code other than to change the issue of assignment during variable declaration (a...
March 23, 2009 at 2:16 pm
[font="Verdana"]Woot! Article from Gail! Finding the Causes of Poor Performance in SQL Server, Part 1[/url]
Of course, I never have to find causes of poor performance myself... noooo....
[/font]
March 23, 2009 at 1:18 pm
[font="Verdana"]Well... didn't this thread start as a rant about the (percieved) inadequacies of the T-SQL language? In which case, discussing alternatives to the way SQL does things (as...
March 22, 2009 at 9:21 pm
steve dassin (3/22/2009)
I'm not saying sql is flawed. I'm saying sql is flawed when it comes to application development.
[font="Verdana"]I guess I am slightly lost on what the difference is. ...
March 22, 2009 at 7:15 pm
Jeff Moden (3/22/2009)
March 22, 2009 at 2:58 pm
Sergiy (3/22/2009)
And believe me, mapping of SourceSystem+OriginalID to InternalID works perfectly.No service required.
[font="Verdana"]Heh. Not when you have an enterprise architect who insists that the appropriate solution is to...
March 22, 2009 at 2:52 pm
Viewing 15 posts - 391 through 405 (of 851 total)