I am running a select query on a sql server DB, and trying to return a field which is encoded in Hex. I am then trying to display the Hex in a multiline textbox.
For some reason it just ou...
Please see the attached code snippet. The sp will work when all of the variable are passed. How do I get it to show all records when no variables are declared. I have tried to set the initial ...
Is there a better way to get a result set from selects on multiple tables other than UNION ALL? It seems rather slow to me. Is there another best practice for a scenario like the following code?
I need to idenitfy a list of "Sufficient Privileges" to my admin team to the SQL Server Agent Service account. We created a new user group, however I am getting an error when I change the Age...
Hi fellow experts,
Have two databases within SQL Server on the same server. I am trying to Import/Export Data from one database to another using the Import/Export Wizard. The reason i am do...
Hi, I need to run a query that will tell the length of characters for each record; so:
fieldA = somedata
fieldB = somemoredata
Then the query would return:
fieldA = 8
fieldB = 12
Can any...
Hi guys
I have this script
SET ARITHIGNORE ON
SET ANSI_WARNINGS OFF
SELECT
calls_bc_d.CompanyId,
Sum(TakenCount) Calls,
sum(uservalue05)/Sum(TakenCount) AnswerTime,
sum(Talktimet...
Greetings,
I have two views with identical data fields. I want to select all the data from each and list them sequentially. For example view1 has data field Order# with values 1,3,5,7. Vie...
We have a SQL 2005 server with reporting services enabled. I can view the reports if I RDP to the server and go to http://localhost/reports. However, when I try to do so from a desktop PC on t...
I want to create a stored procedure where I want to find the certain string pattern and replace with the one I want. This is very large sql string and I need to replace quite few string patter...
Hi
I am trying to query a linked DB2 server on Sql server 2005 directly but get the following error.
The OLE DB provider "DB2OLEDB" for linked server "MylinkedServer" does not contain the ...
I have the following Trigger which I cannot get to work on INSERT.
If I edit the record the trigger fires.
Please could someone point me in the right direction.
CREATE Trigger [dbo].[Up...
Hello Experts,
My online database server got crashed. Fortunatly we recovered the *.mdf and *.ldf files from the crashed hard dick.
Now I want to restore the database from *.mdf and...
Hi there,
I am trying to count some rows using a case statement, but the value is 0. how do I get to count each row so I know how many rows contain the value 0?
I tried Count(CASE when ...
Trying to build a SQL select statement to find a single MAX date value per customer within a group of possible values. Have a single table CUST1 with fields CUSTID, ORDERNO, ORDERDATE, SERIES...
Where can I get the Surface Area Configuration Tool software?
I import spreadsheets from various departments. Each has their own way of recording an employees name eg some depts include the employees initial, others dont, some put a full stop have the i...
My database contains multiple prices from my products by date. I would like to only pull the product and price of the newest date.
Have tried using the MAX but I'm not sure I'm using this cor...
Hello,
I am trying to write a SQL query for determining the amount of time between times in a table, that overlap midnight. I would like to have the time in seconds between the two times or...
Hi All, i have different situation where i am selecting from 4 tables into temporary table and one of these table contains identity column, so while i am selecting the records into this temp t...
I want to achieve the follwing functionality
while (getdate() < @StartTime + @GiveupTimeout)
call check proc
check results of proc
if success, do something
if failure, sleep for a sec...
How can I use a GROUP_CONCAT function in ms sql. is there any alternative to this? I have a table likethis
Name---------------------------Favorite Color ID
Jim---------------------------...
no passive nodes were successfully patched
exit code returned: 11009
I created a DB in SQL server 2005 and need to copy it to another system running SQL server 2005. When I try to attach it to the new server I receive the following error information:
TITLE: ...
I am trying to run a dtsx package with xp_cmdshell. The account trying to execute the Stored Proc isn't in the fixed admin group.
I have go through and tried to create a proxy account to...
