RE: stop time automatically
Thank you very much Guys.I just created a new job which stops my worktimes automatically.all working fine
2004-01-29
1 reads
security
RE: Restoring system databases to different SQL Edition
I haven't tried this either, but if the SP levels are the same I'd guess it would work. I have had issues restoring an SP3 master to a lower level server.Good reason to know what SP level your backups are on.
2004-01-29
sqljobs.exe
Awhile back I downloaded a freeware program called SQLJOBS.EXE. It graphically displayed a heat map of when jobs were scheduled by indicating a list of times with a color associated with the time. The color indicated the number of jobs that were scheduled to run during that time period. I just got a new PC […]
2004-01-29
2 reads
Can you match text rows using LIKE in a join?
Dear Forum,I'm trying to match 2 tables where one table has just the surname, while the other table has the surname within it, but also a lot of other junk such as titles first names etc.I want to match the two tables just using these variables. I've tried to match the two tables using a join of the formtable1.name LIKE […]
2004-01-29
1 reads
RE: Wonderful work on the site but where did the stars go to?
As they say, respect the rank, not the person. The rank and command structure is in place to make dissemination of orders and reacting to loss of commanders as much as possible. While this means you have issues with folks who shouldn't have the rank, generally the system works. I had to fall back on […]
2004-01-28
1 reads
RE: Dynamic SQL query
Tks Frank, that´s the point. I´ve too many code in my head that I can´t see it.
2004-01-27
RE: Dynamic SQL query
Ok,many thanks but what I´m trying to do is something more complex...Select aa, bb, 'Neto Gravado'= sum(case when tligfact.ligfaccalculcode in ('5701','5702','5703','5704','5705','5706','5707','5708','5709','5710','5711','5712','5713','171','172','12','16','28','180','5608','7709') then 0 else (tligfact.ligfacunitprice*tligfact.ligfacqtefac) end)from tligfact where ......If I put a subquery inside the IN, I get an error, it saids that I cannot put a subquery inside an agregate function !!!, seems to […]
2004-01-27
2004-01-26
2 reads
RE: Synonym for Qualified name specification of Table([LinkedName].[databasename].[username].[tablename])
Not completely sure what you mean, but you can create a viewcreate view myview as select * from servera.ownerb.tablec and then select from this view.
2004-01-23
1 reads
RE: Database (Suspect)
Here's a link to the Microsoft KB article describing the procedure mentioned above:http://support.microsoft.com/default.aspx?scid=kb;EN-US;165918
2004-01-22
Blogs
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
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