hemal_301080 (4/10/2013)

---

J Livingston SQL (4/10/2013)

---

Knowing "everything" may take a little time....its a vast subject...try putting "TSQL"...

Lynn Pettis (4/10/2013)

---

abdielmomo (4/10/2013)

---

Please, When I run a Select on my table i receive this message: "Une erreur s'est produite lors de l'exécution du lot. Message d'erreur : Dépassement SqlDateTime. Doit...

Knowing "everything" may take a little time....its a vast subject...try putting "TSQL" into a search engine....see...

maybe something along these lines....??

declare @dt1 datetime

declare @dt2 datetime

set @dt1 = '2012-09-01'

set @dt2 = '2012-10-01'

;WITH cte AS

(

SELECT

V1.item,

--V1.voucherno AS VNO,

SUM(case when v.dt < @dt1 AND v.vouchertype...

personally I like calendar tables...you can create what ever periods you need to match business requirements

here is a simple example :

use [tempdb]--====...

Lynn Pettis (4/9/2013)

---

Also, if you are adding and deleting data, you really should create a clustered index on the table. As a heap it will just continue to grow...

try this index on your heap table......not quite sure why you are worried about data load speeds...seems you are already deleting data over three days old and adding new. Therefore...

http://www.access-programmers.co.uk/forums/showthread.php?t=216956

geetha.jasmine (4/6/2013)

---

Hello,

Thanks for sharing the URL which helps understand how to post the question.

I have rewrriten the question in a word document and has been attached as an attachment...

perhaps you can be more explicit in what you are looking for......

Jeff Moden (3/30/2013)

---

lazarjojic (3/30/2013)

---

Hi!

I was wondering if I could find some queries and database tables for them. I would like to have some complicated tasks for which I need to...

just a thought

;with SD as (

SELECTname,

database_id,

create_date

FROM sys.databases

where name not in ('master','tempdb', 'model', 'msdb')

)

SELECTSD.name,

SD.create_date,

IUS.database_id,

IUS.index_id,

IUS.user_seeks,

IUS.user_scans,

IUS.user_lookups,

IUS.user_updates,

IUS.last_user_seek

FROM SD

LEFT OUTER JOIN ...

deleted....didnt read the OP correctly !

Alex koranteng (1/27/2013)

---

Thanks for the pointer. The code is the same. The data for the joins in the two environments are slightly different, because the test server data is a...

my first thought is that the data in the tables is different between servers...but I would have thought you had already checked this?