Viewing 15 posts - 1,711 through 1,725 (of 2,452 total)
hemal_301080 (4/10/2013)
J Livingston SQL (4/10/2013)
Can you suggest me from where can i know everything about TSQL and MSSQL?
Knowing "everything" may take a little time....its a vast subject...try putting "TSQL"...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 10, 2013 at 8:34 am
Lynn Pettis (4/10/2013)
abdielmomo (4/10/2013)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 10, 2013 at 6:50 am
Can you suggest me from where can i know everything about TSQL and MSSQL?
Knowing "everything" may take a little time....its a vast subject...try putting "TSQL" into a search engine....see...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 10, 2013 at 6:44 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 10, 2013 at 4:47 am
Lynn Pettis (4/9/2013)
Use a calendar table like previously suggested.
personally I like calendar tables...you can create what ever periods you need to match business requirements
here is a simple example :
use [tempdb]--====...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 9, 2013 at 2:18 pm
Lynn Pettis (4/9/2013)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 9, 2013 at 12:49 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 9, 2013 at 12:35 pm
http://www.access-programmers.co.uk/forums/showthread.php?t=216956
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 8, 2013 at 9:00 am
geetha.jasmine (4/6/2013)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 6, 2013 at 10:00 am
lazarjojic (4/1/2013)
thank you guys, but this is still too complicated for me
perhaps you can be more explicit in what you are looking for......
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 1, 2013 at 3:01 am
Jeff Moden (3/30/2013)
lazarjojic (3/30/2013)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 30, 2013 at 12:57 pm
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 ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 29, 2013 at 12:14 pm
akberali67 (2/7/2013)
A,B,C,D,OutcomeA1,B1,C1,D1,1
A2,B2,C2,,0
A3,,C3,,1
A4,,C4,,1
,,C5,,0
deleted....didnt read the OP correctly !
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 7, 2013 at 12:43 pm
Alex koranteng (1/27/2013)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 27, 2013 at 7:55 am
my first thought is that the data in the tables is different between servers...but I would have thought you had already checked this?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 27, 2013 at 6:59 am
Viewing 15 posts - 1,711 through 1,725 (of 2,452 total)