RE: Cursor updating all records.
I'm sure with over 300 posts on this site you have heard of the CAST or CONVERT functions.
2005-03-31
Restore
RE: use of trigger to update history table
CREATE TRIGGER Itr_T_Current ON T_Current FOR INSERT AS insert into T_History select * from insertedGO
2005-03-15
RE: Version Control - Dealing with Code
For Version Control I Use Subversion and Imceda's New Speed SQL IDE. It it very nicely intergrated with most Version Control Software and relatialve inexpensive. Its a life saver. VS is very expensive. Subversion is Free Len
2005-03-11
RE: Storing images and pdf files in SQL Server 2000
We also conducted reseach as to where the best place to store images/documents. Our orignal plan was to store the images in the file system and use Availl to replicate the images through the firewall. We were having difficulty getting this to work properly, so opted for Plan B, storing the images in sql server. […]
2005-03-11
RE: T-SQL query from a cube to the datasource database.
the following article could possibly help (it's about using AS and RS, look towards the end re: actions) but will depend a little on how dynamic you need to query. If it's only ever going to return customers etc, then this may work for you.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp steve.
2005-02-20
RE: Which Query is Right?
After some additional testing, it looks like query 1 is correct:select s.suiteid, s.buildingid, s.SuiteName, b.buildingnumber, g.suitename, g.buildingID from suites s inner join buildings b on s.buildingid=b.buildingid LEFT JOIN RealmStageSuites g on g.buildingid=b.buildingnumber AND g.suitename=s.suitename WHERE g.suitename IS NULL AND g.buildingID is NULLAnyone know what's wrong with Q2?
2005-02-04
RE: Uploading Data from Text file with different column name
Thanks david, Thanks a ton for help...But i Have already done with this but by other way.. I am still in problem... while putting the data into table in DB... I am Data Type Mismatch error... How to handle that Boss.... U ahve any Idea... I will Tell you what i did.1 BCP to upload […]
2005-02-04
RE: Query Help - Adding a column that sums other columns
No I missed that one Jeff. Thanx for the correction.
2005-01-27
RE: SQL to trigger an ASP file
Hi,I've implemented something similar to what you're asking for. I use the Windows Scheduler on our server to launch internet explorer with the URL of an ASP page every day.That ASP page looks in our database to see if anything needs doing, then does it!Good luck!- Chris
2005-01-27
RE: SQL Server does not exist or access denied
Thanks u all for the responses. I tried to connect thru query analyser too but there is same error " Server does not exist or access denied" & also it is not connecting with "local". what can i don now in this situation? can I backup my data in anyways??
2005-01-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