I'm trying to outer join two tables, but there are two values from the right side that I have to have, and I can't figure out an easy to do this. DECLARE @aging table (dt smalldatetime, cd int, bkt tinyint, cnt int, amt money) INSERT INTO @aging VALUES ('4/4/2005', 1, 1, 1, 10) INSERT INTO […]
2005-04-04
2 reads
I'm sure with over 300 posts on this site you have heard of the CAST or CONVERT functions.
2005-03-31
I am doing an import from excel into a SQL server table through a datapump task. How can I get the filename of the excel, which is the same as the uploading company, strip the .xls extension and insert it in a column (company, nvarchar(50), not_null) in the target table.
2005-03-31
2005-03-23
Hello.I've read a bit about SQL Server and memory and it seems I have found conflicting data. Most of our servers have 4 gb of ram.None of our servers are running SQL Server Enterprise edition (all are standard edition).Is it true we are only using 2 gb of memory on each server?Must we include the /3gb […]
2005-03-17
4 reads
Sorry, the group is set up as a login using windows authentication rather than sql authentication. I will check the type of group used but i would of thought that it would not be possible to see a domain b local group from within domain a and sql quite happily acknowledges the group exists.
2005-03-16
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
sorry to be a newbie, but what do you mean "do you have an UPDATE trigger on the table?"..
2005-03-09
I have an existing table structure as follows:id owner VIN1 dave 86902 matt 86903 joe 77134 barb 3417 What I need to do is re-arrange the data so the results are like:id owner1 owner2 VIN1 dave matt 86902 joe 77133 barb 3417I have created a temp table that has the new structure but I'm stuck at how to […]
2005-03-09
1 reads
Noel,This was a good point. Yes, the database compatibility level is 6.5 on the SQL Server 2000. It can not connect to the server to get a lis of applicable databases at all. It is exactly the step where the timeout happens. All other SW is able to connect to this database from the same […]
2005-03-09
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers