Journey to SQL Authority with Pinal Dave

Posted in Best Practices, DBA, Data Warehousing, Database, Pinal Dave, SQL, SQL Authority, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL Data Storage, SQL Documentation, SQL Download, SQL Function, SQL Index, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, SQL Trigger, SQL Utility, SQLAuthority, T SQL, Technology | 9 Comments

9 Responses

1. on September 25, 2008 at 3:32 pm | Reply Richard

   Hi,
   the direct links to part 1 & 2 above both have typos

   SQL SERVER – Guidelines and Coding Standards Part – 1
   Should be http://blog.sqlauthority.com/2008/09/23/sql-server-coding-standards-guidelines-part-1/
   (Not 09/22)

   SQL SERVER – Guidelines and Coding Standards Part – 2
   Should be http://blog.sqlauthority.com/2008/09/24/sql-server-coding-standards-guidelines-part-2/
   (Not 09/23)

   
   
2. on September 26, 2008 at 3:12 pm | Reply Surendar

   Hello Dave,

   I’m having two tables

   Table1: Table2:

   ID Date Month Jan Feb Mar Remarks

   1 1 Jan xx xx xx xxxxx

   2 14 Jan xx xx xx xxxxx

   3 26 Jan xx xx xx xxxxx

   4 14 Feb xx xx xx xxxxx

   5 13 Mar

   I want distinct values of Month in Table1 to be the Column Name of Table2 as above said:
   can you help me out

   Thanks & Regards
   Surendar K

   
   
3. on September 26, 2008 at 3:21 pm | Reply Surendar

   Hello Dave,

   I want distinct values of Month in Table1 to be the Column Name of Table2 as below dynamically

   Table1:

   ID Date Month

   1 1 Jan

   2 14 Jan

   3 26 Jan

   4 14 Feb

   5 13 Mar

   Table2:

   Jan Feb Mar Remarks

   Thanks & Regards
   Surendar K

   
   
4. on May 17, 2009 at 3:41 pm | Reply ashish

   hi..
   i want count all rows with group by and also count some specific rows with same group by statement.

   department total_Emp waitng_list Joind_Emp
   —————————————————————————
   ABCD 50 10 40
   CDEF 20 10 10

   
   
5. on May 18, 2009 at 9:23 pm | Reply dhandapani

   i want need how to change to password in sql server 2005 to run vb 6.0.

   my project not connection to change password in sql server 2005 not run in visual basic 6.0

   
   
6. on October 21, 2009 at 5:08 pm | Reply Padam Dhanuk

   Hi,

   Deve,

   used adventureworks
   select * from sys.tables

   I am using these code to retrieve all tables name.
   it works but “Name” column field not showing full table name like “person.address”.
   Plz help me how can i retrieve full name of table.

   Thanks

   
   
7. on October 30, 2009 at 2:21 am | Reply Nits

   Please tell me about data vault? I don’t know anything about the same. where can i find out docs?

   
   
8. on November 1, 2009 at 4:28 pm | Reply Shaikh

   CREATE FUNCTION employees_in_project
   (@pr_number varchar(20))
   RETURNS TABLE
   AS
   RETURN (SELECT Sum(Amount) as Amount
   FROM MasterDetail
   WHERE MasterDetail.code = @pr_number)
   GO

   In Analizer

   SELECT *, employees_in_project(master.code ) as Amount FROM Master
   GO

   it not work what is error in query

   
   
9. on November 2, 2009 at 11:22 am | Reply Tejas Shah

   Hi Shaikh,

   As this is table-values function, you can not call it like this way.

   You need to access it as:

   SELECT *
   FROM TableName master
   CROSS APPLY employees_in_project(master.code)

   Tejas