In reply to Remi, here is the full code. I still get an error.Declare @tbl table (RowId int identity(1,1), ItemName varchar(100)) Insert @tbl Select ProductName FROM Products WHERE ProductName like 'M%'Select * from @tbl INNER JOIN Products p ON @tbl.ItemName = Products.ProductName
2005-05-16
Sure, sure, the MVPs pick on the little guys Since object is such an over used word, I agree and it has been changed.
2005-05-12
no but you can ask developer to exclusively grant execute permission to specified user whenever they create any new stored procedure via GRANT statement at the end.if there are many such users, build application role with execute permission to all SPs and ask developer to grant execute permission to that role.Hope this will help.
2005-05-09
2005-05-02
What exactly are you looking for? You can use the function that Jimmy Jen mentioned, STATS_DATE, to get the time when the statistics for the index was last updated. If by modified you mean when something was changed in the data that is indexed, then there is no automatic way of checking that. I do […]
2005-05-02
Can anyone think of a way to update one column when a subquery returns two values? Here is my SQL...UPDATE tmp_ar_exception SET count_fact = ( SELECT DISTINCT COUNT(F_AR_Detail.date_id) AS Expr1 FROM tmp_ar_exception LEFT OUTER JOIN F_AR_Detail ON tmp_ar_exception.dt_id = F_AR_Detail.date_id GROUP BY F_AR_Detail.date_id )
2005-04-28
1 reads
Hi Everyone!Can you please help me here, I want to transfer pdf files from one server to the other using Sql, but the server I try to transfer from it needs username and password. Here is my script and i get the error "Logon failure: unknown user name or bad password."Script exec master..xp_cmdshell 'copy \\Server1\Development\ZA\*.pdf […]
2005-04-25
Thanx for the Suggestion Frank!I 'll formalize my Database Design.RegardsJAN
2005-04-25
May be the most complete article on trees and networks I have ever read (dozens to solve problems with production and bill of materials). But also one of the most well written articles in terms of presentation and interest.Thanks, it will be a guide for me.
2005-04-25
Recreate the fmt file from the Bulk Insert tool`s format file generate option. This might help.
2005-04-20
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