Lynn Pettis (4/3/2012)

---

ColdCoffee (4/3/2012)

---

Can you define "StartDate" and "EndDate"?

Is startdate the Sunday/Monday of the week that your input date falls on and the EndDate would be exactly 7 days from...

Can you define "StartDate" and "EndDate"?

Is startdate the Sunday/Monday of the week that your input date falls on and the EndDate would be exactly 7 days from that sunday/monday?

As lynn...

Q1:

What if those characters are not present in a row? what would like it to be returned?

Q2:

Do you want to update your current columns that contains 'AiR_Fir' to just 'air_fir'...

Is there a question here?

< 2 will produce only one month data; it will exclude the second month. You may want to use <= 2. And DATEDIFF is the function...

Hi sql2k8,

With 151 points and 699 visits, you sure know how to post the questions as per the guidelines.

Please have a look at the following article on how to post...

I was 200% sure that this request would come!!!...

This of course can be broken by CONCAT_NULL_YIELDS_NULL setting. So care should be taken before executing this script.

This?

IF OBJECT_ID('T1') IS NOT NULL

DROP TABLE T1

;

IF OBJECT_ID('T2') IS NOT NULL

DROP TABLE T2

;

CREATE TABLE T1

(

PK1 INT

,C1 INT

,C2 INT

...

Will this do the cut?

; WITH CTE AS

(

SELECT Product

,[TransactionYYYYMM1]

,Ct = COUNT(*)

FROM #mytable

GROUP BY Product, TransactionYYYYMM1

UNION ALL

SELECT 'TOTAL' Product

, [TransactionYYYYMM1]

, Ct...

This , may be??

DECLARE @Replacement VARCHAR(100)

SELECT @Replacement = 'E:\fsaATLAS\BostonUniversity\'

DECLARE @Table TABLE

(

FileFolder VARCHAR(200)

)

INSERT @Table

SELECT 'D:\fsaATLAS\YourUniversityName\SevisDownloads\somepdfname.n'

SELECT T.FileFolder

,NewLoc = REVERSE(LEFT(CrsApp.Rvrs, ...

Can be done!

Will the string always follow this pattern:

drive:\rootfolder\firstfolder\secondfolder\filename.extension

??

You are right; i did not notice that u are choosing both CustomerID and ProductCode in your sub-query.I thot you were...

This will...

Jeff, is it possible to run the test on 10 Million row table, if you have time?

dwain.c (3/29/2012)

---

Actually after ColdCoffee's prior post, I was no longer confused. I...