quote: Works like a charm, thanks! Thanks! This is my first time making suggestions on this site. I always come here for questions instead 🙂 Here's a loop to remove multiple spaces... ------------------------------------------- declare @strName varchar(100) select @strName = ' S t J a m e s ' while charindex(' ',@strName) > 0 begin select […]
2003-08-20
2 reads
Another query I hate to key in is INSERT INTO especially if there are different column names involved.
2003-07-24
1 reads
I fixed the error and the CASE way works great! Thanks alot to everyone who replied. I learned alot more about how to create these complex queries. I appreciate all your help!
2003-07-17
Hello Frank and Brian! quote: 'put Guest into DB_Role db_denydatareader' And => this login still has access to master. Right 🙂 But I was doing it as a counter-example. You have a 'valid' login but you cannot login. Hence you cannot execute your SELECT. So there, Answer nr 1 does not work. quote: Hans:quote: You […]
2003-07-16
1 reads
-- What kind of Complex transformations? -- Your business rules change the data? And you want to replicate, yes you can.
2003-07-15
Are you talking about part of the condition or one of the column names, or are you retrieving data into the column? Please post a sample. Guarddata-
2003-07-07
quote: Yes. Those are the companies that believe that you (as the lone DBA) will have plenty of free time. In Texas the salary range is anywhere between $40K - $110K. If you can find a job, that is. I have seen "serious" ads for a laundry list of skills (DBA being just another one) […]
2003-06-18
2003-06-11
1 reads
Hello Crispin, quote: A guy started working here who had never heard of google. He asked was it good. To demo it, I searched on "How do I wipe my @55" being serious. What does 'How do I wipe my @55' mean. Is it something X-rated? Cheers, Frank
2003-06-11
One thing we found was that the disk that the data files are on is extremely fragmented (data area - > 90%, free space - 5%) Can this cause the problems with accessing the #tables? We didnt' notice any slow down accessing regular table, only #tables.
2003-06-06
By Steve Jones
A customer was having some trouble getting started with Azure DevOps (AzDO) and building...
By Rob Sewell
In this post, we share the strategies and techniques we've implemented to ensure our...
By Steve Jones
I had a customer that was concerned about the fragmentation alert for indexes and...
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