Dynamic cross-tab queries are dealt with expertly and in great detail in these two Jeff Moden articles:

http://www.sqlservercentral.com/articles/T-SQL/63681/

http://www.sqlservercentral.com/articles/Crosstab/65048/

deleted ... somehow my post was duplicated

Why on earth would you want to bind millions of rows of data to a gridview?

It's not humanly possible to read and...

How are you measuring this?

Is this the time to insert the data into another table?

or the time to allocate the data to a...

The way to add a calculated fields is like this

CREATE TABLE dbo.Table1 (

Col1 ...

, Col2 ...

, .....

, SearchCol AS ISNULL(Col50,...

Have you tried creating a non-clustered index on Col50.

This trigger should give you the desired results.

CREATE TRIGGER [dbo].[Update_ServiceNum]

ON [dbo].[Test]

AFTER INSERT

AS

BEGIN

WITH cteMaxServiceNum AS (

SELECT s.ProjectID, MaxServiceNum =...

This is a script that I use when I need to know how much space each table is using

SET NOCOUNT ON;

CREATE TABLE #temp (

...

You need to wrap your serial/servicedate in another set of brackets

WHERE (

(t1.Serial = '00000000001' AND t1.Servicedate BETWEEN...

Eirikur Eiriksson (11/3/2016)

---

DesNorton (11/3/2016)

---

Shredding xml is not exactly the best perfprming operation in SQL. Rather get the UI to shred the XML and pass you a TVP (table valued...

Shredding xml is not exactly the best perfprming operation in SQL. Rather get the UI to shred the XML and pass you a TVP (table valued parameter).

If you need...

shorton2 (11/1/2016)

---

Probably a better way but this seems to do what I want. Allows the users to feed me an "x" to explicitly clear a field, and if they...

Deleted: Solution would not work

shorton2 (11/1/2016)

---

Probably a better way but this seems to do what I want. Allows the users to feed me an "x" to explicitly clear a field, and if they...

I tend to steer clear of the MERGE statement.

Below is a sample of doing it as separate INSERT/UPDATE statements.

--DROP TABLE #UDFTemp;

CREATE TABLE #UDFTemp (

JobNumber INT...