RE: Copy SP
INSERT INTO tbl2 (fname) SELECT fname FROM tbl1 WHERE ref#='123'Btw, the # sign isn't really good to be used as a column name. I have seen several threads here, where this caused more or less severe problems.
2004-12-16
Clustering
RE: need help with a query
Thanks a lot, Earl. Interesting solution. I briefly looked at the article.. that seems to be exactly what I was looking for. Looks like it should work fine for me...will let u know, if I run into a problem. Thanx again.
2004-12-15
RE: Copy OLAP database with different data source
Ok, here a way that works and will take about 10 minutes of your time. Not the best of solutions, but the only one that works for me. Find out where your repositry is located. It is either in MS Access and is called msmdrep.mdb or it is on your SQL server in the MSDB […]
2004-12-08
RE: Missing record!!!
I am using vb6 with adoI was used to use addnew with a recordset but so I will use somthing like "insert into dbo_invoice (invoice_id, invoice_date) select max(invoice_id)+1 as new_id, getdate() from dbo_invoice"what will gurantee that using rs.open "SELECT @@IDENTITY AS 'Identity'" will return the Id created by the application current user and not by […]
2004-12-03
RE: Sending mails using DTS
You can make it the last step in the package, or make a second package and use the job system to call the 2nd when the first successfully completes.
2004-11-22
RE: WARNING: Failed to reserve contiguous memory of Size= Can anyone help?
We ran into this on a 4-way machine running win2k and sql2k. MS recommended that we have use the '-g 384' switch for SQL Server startup. That reserves more space for COM objects and extended stored procedures.We ended up having to increase to '-g 512'. But the problem has not reoccurred since then.
2004-08-25
Administrator Password Got Change!
I know that I should not post this question in this group, but just take a chance for fortune since we have a lot of experts in this group. I had a serious problem. Someone had changed our domain admin password. Is there a way to figure out who changed it, or by any event […]
2004-08-12
RE: deduping data in a flat file
If you have room for two copies of the data, I think this might run faster than the self-join and DELETE method.First import the data into a staging table.Then create another staging table with the same structure, and put a unique constraint on the dedupe fields using WITH IGNORE_DUP_KEY. SELECT * INTO StageUnique FROM Staging […]
2004-08-12
RE: Disabling all level in a virtual dimension
For a virtual dimension, the All level setting is disabled on the advanced tab
2004-07-27
RE: SQL Server Service Shutting down unexpectedly
Also check machine application and system logs for any information may related. You may also have SQL Server dump file created in SQL Server log folder. In order to analyze them, you have to send it to Microsoft.
2004-07-26
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers