Viewing 15 posts - 12,691 through 12,705 (of 13,465 total)
it's not hard at all, as long as there is something that uniquely identifies each product. My example below only uses two columns, you would need to use all Company,Departure,Country,Destination,DepartureDate,Hotel,Roomtype,Duration
you...
February 21, 2007 at 4:46 am
you could also enhance the web application by adding another call to an audit stored proc...so what i'm saying is for every call in the web app that is doing...
February 21, 2007 at 4:12 am
also the date add function accepts negative numbers, so if you need something like "15 days back from today":
SELECT DATEADD(day, -14, getdate()) AS TwoWeeksAgo
results:
TwoWeeksAgo
------------------------------------------------------
2007-02-06 17:03:39.997
(1 row(s) affected)
February 20, 2007 at 3:05 pm
can you modify the code and the stored procedures to pass/use a new parameter? If you can't modify the web service, you'll really be hampered in auditing.
I'm assuming the web...
February 20, 2007 at 11:22 am
you can send the query to SQL with the following options:
SET NOEXEC ON
SET PARSEONLY ON
SELECT * FROM SOMETABLE
SET NOEXEC OFF
SET PARSEONLY OFF
you could then simply return the errors returned from...
February 19, 2007 at 1:21 pm
what is the source of the file...i had an issue before where the source was UNIX based text files, so the terminator is not \n, but another...\r (just Cr) ?...
February 19, 2007 at 11:03 am
here's an example i had handy: filename is build with a combination of variables and current time/date.
replace your query where the query in red is below.
declare @outfile varchar(250),
@strCommand...
February 16, 2007 at 2:35 pm
hehe... same example, but i beat your post by a whole minute!
great minds and all that.
February 16, 2007 at 2:01 pm
in sql server , you can use a calculated column; (not available in oracle...you'd have to create a trigger to do the same thing); note i added logic to watch...
February 16, 2007 at 1:56 pm
Eddie thanks; you pointed me on the right track; by using the sp_Oa procs, and a bit of minor modifications to my test dll, i was able to read any...
February 16, 2007 at 9:11 am
could it be something as simple as statistics or something?
I had a situation where a developer turned off automatic statistics in his test database, and over time his machine...
February 16, 2007 at 5:09 am
check out this recent post:
there's no native way I know of to use TSQL to create the image...the image data is usually handled by an object that can handle a...
February 16, 2007 at 4:51 am
check out this recent thread on the same subject:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=333827
a few different examples were given on how to search syscomments, especially how to avoid the rare situation where a tablename...
February 16, 2007 at 4:43 am
search for the Split function in the scripts section of SSC; there are several that will do this.
searching for Split in the forums will get you loads of ewxamples as...
February 15, 2007 at 11:10 am
someone has posted something similar in the script submissions as well:
http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1584
Script Rating
February 15, 2007 at 6:17 am
Viewing 15 posts - 12,691 through 12,705 (of 13,465 total)