anu.anu4u (1/11/2015)

---

Actually my table is

[activityid] [int] IDENTITY(1,1) NOT NULL,

[salespersonid] [int] NULL,

[activitydate] [datetime] NULL

I am trying to make a calender using a gridview...

Quick suggestion based on Jeff's post

😎

/****** Object: UserDefinedFunction [dbo].[RE_2190] Script Date: 1/10/2015 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- ST APD Submit

-- Can not have Approved, or...

Jeff Moden (1/11/2015)

---

Are you saying that (and it looks like...

anu.anu4u (1/11/2015)

---

I have a table named activity with fields activityId,activitydate. How can I write a query to select activityId from the table between two dates in such a way that...

prabhu.st (1/11/2015)

---

Hi,

I am struggling a bit to reduce the execution time for the below query. kindly help me to tune this and to get a optimized performance.

as of now the...

First of all welcome to the forum, next some quick questions, have you checked the SMART for the SSD? Is this the full and unedited/altered output of DBCC?? How did...

ravikumar_v (1/10/2015)

---

Hi,

Require help in passing parameters to a stored proc for ex:

GO

create procedure [dbo].[sp_create_proc]

(

@v_in_dbnm varchar(255),

@v_in_schemanm varchar(30)

)

as

BEGIN

DECLARE @v_in_dbname nvarchar(255)

DECLARE @v_in_schemaname nvarchar(30)

DECLARE @sql nvarchar(MAX)

SET @v_in_dbname = @v_in_dbnm

SET @v_in_schemaname = @v_in_schemanm

SET @sql='CREATE...

Jeff Moden (1/10/2015)

---

Requires prior knowledge that the "T" is the exception. I realize that's exactly what the OP asked for but was that just because of the example he...

As implied, the concept has been around for a long time, tends to be shaped somewhat by whichever technology is in at the time. In my opinion, tossing in another...

For completeness (and some fun :-)) here are two other solutions for 2012 and later

😎

Almost direct translation to window function version, uses LAG instead of aggregation for the cross row...

Quick but slightly verbose solution, does only scan the table once but that comes at an additional cost, would be a perfect case for LAG/LEAD on SQL Server 2012 or...

Dee Dee-422077 (1/9/2015)

---

Hi,

My example data as this:

ID code1 code2

1 a ...

Got it printed in a folder along with your's (about three years back) and Phil Factor's last years RBARR / RBAR-RAND one;-)

😎

Jeff Moden (1/9/2015)

---

I personally don't know of any programming language that actually has a true random number generator function. That's not to say that there isn't one but I...

JP10 (1/9/2015)

---

Ok I have a query "SELECT ColumnNames FROM tbl1" let's say the values returned are "age,sex,race".

Now I want to be able to create an "update" statement like "UPATE tbl2...