Hi
i have a problem in ms sql, i wanna execute And Statement but i would like to enforce another restriction on the statement.
AND (VI.RatingCertificate = 0 Or NOT (convert(varchar(10),@SlotEndTi...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23641259.html
I have a stored procedure that is passed a uniquie value. What I would like to do do an insert if results are =0, an update if results >0.
How can I branch on the result of an aggregate query?
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22849016.html
I need create a function using the following query and need to call the function in a view. Can you provide me the function script with the below sql and show how i can use it in a view.
SELECT ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2292...
Hello Experts,
In my SQL Server 2005 I have registered two SQL server. SQLProd and SQLDev servers.
I have a table emp_Master in SQLProd database and I have emp_master in SQLDev.
I have add...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22926917.html
I have a table that includes a column for ImagePath which currently has values of
\\testserver1\<restofpath>
What I need to do now is change all the records in that table to
\\liveserver1\<...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22967610.html
MS SQL Server Management Studio express query: i'm curious to know if, as i have seen with other database tools it is possible to see the script (sql code) which was used to build the database tabl...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23023321.html
Hello,
We have changed server on one of the remote sites recently and had to restore the database. The users told us there was a sorting problem since the restoration so I investigated the appli...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23034089.html
I am in need of some assistance. I prefer to work with in sql server 2000 with either select statements, stored procedure, and/or functions. If I have to, I will do the programming outside of sql...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23038877.html
I'm trying to write a SQL Query that will provide me with a quick glance at the number of files sent for a given day.
Right now I have a Document table and for each document it has an ExportDate...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23053794.html
hi, i need to set the good right for my sql server folder, it work if i give everyone the right to sql folder , but i really dont like it.
i delete all the right on my server, because they where...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23053906.html
