Viewing 15 posts - 211 through 225 (of 2,452 total)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 20, 2017 at 7:17 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 13, 2017 at 11:17 am
doesnt answer your question....but if you are looking for a free SQL refactoring tool that is configurable
http://www.apexsql.com/sql_tools_refactor.aspx
....Note...I do not work for these guys
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 13, 2017 at 7:15 am
maybe I am wrong (probably:P) but I don't think I have seen a solution that correctly parsesINSERT INTO #Weights
VALUES
('14lb 7.6oz') ---- note no spaces between...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 11, 2017 at 8:09 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 11, 2017 at 7:32 am
me thinks you need a join between "band" & "event" tables to start.....shouldn't be very difficult
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 8, 2017 at 2:13 pm
for these records
10000003 | 10000004
-----------------------------
10000005 | 10000006
why arent there corresponding reverse entries?.......or am I misunderstanding your post?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 5, 2017 at 9:57 am
sgmunson - Tuesday, April 4, 2017 11:35 AMSo fix it.... 😀😀😀
:w00t:
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 4, 2017 at 12:28 pm
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 4, 2017 at 10:57 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 2, 2017 at 1:38 am
possibly something along these lines...??
;WITH
cte_FixData AS (
SELECT
r.R23_SQL_ID,
r.PROP_CODE,
r.TENANT_NUMB,
From_Date = CAST(r.DATE_CHANGED_SQL AS DATE),
r.TOT_DEB_VAL ,
ROW_NUMBER() oVER (PARTITION BY r.PROP_CODE, r.TENANT_NUMB, CAST(r.DATE_CHANGED_SQL AS...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 1, 2017 at 7:48 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 31, 2017 at 12:56 pm
maybe its the way my brain works ...but I cannot accept that 4 different DOBs produce the same result.
SELECT * from dbo.AgeCalculation(' 2017-01-27 ','2017-03-01','md' ) --...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 31, 2017 at 8:46 am
a few q's......you have posted in SQL 2005 forum...pls confirm this is the version you are working on.
can you post expected results from your sample set up...so we know...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 30, 2017 at 12:56 pm
Just hired for a DBA position with no experience............ I have been hired to...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 30, 2017 at 12:44 pm
Viewing 15 posts - 211 through 225 (of 2,452 total)