Know COUNT of bit column using Group by in T-SQL(praveenbattula.blogspot.com)

submitted by praveenbattula(629) 1 year, 8 months ago

Here is a scenario most of the times we use and look for. I have a bit column in database table and want to filter the count of true count and false count by applying Group By on it. For example, below is the simple scenario I came up with to better present you. We are storing employee details in database and taking attendance once in every day. So, in reporting, I want to see month wise report on how many are total, absent and present. Now, the challenge is need to find out how many are total employee and among them how many are attended and how many are absent in the given month and year. read more...

add a comment |category: Database |Views: 8

tags: GroupBy Count Database T-SQL another

Best Split UDF function with delimeter in T-SQL to return result as a (praveenbattula.blogspot.com)

submitted by praveenbattula(629) 1 year, 8 months ago

This is what the function I am using since many years to get the table of values in the given ID's which are separated by some delimiter. Simple to understand and see the example in the comments in below function. From the UI there are sometimes need of sending the data or ID's in the string format separated by a delimiter. So, in database, we need to grab them and apply some operations like with the ID's we need to get the records from a table. In this case, we need to use this UDF function. Everyone knows that inner joins are far better than IN clause or something else. So, what the approach I have taken here is...... read more...

add a comment |category: Database |Views: 16

tags: UDF T-SQL Database another

Some thoughts on Stored Procedure(programming360.blogspot.com)

submitted by syedtayyabali(135) 2 years, 7 months ago

I read Paul Nielsen post on stored procedure. According to him stored procedures are good for application. He is not only talking about logical or business process stored procedure, but he also encouraged to developer for CRUD stored procedures. I think, it is good idea. There is no harm to use them. If database server have that capability, then why not CRUD stored procedures. read more...

1 comment |category: Database |Views: 18

tags: procedure T-SQL Database stored another

fn_virtualfilestats: Measure the I/O load on your disk system (sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisor(385) 2 years, 10 months ago

Microsoft included the fn_virtualfilestats function in SQL Server so you can monitor the I/O load the instance executes on the disk subsystem. read more...

add a comment |category: Database |Views: 33

tags: T-SQL SQLServer Database another

SQL Server Five methods converting rows to columns(sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisor(385) 2 years, 11 months ago

Five methods converting rows to columns read more...

add a comment |category: Database |Views: 1439

tags: T-SQL SQLServer Database another

Select top n rows from a table for each group(dotnethitman.spaces.live.com)

submitted by misbaharefin(845) 2 years, 11 months ago

Suppose you want to get the top two products from each manufacturer which have the best promotional price read more...

1 comment |category: Database |Views: 393

tags: T-SQL ROW_NUMBER Database SQLServer another

Transact-SQL to get Column Description in Sql Server 2005(webtips.co.in)

submitted by webtips(265) 3 years, 2 months ago

Transact-SQL to get the description property of the column in sql server 2005 using fn_listextendedproperty read more...

add a comment |category: Database |Views: 26

tags: Column fn_listextendedproperty T-SQL Database SQLServer another

How to Compare / Test the Equality of two Queries in SQL Server(blog.troyd.net)

submitted by powerrush(3873) 3 years, 3 months ago

Compare / Test the Equality of two Queries in SQL Server using this short T-SQL read more...

1 comment |category: Database |Views: 382

tags: T-SQL Testing Transact-SQL mssql UnitTesting another

Whats up with Stored Procedures these days?(spoiledtechie.com)

submitted by cheetahtech(815) 3 years, 3 months ago

When life throws you hard balls, you can either step back and take a swing or bunt the hell out of it. I just recently went to an information session on T-SQL, Stored Procedures and now LINQ. These folks discussed stored procedures and why they are so important in the world today. read more...

2 comments |category: Database |Views: 509

tags: Database storedproc spoiledtechie StoredProcedure SQL another

Using CROSS JOIN to generate test data(weblogs.sqlteam.com)

submitted by kprernn(1445) 4 years ago

In this blog, Joe demonstrates the power of the CROSS JOIN and how it can be harnessed to create lots of test data very quickly. read more...

add a comment |category: Database |Views: 35

tags: T-SQL SqlServer2005 SQLServer Database SQL another

The Oncoming Microsoft ASP.NET MVC with Some LINQ Tossed In - Part 2(adronbhall.com)

submitted by adron(831) 4 years ago

In the <a href="http://adronbhall.com/blogs/technology__software_development/archive/2007/12/25/6062.aspx" target="_blank">first part of this series</a> I went over how to create a basic skeleton of controllers and models so that we could create a mock test and get it green lighted along with some other tests for getting the basic navigation methods tested and green lighted.&nbsp; In this part of the series I'm going to go over the model from a LINQ point of view.&nbsp; After that in subsequent parts of this series I'll start building out the views, utilizing of course a test driven development process.&nbsp; So no more blabbering, let's code. read more...

add a comment |category: Linq |Views: 1

tags: MVC T-SQL Model Database LINQ another

Find all tables, which includes specific column name(gaaton.blogspot.com)

submitted by HaGever(915) 4 years ago

2 SQL queries how to find tables, which includes column name via using in system tables of SQL Server 2005. read more...

add a comment |category: Database |Views: 0

tags: SQLServer T-SQL Database SQL another

SQL Server error messages(weblogs.sqlteam.com)

submitted by kprernn(1445) 4 years, 2 months ago

Ever needed to find the text associated with an error number in SQL Server? This blog shows you how to retrieve it from SQL Server's metadata using T-SQL. read more...

add a comment |category: Database |Views: 2

tags: SQLServer T-SQL SqlServer2005 Database SQL another

ZIP or Address Radius Search Function for SQL Server 2000(blog.troyd.net)

submitted by powerrush(3873) 4 years, 6 months ago

SQL Server 2000/2005 function to calculate distance in miles between 2 latitude/longitude points for zip or address proximity search, etc. read more...

add a comment |category: Database |Views: 174

tags: T-SQL Geocoding UDF SQL SQLServer another

InnerWorkings tackles Transact-SQL for developers (cs.innerworkings.com)

submitted by bfinnerty(105) 4 years, 8 months ago

We help developers learn to code fundamental Transact-SQL activities such as making queries, sorting and filtering, and using table joins. Delve into control-of-flow language and using functions to manipulate data. Hands-on, practice-based, just for developers looking to learn T-SQL. read more...

1 comment |category: Database |Views: 2

tags: Training .Net VB T-SQL learn another

Deploy SQL Server databases easily with an Installer class(codeproject.com)

submitted by aleph(85) 4 years, 9 months ago

Deploy MS SQL Server databases using System.Configuration.Install and a VS.NET Setup Project. The article targets C# 1.1 but is 100% compatible with C# 2.0 and VS.NET 2005. read more...

add a comment |category: C# |Views: 55

tags: VisualStudio T-SQL .net2.0 System.Configuration.Install Deploy another