Hello - can anybody recommend a good source for this? I tried looking at Transcender, but it seemed like it was mostly for the admin side.
Thanks
If a table looks like this:
Startingrollnumber numberofrolls yardsperroll rownumber
1 10 1 1
11 2 1 2
50 1 1 3
51 3 200 4
54 3 200 5
57 15 100 6
72 ...
Hi,
I'm trying to build a stored procedure that calculates the sum of a column minus 1 and then updates the table with the new value for instance using the table below -
A var @param (i...
Experts,
Please see my data in the code part below and here is what I need to get
a) I would like to get the the rows where the code (column name) like CA (which is straight forward)
b) ...
hi experts!
Secenario:
1 SQL Server 2000 instance
1 Database, call it SQLDB1 (shared by multiple related systems)
I'm developing a new system that needs to reference (no transaction) t...
This is the best I can come up with using SQL Server 2008 Management Studio to change both column and table names for an existing database. I have approx 60 columns and 10 table names. I'm usi...
HI,
do you know of any tool, script to check the SQL accounts.
=> who is administrator
=> accounts with different security settings
=> this on a list of sql servers.
I want to build a...
Hi. I have a table
STATE YEAR PRICE
CA 2008 $50
I Want to get it to say :
STATE 2008
CA $50
Any thoughts?
I am trying to modify some minor text entries in a web form that is generated by a GUI driven designer front end that autogenerates the .net code. It is a Blackbaud product that had its roots ...
Hello Experts,
I'm using sqlserver 2000
How to assign a value for ntext datatype within a stored procedure?
SQL has a bunch of Profiler fields for 'Reserved', specifically, 0-9, 29-32, 48-49,56-57, 62-66.
How do you understand the significance of these?
Let's say I have a long transaction that performs inserts and updates to rows in a database, that I ultimately rollback (not commit).
Are those changes visible to other queries during the t...
I am looking at a query that says:
Select * From EB_LD_Investor Where InvestorID = @InvestorID Order By FullName|@InvestorID
What does the segment FullName|@InvestorID do? More specificall...
Hi
I am using the following case expression to sum the turnover for depots for the period up to today last year, I dont think this quite right as tests against the data without the group ret...
Hello - I'm just trying to copy & paste a trigger from my ss 2000 db to the 2005 version (because the "import" feature doesn't seem to actually import anything but the data), and I don't see w...
Experts,
I have a SQL server 2008 Stored procedure that searches data in a view with 3 or more column in it. This search can only look for one word that matches data in any of the columns in...
I want to get the value of @v_end_date, which is the first day of the month plus 14 days. But I get a syntax error for @v_end_date. The error is "Syntax error converting the varchar value '0...
I have a website which connects to SQL Server 2000 database through a connection string.
The database user specified in the connection string should be able to do the following in the data...
I have an SP and two of the fields are PED and HoursEarned.
PED is a smalldatetime and HoursEarned is a float. currently, my order by clause at the end of my SP reads like this:
Order By...
Hi: I started having a poblem with MS Access database that uses DSN to connect SQL database after installation of VB6 application. I don't have any problem on my PC that has WINXP with SP3, my...
Is there any way in SQL Analyzer or Management Studio to get the output display vertically? Google fails me and I thought this would be an easy question. Maybe it's not possible., but I find...
How to configure MSSQL 2000 to allow a non-admin user to be able to start/stop the job agents? I've been looking around and there are easy ways for SQL 2005 or later, but can't find one for SQ...
Hi,
My company needs a person who knows ssis package.
I have worked on sql server 2005 and 2008 and have little knowledge in sql queries.
I need to learn this.
Any help?
I have ...
I am copyingthe select and insert statements from a trigger i created but its not working as planned, what I need to get is the result of the sql query that is run, so my thoughts where to jus...
I have never had to have anything to do with databases so I am really fumbling in the dark. I however have been appointed the task of migrating a database from a small business server 2003 to ...
