Viewing 15 posts - 12,736 through 12,750 (of 13,465 total)
I think it's because your server name has single quotes in it, which is invalid. i know you can use double quotes, but not single.
bad: DRIVER={SQL Server};SERVER='ISERVER';UID=sql_dba_link;PWD=MyPwd;Initial Catalog=SQL_DBA
good: DRIVER={SQL...
February 7, 2007 at 11:31 am
does this return a value? this should do the same thing you did when assigning it to the @x variable.
SELECT dbo.fnCalcBusHours( 1, 1, '8/31/2004 10:18:30 PM'
February 7, 2007 at 11:16 am
this might help: it shows each table, and what filegroup a table belongs to. if you only have ONE datafile per filegroup, then the table is contained in that datafile.
if...
February 7, 2007 at 11:05 am
i believe xdate1 is creation date, while xdate2 is last changed date?
this would list all users that havne't changed their pass in >60 days i think. yould probalby use this...
February 7, 2007 at 9:49 am
pretty much all functions have to be preceeded by the owner (usually dbo.)
this will work:
select Incident_Number, dbo.fnCalcBusHours(Cust_Id, Service_Id, open_time, close_time)
February 7, 2007 at 6:31 am
i had this saved in my snippets catalog: you can use it to determine whether statistics need to be run, or to run them. a paramter of I gets information(default),...
February 7, 2007 at 6:16 am
if you change your collation as seen below, you should see the results you expect:
CREATE TABLE [t1] (
[txt] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[nbr] [tinyint] NULL
) ON [PRIMARY]
GO
when you...
February 6, 2007 at 4:53 am
select dateadd(mi,1439,'05/07/2007') returns 2007-05-07 23:59:00.000
select dateadd(s,86399,'05/07/2007') returns 2007-05-07 23:59:59.000,
so create a statement like :
WHERE DATEFIELD BETWEEN '2/1/2007' AND dateadd(mi,1439,'2/6/2007')
February 5, 2007 at 12:12 pm
this will turn into an interesting thread, I'm sure...
If you take my data and put it into a database structure, the data is still mine, right? So If I learn...
February 5, 2007 at 11:40 am
this is a common issue, because the field you are querying contains date AND time....so records exist that are 02/05/2007 10:49:00 AM for example, which is not less that 02/05/2007..it's...
February 5, 2007 at 11:29 am
seems like kinda of a catch 22...you want to use sp_executesql, which is limited by it's paramater to a NVARCHAR 4000, but your command is potentially larger than 4000 chars.
I...
February 5, 2007 at 9:14 am
ugg... programming a solution because someone doesn't like to click print 3 times.....they don't need to File...Print...change to 3...just teach them to click the print button off the tool bar...
February 5, 2007 at 8:17 am
just to clarify, an option or checkbox must have the CHECKED in it's definition:it's a keyword, and not the "value"
<FORM METHOD=POST ACTION="">
<INPUT TYPE="checkbox" NAME="firstcheck" value="Value to send Via GET or...
February 5, 2007 at 7:56 am
I think we need a bit more information before we can really offer meaningful suggestions...
by syncronization of data, do you mean one way, from 2000 to 2005, with a change...
February 5, 2007 at 7:15 am
can't you simply export as comma or tab delimited, but name the the file xls so that it will open in the expected program? I know I do that all...
February 5, 2007 at 6:55 am
Viewing 15 posts - 12,736 through 12,750 (of 13,465 total)