Viewing 15 posts - 1 through 15 (of 19 total)
January 31, 2018 at 8:49 am
Luis,
Thanks so much for the 2 options, I can't use the 2nd option because I was convinced I was connecting to a 2016 instance but just now found out...
January 31, 2018 at 8:28 am
pietlinden, thank you very much for the reply, this will lead me in the right direction, appreciate your time.
Regards,
Michael
January 31, 2018 at 7:26 am
Alan and Eirikur thank you so much for the help, really appreciate it.
Below has giving me exactly what I need.
Thanks again.
Michael
;WITH BASE_DATA AS
(
SELECT
...
August 16, 2016 at 7:59 am
Hi All,
Edit - please ignore this post - apologies for confusion.
Sorry, for some reason when I hit preview it posted and when editing the post, I get no option to...
August 16, 2016 at 6:54 am
Does it have to be bulk insert? An easy, quick way is using he import wizard in SSMS (right click on the database, Tasks\Import Data).
Otherwise, here is the bulk insert...
March 23, 2016 at 12:02 pm
Drew,
Thank you so much, it's already much more clearer with your help - the formatted\layout syntax really helps. This is an excellent starting point.
Appreciate your time.
Michael
March 11, 2016 at 12:02 pm
elamranii (3/3/2016)
Hi,I am trying to retrieve a number from a field where it's between = and =
I have tried mid
=mid(Fields!PRE_LAB_VAL.Value,4,4)
but not working
PRE_LAB_VAL --------------------------Result
PT=45.7=02/07/2002-----------------45.7
RTS=51=02/07/2002------------------51
RT=26=02/07/2002--------------------26
Thank you
This link should help you.
March 3, 2016 at 1:22 pm
Orlando Colamatteo (2/11/2016)
Posting back to a similar problem/topic:http://qa.sqlservercentral.com/Forums/Topic1760478-3412-1.aspx
Thanks for this Orlando.
Michael
February 12, 2016 at 7:32 am
TheSQLGuru (2/11/2016)
micang (2/11/2016)
Hi All,
If I have a query like so:
select contractno, Address1,dateJoined,DateLastTrans
from tableTest
where datejoined between 2012-12-01 and 2015-12-31
and my results are:
Contractno,address1,datejoined,dateLastTrans
387, johnroad, 2013-06-01,2016-01-25
267, bobroad, 2015-12-01,2016-01-25
267, bobroad, 2015-12-01,2015-12-28
578,...
February 11, 2016 at 8:32 am
Thank you for the heads up about the FORMAT function and performance of it, appreciate it.
Michael
February 10, 2016 at 2:25 pm
Erik and Hugo,
Thank you so much for your help, the queries are brilliant and have helped me identify erroneous records.
Unfortunately I only have read only access to the tables in...
February 10, 2016 at 1:06 pm
Hi All,
Thank yo so much for your input.
Below is script for sample data. For the output I need to identify the member number of overlapping records so that the relevant...
February 10, 2016 at 10:49 am
Orlando Colamatteo (2/9/2016)
February 10, 2016 at 8:19 am
ScottPletcher (2/9/2016)
Yeah, should be good, except that I'd use varchar instead of char so that you don't have trailing spaces after the /s are replaced.
Thanks, I will change to varchar,...
February 9, 2016 at 3:37 pm
Viewing 15 posts - 1 through 15 (of 19 total)