SELECT CLIENT_ID, CLIENT_ROLE_CODE, CLIENT_ROLE_DESCRIPTION, CLIENT_ROLE_MANAGER_EMAIL,
CLIENT_ROLE_MANAGER_NAME, CLIENT_ROLE_MANAGER_GPN, COUNTRY_CODE, LAST_UPDATE_D...
I need to separate the prefix of the email..that is, everything before the @ in a select statement:
susie@mysolution.com becomes susie
I have an existing SQL 2005 database and I alsoI have a third party database (hosted CRM product) that I am trying to access to pull some information from. The third party database is availab...
Hello,
I saw a Task Manger process running as "sa" that was blocking one of our data loads.
Anyone know if we should be looking at something or can I kill the process?
Thanks,
Howard
I have a database with a field called id_number. This field was originally designated to allow varchar(20) so some of the ids are birthdates like so:
08/18/1972
I am trying to import thi...
I have 2 tables that both contain a nvarchar(20) column named Client_ID.
I would like to retrieve the Client_IDs from table2 that have entries in Table1 but do NOT have entries in Table 2 bas...
I have an issue with a OLE Text file that I am reading into a table then building sql statements from...
the problem is that any field that contains a ' character is getting messed up...
H...
i have a database that imports data from our ERP system on a daily basis. before the import, each table is "cleared" with a "delete from" statement.
do i need to defrag or rebuild indexes ...
i have two databases.
db1
db2
i have a table in db1 that has part names.
i have a table in db2 that also has part names
however, the part names in db1 are not exact. the easiest wa...
I have a VERY complex stored procedure (OVER simplified version attached below). It does a bunch of inserts and updates. It sets local variables by selecting values from DB. It returns two ...
What is available for free or for reasonable price?
Hi experts,
I am learning for the Microsoft certificatioin 70-431 Microsoft SQL Server 2005 Implementation and Maintenance. I have bo...
the attached sql statement is working fine.
basically is used for filtering on a drop down list.
what I am wanting to do is filter this list depending on logged in user (i.e. different r...
HI
I have values in a Table that have Ox in front of all values. This values are all binary values
I trying to replace Ox with nothing and getting funny values. I am using SQL 2005
E.g ...
I am trying to take a date picked from an asp calendar using the selecteddate value and put it in my INSERT statement to put it in a field that stores datetime.
When I execute my code I get...
Hi,
I have a following doubts which I don't understands why I can't see any tables belongs to filegroup below, see a file below file which having 190GB of used data space but couldn't find it...
I have been given the task to create an empty installation database for our application. I am trying to use SQL Server 2005's generate scripts. Is there any way to generate a sql file for the ...
I have the following SQL Server Tables:
Users Table:
UserId --integer--primary key
UserName -- nvarchar(50)
*******************************************
ListA Table:
UserId --integer
...
I have read a number of artlcles and whitepapers on Encryption in SQL 2005 and I think I understand the theory ... however, when I try the following :
BACKUP SERVICE MASTER KEY TO FILE 'C:...
I am trying to install Goldmine Premium edition on a Windows 2003 Enterprise Server. I want to use my existiing SQL 2005 database. When I enter the SQL login information i get an error sayin...
Hi
I need to make a table in MSSQL that has a constraint which stops the same three values being entered in different cells. E.G.
Table1
Col1 Col2 Col3 Col4
100 10 10 455
100 10 9 45...
I launched a new website in April which uses SQL Server 2005 Express. I just reviewed the error logs and see several instances of login failures. Almost all are Error 18456, Severity 14, State...
I am trying to load into a fact table that is part of a star schema. The fact table has 6 FK constraints. The data is being sourced from an old version of the fact table which has no Foreign K...
I am looking for a little advice on laying out my tables.
Essentially I have props within my game world, details on these are stored in a database. Basically I have 2 tables right now.
P...
I have developed and deployed my first cube. I have decided to amend some of the underlying views to make some of the names more user friendly. I have updated the data source view, but if I ...
Hi,
I have a table in SQL Server 2005 with a special column name, [C No.] for example. How do I write the column mapping in Hibernate? I have tried both "[C No.]" and "'C No.'" and none see...
