Hello Experts,
I would like you to view my code to see if you can determine the error if possible. I am populating a cursor and I need to check if each variable has data in it. If it does, ...
How can I get SQL Reporting Services reports emailed to me daily?
I have a client that will be converting their Accounting Sys to a version that runs on M/S SQL Server. We have two separate Front-End applications developed in Access/VBA that connects to the...
I have a result set where I need to check multiple rows for a change in one field. Here is an example of the data:
Emp# Type Date Effective
401 1 1987-06-05 00:00:00.000
401 ...
I migrated some DTS jobs from our sql 2000 server to our new sql 2005 server. How Do I Create a Job in SQL 2005 to Run the Migrated DTS Package? In SQL2000 you just right click and schedule ...
Running SQL server 2000 on Windows 2000 server standard.
You know databases can be backed up to devices or files. One has to use a special command to create a device. I did NOT create devic...
Hello,
I am a beginner wit both SqlServer and ASP.NET. yet I am experimenting with publishing my first site.
I have the files published and the database on the hosting service server.
How...
Field
=Fields!TOTALTIME.Value
In reporting services comes back as total seconds for a day.
If I divide it like this.
=Fields!TOTALTIME.Value / 60 / 60
I would get results like 7.50, and 7...
There are a ton of records in the database with odd characters at the end of records, see attached.
What would be the best way to clear them out, without affecting the actual real data in t...
I have a query that compares 2 patient tables, and updates the record in a master patient list where there are matches. That works fine (code sample below). There are 2233 matches.
I want...
Hi,
I need to count patients by category and combination of categories. I have a table with:
pt_num, category
1, A
1, B
1, C
2, A
2, B
3, A
3, C
4, A
5, B
6, C
7, B
8, C
9, ...
Hello experts,
I am trying to write a stored procedure script to insert into a table.
I want to.
1) Get the count of the rows - If the count is zero then headlines_Order field will be...
In visual studio, I have a table in my database whose columns all represent if a task has been completed or not, bit values. I have another table with descriptions of each task, 1 task descrip...
Not the best, I know, but I'm using the proc below on SQL v2000 for two things --
first, the previous business day's data is written from current table1 to historicaltable1 based on @start a...
We're upgrading an old SQL Server 7.0 box to SQL Server 2000; unfortunately, as part of our backout plan, we must also include an option to reinstall SQL Server 7.0. I cannot locate the SQL Se...
I am trying to create a simple ODBC (preferred by the application) from server1 to connect to Server2 ( where SQL Server is hosted)
I can login as the user1 on SQL Server (server2) with user1...
I have several queries, which are aggregated based on thier own filter optin to return a figure. they work fine but when i try to break the aggregates and group by date, i get duplicates.
I...
I need a stored procedure that will add logins to my MS/SQL Server having a type of "windows user". The MS/SQL stored procedure sp_addlogin seems to only add "standard" type logins and will n...
Morning Experts
I currently have a stored procedure that creates rows on a table located on a network server. I manually run this SPROC once a week. I wanted to know if anyone knows of a ...
I'm looking for a utility that I can use to script objects for my SQL Server databases (versions 2000+). Ideally it would include the ability to choose individual objects for scripting, includ...
this has been running for 2:54:04, and i've only written 650,000 records. i have another one, near identical, except it's a different set of current/history tables. also running for 3:21:17,...
In the command line below...which works...
How would I reference a remote SQL Server instead of the local one?
bcp "exec pepweb.dbo.fileout" queryout properties.csv -w -S lrbristerpc -T -E
Good morning everyone,
I contracted a company to setup my SQL backups to backup every hour. I asked for this to be done within SQL. They have come back to me and told me that these have ...
IF @start IS NULL, I want the proc to go to current day table for the current day data.
Else, the proc will go to the historical table with the @start and @stop provided.
IF @start IS NULL A...
Hi,
A colleage of mine came to me this morning asking me if I have ever seen my reports refreshed after work hours. he had finished up for the day around 5pm and this morning when he came t...
