Viewing 15 posts - 46 through 60 (of 110 total)
quote:
Hi,When I try to do this through the view it will not let me leave the column empty saying,
"The Column 'testingID' in...
He who knows others is learned but the wise one is one who knows himself.
August 29, 2003 at 12:56 am
quote:
Hi,When I try to do this through the view it will not let me leave the column empty saying,
"The Column 'testingID' in...
He who knows others is learned but the wise one is one who knows himself.
August 29, 2003 at 12:54 am
I managed to get the answer.
In the script method we need to enter a combination of SQLDMOScript type separated by OR.
Pay Respect to People on your way up. For you...
He who knows others is learned but the wise one is one who knows himself.
August 28, 2003 at 10:42 pm
quote:
Sorry, I didn't word my question clearly.Getting the line total isn't the problem. Getting an extra row at the end of...
He who knows others is learned but the wise one is one who knows himself.
August 28, 2003 at 4:50 am
quote:
I want a query that returns only the grand total with no subtotals.For example, I want a resultset of all orders...
He who knows others is learned but the wise one is one who knows himself.
August 28, 2003 at 3:51 am
Have you tried detaching the database and then attaching it again.
Pay Respect to People on your way up. For you will meet the same People on your way down.
He who knows others is learned but the wise one is one who knows himself.
August 28, 2003 at 2:30 am
quote:
What is the best way to do this? DTS? Store procedures???Should I scrub the data first into a staging database?
He who knows others is learned but the wise one is one who knows himself.
August 28, 2003 at 12:57 am
Addendum
The code will not function properly if the stored procedures refers any temporary tables (#).
Pay Respect to People on your way up. For you will meet the same People on...
He who knows others is learned but the wise one is one who knows himself.
August 27, 2003 at 11:16 pm
Copy Paste his Code
You Will need to have a Listbox1 and a text box on the form.Please do the required changes.
Start
Option Explicit
Private Sub Command1_Click()
Dim oCon As...
He who knows others is learned but the wise one is one who knows himself.
August 27, 2003 at 6:29 am
FROM BOL 🙂
The Microsoft® SQL Server™ ntext, text, and image data types are capable of holding extremely large amounts of data (up to 2 GB) in a single value.
If an...
He who knows others is learned but the wise one is one who knows himself.
August 27, 2003 at 2:18 am
I checked the sysprocess table and none of the spids seem to do so.
One thing I forgot to mention is that sql2000 is on NT4 Server.Will I benefit by switching...
He who knows others is learned but the wise one is one who knows himself.
August 25, 2003 at 12:12 am
Yes it is SQL Server that is runing near 100%.
Pay Respect to People on your way up. For you will meet the same People on your way down.
He who knows others is learned but the wise one is one who knows himself.
August 24, 2003 at 11:19 pm
If you have Id field then try using the replicate function to get the required indentation.
select replicate('-',id)+ cast(name as varchar(100))
Pay Respect to People on your way up. For you will...
He who knows others is learned but the wise one is one who knows himself.
August 22, 2003 at 4:14 am
For Curiosity. Are you using begin trans in your stored procedure or starting the transaction from the front end, if it is the stored procedure itself then you need to...
He who knows others is learned but the wise one is one who knows himself.
August 22, 2003 at 4:02 am
quote:
If you can shut down the database I've always found that the quickest solution is immediately after a full backup to use...
He who knows others is learned but the wise one is one who knows himself.
August 22, 2003 at 3:14 am
Viewing 15 posts - 46 through 60 (of 110 total)