EXEC [dbo].[GetBondViewNew]
@BondId = NULL,
@Initials = Null,
@PolicyNbr = NULL,
@ActivePolicy = NULL,
@PwrOfAtty = NULL,
@debug = 1,
@BondTypeId = NULL,
@BondAmountLow...
Dear Experts,
I have two varchar (16) columns,SERIAL_NO_FROM and SERIAL_NO_TO.
I need to get a new column to claculate number of cards = SERIAL_NO_TO - SERIAL_NO_FROM + 1.
I tried to use ...
Hi, Recently I found an article that showed a simple way of getting rid of the transaction log without much stuffing around. It involved deleting the log file and re-attaching the mdf but I ca...
Folks,
I'm getting the following error...the problem is that I can't isolate which column is causing this. My INSERT statement references 200+ columns!!! Is there a way to tell which spec...
SQL Server 2005
If a person has come (timein varchar(8) ) 180 minutes late then his office time (otimein)
he should be treated as 1 day absent.
If he is 77 minutes late, he should be trea...
Hi.
I would like to list out a couple of rows in every user table in a MSSQL 2000 database. The query works ok on a hardcoded table:
select USERID, MAILADDR, dateadd(ss,LASTLOGIN,'1970-0...
title says everything ?
input: servername output: nr. of database files using delphi 7 and ZEOS database access tools
I'm unable to connect to my SQL Server (my_computer_name/SQLSERVER). I was able to connect a couple days ago, but now receive the error message pasted below. In the last couple days, I've ba...
Table1 stores the organizational relationships for each customer. There are instances where a customer will accidentally link a childunit_id to the referring parentunit_id.
Need to remove a...
Hi,
I have a trigger that is supposed to insert some information into a table (dbo.TBLOELPRC_SQL) based on a change of unit price in the dbo.OEORDLIN_SQL table. Below is the trigger and the...
My attached code works fine...
But in DYNAMIC SQL I need to pick up the ID of the inserted record and then execute another insert statement into a seperate table with that ID, getdate(), an...
Hello experts,
I would like to know how can I execute a dll created in c# in sql server. I create an assembly in c#, after I add the assembly to the database. Viewing the information sur in...
Hi
We have 2x Test Databases that are not used very often, however both of these DB's (both on seperate SQL servers) have huge ldf files - 1x @ 102gb and the other at 180gb. I have ran a s...
How can I easily and quickly validate IP Addresses in a varchar field using SQL Server?
I have a table with about one million IP addresses stored in a varchar column and I am currently usin...
I've got a bunch of records with duplicate customerids. I want to copy all the duplicates to new rows and let the index identity renumber the customerid field.
When I have two records with ...
Folks,
During this past week I have had to reboot my SQL server three times. In my company we use a case management system that requires SQL Server and Server Agent to be running. At differ...
I'm running SQL Server 2005 Developer edition SP2 on Windows Server 2003. When I try to create a simple T-SQL based Job with one step, I get this error:
TITLE: Microsoft SQL Server Managem...
here is my sql query not work
what is miss
SELECT product.category ,Categories.images count( category ) as total_record FROM product
where product.category=(select parentid from Categor...
I have a database that has a 2GB set maximum size for the transaction log. I am wondering what happens when that size is reached. Does the log start overwriting old entries, or does it start...
Hello,
I search a script for deploy quickly a maintenance plan on several MSSQL for backup, update and rebuild indexes.
Thanks
Regards
Bibi
Hi
If all the columns are of one data type in a single row data, how do you order them.
For example, a simplified example:
select 6,4,7,3,999,24,22,42,4444
Is it possible to have SQL del...
Hi I have two columns in a database table
wirenumber, length
422A-1-1-74 75
455A-1-1-558 300
I want to take the last two numbers from each wire number and compa...
1)What is the difference between truncating and shrinking a log file?
2)Can you truncate a data file like you do a log file?
Which produces my results as follows.
GroupCustName ApptProgressStatusType
Cutomer1 on hold stage1
Customer2 complete stage2
Customer3 on hold stage1
Customer3 on hold s...
Hello Expert,
I have searched many forums but could not find any help. Is it really impossible???????
How can load pictures into Excel cells based on the first column values?
My first colum...
