Here are 2 ways:

SELECT

N,

STUFF(

CASE WHEN (N & 1) > 0 THEN ',Bit1' ELSE '' END

...

If you're forced to work with this denormalised method of storage, then you split the bit flags out into separate columns using the following query that should be faster than...

In most circumstances it's not a good idea to store concatenated values in a base table. It will cause pain if you ever need to split the concatenated column into...

I'm not completely sure what you are trying to do, but have you tried using the FOR XML PATH('') technique?

CREATE TABLE #P (ProblemID int, OverallPlan varchar(50))

INSERT #P (ProblemID, OverallPlan)

SELECT 1,...

You can group by the expression:

DATEADD(hour, DATEDIFF(hour, 0, XDateTime), 0)

e.g.

SELECT

DATEADD(hour, DATEDIFF(hour, 0, XDateTime), 0) AS XHour,

AVG(XValue) AS XAvg

FROM MyTable

GROUP BY DATEADD(hour, DATEDIFF(hour, 0,...

I had to tweak your DDL and test data insert statements to get them to work for me...

CREATE TABLE tblCount (

TrafficId int NOT NULL IDENTITY(1,1) PRIMARY KEY,

...

Assuming that the id column is a unique or primary key column, it seems to me that your complex query:

SELECT

CASE t1.is_transferred WHEN 0 THEN t1.transferred_from_phone_no

...

Does this do what you want?

select

MAX(payrolldate) AS [payrolldate],

dateadd(dd,

((datediff(dd, '17530107', MAX(payrolldate))/7)*7)+7,

...

A couple of points to check:

If there is a possibility of gaps in the integer values of the Counter column for a given patient episode, then the query will need...

If you are using SQL Server 2005 or 2008, this method using ROW_NUMBER() might work for you:

;WITH cteSEQ AS (

SELECT

Patient,...

If your Ship_Date column is of type datetime then you don't need to worry about the extra complication that is introduced by splitting the date into year and month components.

The...

Here are some alternative methods.

You could create a View from your #veg_tab and #non_veg_tab tables, that includes an additional column (stype) indicating the original source table of the row ('N'...

Thanks Jeff

I just compared the performance for a table with a few thousand rows, and you're quite right.

I use the method I presented because I sometimes write code that still...

Something like this should do for a character data type column. A numeric datatype column would just need a cast to a varchar (or nvarchar).

DECLARE @MyList varchar(max)

SET @MyList = ''

SELECT...

A developer here gave me some insight to the query i needed to create. The comparison needed to be between the min record and the next available record and compare...