I'm trying to get an overview of counted visits per day for a
webapplication.
The thing is that SQL doesn't work with full days. For instance: getdate()
returns a fulldate instead of a date in the format 'yyyy-mm-dd'. I need this

I am currently using the SET CONCAT_NULL_YIELDS_NULL OFF option to
concatentate three strings, one, two or all of which may be null.
I would like to insert a ", " in the appropriate place between the three
strings, ie. where two adjacent strings are non-null. At present I am using ...

In my nightly maintenance routine I'm getting an error when 'reorganizing
data and index pages'. I am changing the free space percentage to 10%. In the
log, the error occurs each night after the same table being indexed. The
error is something along the lines of:

I have create a temporary user with public db role and give him select
permission on one view, this is perfect for user defined objects scenario,
that the user can not access any user defined objects but the issue is here
that the user can access system objects and system db’s ...

I have 2 tables with similar construction.
DataOLD and DataNEW.
In my grid I need a JOINED table.
On the one hand I need all the data from the old table and the data

i need to programmatically obtain and process constraint key
information.  the problem with the output from sp_helpconstraint is
that it outputs 2, and sometimes 3 resultsets.  (the 2nd
resultset/constraint_keys is exactly what i need however)

To execute a job from VB, I use stored procedure with T-SQL :
EXEC sp_start_job @job_name = 'DTSName'

that's only to tell user that job successfully started, right?

One table I manage has a clustered index, and it includes some
varchar columns.  When it is initially created, all the columns
in the clustered index are populated, and then some of the longer
varchars are populated through update queries.  If the varchar

i need to programmatically obtain and the process constraint
information.  the problem with the output from sp_helpconstraint is
that it outputs two resultsets.  (the 2nd resultset is exactly what i
need though)

I'm using Access 2002. I have 2 tables tblGroupContact,
tblGroupPermission, both have 2 fields identical structure:
ContactID  GroupID (Both are Composite keys and both hold integers)
tblGroupContact holds everybody and the groups they are members of.

SQL Server 2000 SP4
I was wondering what has the best performance for maintaining
referential integrity ... triggers, constraints etc .....
Thanks,

I am wanting to set up some kind of metadata catalogue to manage
metadata records of the data we collect and create for my companies
clients.
I am thinking I want to do this using XML and SQL Server and have some

SELECT DISTINCT INSURED, COUNT(INSURED) AS C_All_By_Insured
 FROM CCI
 GROUP BY INSURED
 ORDER BY C_All_By_Insured DESC

I'm very new to using MS-SQL stuffs and the IT dept here doesn't have any
DBMA to speak of.  Thus, I'm a bit on my own - except for you helpful
people...
I just installed the Client Tools on my workstation and tried a simple query:

I have a DateTime column in a database table.
How can I get the equivalent UTC value for this column?
eg something like the DateTime.ToUniversalTime() in C#.
or select DATE_COL1, getutcdate(DATE_COL1) FROM TABLE