Performace Guard (Shehap) (10/15/2011)

---

You could proceed it using the below query :

create table #temptable (F1 int, [F2.1] varchar (20), [F2.2] varchar (20), [F2.3] varchar (20))

insert into #temptable (F1 )

select...

I am going to assume this is "homework"...this question or variations of it, appear on SSC regularly.

so...food for thought...hope this gives you some ideas.

-- create some data

with produce (id,fruit, varieties)

as...

Ninja's_RGR'us (10/13/2011)

---

plus 1

also DSNless MDE's to preconfigured SQL...

I think this may help in providing you with a tried and tested solution....the code below is based on the data you initially provided.

I have had to rip/strip and create...

does the following help...courtesy of Lynn Pettis

https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx

declare @ThisDate datetime;

set @ThisDate = getdate();

select dateadd(dd, datediff(dd, 0, @ThisDate), 0) -- Beginning of this day

select dateadd(dd, datediff(dd, 0,...

Tom..what code have you got so far...can you post please...maybe it will help.

Tom Bakerman (10/10/2011)

---

BUT, one clarification, and this is where I seem to get stuck:

The result for the current month is MTD (GETDATE()). The count for previous months is for...

J Livingston SQL (10/9/2011)

---

different approach....may be give you some ideas

pls note ...date range vailidity needs scrutiny

comments in code

USE [tempdb] --- a safe place

GO

--== condtionally drop table...

different approach....may be give you some ideas

pls note ...date range vailidity needs scrutiny

comments in code

USE [tempdb] --- a safe place

GO

--== condtionally drop table for retesting in...

subasuga (10/8/2011)

---

Hi..

I have a table whose number of rows is determined only at run time. The dataset is divided into group of 5 (represented by sampleNo)

Like this...

1......AAAA......Sample1

2......SSSS.......Sample1

3......HHHH.......Sample1

4......UUUU.......Sample1

5......IIIIIII.......Sample1

6......BBBB.......Sample2

.........

10.....XXXX......Sample2

11......CCCC.......Sample3

............

15.......DDDD.......Sample3

.......

n........TTTT........SampleN

I dont know how...

Jeff Moden (10/4/2011)

---

Heh... I figured that out from your post where you said you never used it before. 🙂 I was hoping some of the other denizens of SSC...

SELECT COL1,COL2... convert(varchar,YOUR_DATE_COLUMN, 3)

No.

maybe useful in the future when dealing with 3rd pty dbs.

Sean Lange (9/29/2011)

---

ghanshyam.kundu (9/29/2011)

---

can you post your DDL properly with constraint of two tables. as per me your table design is not correct.

you should have deptid in emp table as...

hopefully this will give you some ideas.

pls post back if not undestood.

---=== use tempdb...nice safe place

USE [tempdb]

GO

---=== drop tables if they already exist....makes it easier for reruns in SSMS

IF ...