Viewing 15 posts - 1,096 through 1,110 (of 2,010 total)
If I'm understanding your process, you pass in a date in a character string and get back a result set. You'd rather have the date as a datetime so...
February 19, 2009 at 10:36 am
I'm wondering if the system you are describing and/or the ODBC driver support the Ansi join syntax. I've seen a few legacy systems where they still require joins in...
February 19, 2009 at 9:06 am
You could do this with a check contraint. Here's a reference from BOL...
http://msdn.microsoft.com/en-us/library/ms179491(SQL.90).aspx
Basically you'd just do an alter Table Statement like so...
Alter Table myTable
ADD CONSTRAINT CK_mytable_Shai --or whatever meaningful...
February 19, 2009 at 8:57 am
A lot of it depends on what you are trying to do. If you are accepting dates without time from your users and or are passing them in yourself,...
February 19, 2009 at 8:38 am
can you be a bit more verbose about what you are trying to accomplish including the number of expected users, the type of environment etc... Depending on these, there...
February 19, 2009 at 8:24 am
Have a look at the following from Chris Burrows Blog...
It's not so much how to back it up withhout the users, but a script to run to fix your orphaned...
February 19, 2009 at 8:11 am
Most times I've seen this done, it was in some sort of web application or document management app.
Basically, the location of the file is stored in the db, most times...
February 19, 2009 at 8:03 am
You would update a datetime column as you would any other column. Replace whateverValueYouWantItToBe with a valid datetime value in the below code.
UPDATE myTable
SET myDatetimeColumn = whateverValueYouWantItToBe
WHERE...
Are you trying...
February 19, 2009 at 7:56 am
Jeff and J, like Jeff I'm no expert where it comes to SSRS, but I have done a decent amount of developing with them. While I'd doubt that matrixes...
February 19, 2009 at 6:24 am
I'll toss another on the pile recommending a set based solution. This seems like a perfect teaching/mentoring moment. At the very least she should be commended for coming...
February 17, 2009 at 4:30 pm
according to the KB Article it has to do with user variables not being propagated through to the linked report. If you want to fix it either a) remove...
February 17, 2009 at 2:11 pm
It's not the best idea to keep shrinking and expanding your log unless you really need to. If your log needs to be that large, then just keep it...
February 17, 2009 at 1:37 pm
the run_date column shows the date the step ran.
the run_time column shows the time the step ran, ie 140000 = 14:00:00 = 2:00 PM
the run_duration column gives you the amount...
February 17, 2009 at 1:17 pm
I believe you can only grow the transaction log once per transaction, so if you are tryin gto insert all of those records in one shot, the log may grow,...
February 17, 2009 at 1:02 pm
The run_duration column of sp_help_jobhistory doesn't give you the run duration?
February 17, 2009 at 12:55 pm
Viewing 15 posts - 1,096 through 1,110 (of 2,010 total)