Hi,
I am trying to create a nested SQl Case Statement but I am not succeeding lol. Here is what I have so far but it gives the following Exception:
Msg 156, Level 15, State 1, Line 11
...
I need a query that returns, for each sales rep, the percentage of customers who have placed 1 order, the percentage who have placed 2 orders, etc. up through "5 reorders or more" (so a total ...
Hi experts, can you tell me the difference between create "#...." and creating "##...." tables in detail please?
Hi - I'm new to stored procedures. Up to this point I've been doing everything with ASP VBscript from the web pages. I'm eager to learn and have ordered some books from Amazon. To get me kicke...
Hello,
I have three tables with structure as follows;
TableName: Jobs
Job_No int
Customer_ID int
TableName:Customer
ID int
Customer_Name nvarchar
TableName: Sections
Job_No int
...
Hi
I have a table with a integer key value and after deleting one of the records I'd like to update the below key values in order to mantain an order, how can I update these key values?
...
I did a backup before this problem happened (see pic).
How do I resolve this damn error? thanks
Trying to update 2 comon columns in 2 table based on a value only present in one table. Something like this, using correct syntax of course
update "table 1" & "table2"
Set "common ...
Hi All,
I have a TEXT field coming into my SSAS cube. seems like TEXT is not supported by the cube environment and throwing up an error. Can i change the data type on this field in SSAS. i...
I'm having a problem keeping my quotes closed. From the text file that I pull everytime from this new customer the Branch column is Rick's Medical Supply. As seen below that ends up closing ...
I have some very large scripts consisting of hundreds of thousands of INSERT statements. (these is the only "option" I've been given to import this data into my database). The script first c...
Hello Experts, I have a test sqlserver db on a server that does not have sufficient space on it. Now one of the user dbs has a transaction log file that grows to the max space that it is allow...
A sql 2000 server is hosting several databases.
Is it possible to look at the load on the server at database level i.e. which databse consuming most resources. ?
Hi,
I have like 2 or 3 tables that I need to renew each day.
It's like Message_0, Message_1 etc...
I would like to have a function or job or stored procedure to do the following:
Disco...
I had some weird problems with my server that reque I uninstall SQL and reinstall SQL2000. Now that I have done that I have attached all user databases, however the user accounts appear in th...
Is it possible to use Business Intelligence Development Studio (or Management Studio) to remotly access a SQL Server database using HTTP?
I need to design reports (so I am not updating data...
HI There,
I'm trying to execute a nested xquery loop in the code below but I keep getting the error below.I have a xml file stored in a column with products and underneath those products I ...
Does anyone know if I can make a procedure quit (raise an error) if it has run for more than x seconds?
My client is running MS Accounting 2007 - we are running into an error that the Primary Group is Full. The data base is set to AutoGrowth. Here's the error:
Could not allocate space for o...
I've found similar articles everywhere concering Linking Tables for many-to-many table relationships. However, I still don't know how the Linking table rows are populated. Is this done by Inse...
I am trying to drop a user and can't. Keep getting the message (in one way or the other)
The database principal owns a schema in the database, and cannot be dropped.
I have tables:
study
-------
id int
name nvarchar(255)
indicator
----------
id int
name nvarchar(255)
study_indicator
------------------
study_id
indicator_id
that is...
its me again. :)
I want to expand on the procedure below. at the moment if I pass in a department ID (@Dept) i get returned the department, category and product details and it all works goo...
Hello,
I would like to write a query to "pivot" my data that is in a table. I'm stuck.
Right now the columns look like this:
Garage Car Status Car Status Car Status Car Status Car Sta...
i exported data from a crm into a sql2005 database the tables (table1)have a user id field a hexidecimal number instead of the the account name as it was in the crm
in another table (table2)t...
