I have a query that joins a Contact table with a Service table and provides me records based on an expiration date which works for my purposes. I now need to add a department field to the quer...
i have writtten a search stored procedure in sql server 2008.but how to pass parameters in the form string to the stored procedure.
here i my stored procedure is
alter proc sp_search_ca...
I'm running SQL Server 2005 SP2 Developer edition on WinServer 2003. I have an sql server job with one step. The step is a VBScript:
Option Explicit
Dim oIE
Set oIE = CreateObject("Inte...
I have a database on an SQL Server 2008 which is being populted by a custom application written in C#.
Lately i required some reports and made use of MS Acess 2007 to retrieve the data from...
I am installing SAP business one on my terminal server. The data server installation works fine. I installed all other clients on all my regular workstations perfectly without error. However w...
what type of records would be returned with.
MAX(DISTINCT CASE
Hi,
I have the following code what i want to do is do a loop for each scode in #scodetable
execute the query below and putinto #temptable2
but if from the query CID alreadys exists int...
Can anyone please send me tutorials or short notes to create reports in VB6, Would greatly appreciate
your help !!!
Thanks
Radhs
I have a field which is a date time stamp. For example this is one of its values.
2009-09-03 01:46:45.550
How would I get all values greater than a particular value e.g all values later tha...
My code does not account for wildcards but i am doing a sort of search all or by whatever fields the user selects and need to assign the null a wildcard so all records are brought back .. can ...
HI
I've got a table that I use to insert created invoices data.
Its called tblInvoices
Each time a new record is added it creates a incremental ID but also adds the ID order(OrderID)...
I am trying to write a stored proc to update a table. The @val1, @val2 variables are selected from the table.
I need to basically perform the following operation ((@val1 - @val2) / 1000)
...
It is possible to collect the values of one column of data into one row with a separator:
For example:
select names from tblpersons
Names
---------
Bob
Mike
Charlie
Mary
Rosie
Es...
When trying to chance a table/field attribute, we get the error:
Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created....
...
Hello
I am trying to restore a blackberry configuration database to a new bes install from a retired bes install. So far I've gotten the bak file from the backup and I've tried to restore usi...
Hello,
I am populating a grid in a vb.net 2005 application that contains rows based on week ending(friday) information.
Ex: Wk Col1 Col2
Sep 4, 09
...
What would recommend as the tools and counters that are good indicators of Memory Health in a SQL Server 2005 Box.
Thanks
My SQL Server 2005 install sees only the C drive as the available drive. I am running out of space on the C drive; and I have all the room on the network drive.
If I try to change the drive...
Slow SharePoint Performance
I am testing a SharePoint page form a group and it is very slop. They have build a customer page for the sharpen site. I have the call stack that has the latency ...
Hi,
I only saw resources describing how to enable xp_cmdshell in SQL 2005. I want to know how to do it for SQL 2008. And I am not having the sysadmin rights. So by default I think I cannot ...
I am trying to get the 2 queries below merged into one query. Basically there are 2 tables, and I want to sum the Units column in my results when there are 2 or more rows where the Orderid is ...
Hi,
I have these records and I want to get the same records plus the diference betwen the dates from the End Time of Step 2 and Start Time of Step 1
See atachment
Thanks in advance
SQL Server2005
I am member of sysadmin and hence authorised to delete databases. For some reason I want no one including me to delete a certain database say [payho_sql_bkp_20091006]
What...
How to import .RPT FILE into my sql server 2005 table
I have the following query identifying a heap of duplicates in a table.
How can I remove just one of the records found? There's a primary key named "ID" on the table if that helps.
