I am sorry, but as it is even better to generate question?

I need to in the my string find a position of the first zero, in the beginning of...

Hi gurus,

I am really need help

How I can found start and end positions for all '0' which appier in the string.

I have a string for example schedule ='1111111111111111111111111111111111110000000000001111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111110000'

I try to...

Hi Wayne,

for example I have an appointment start at 11 :45 AM finish at 1PM,but resource(technician) at 12:30 has lunch,,that mean appointment has overlap.that info in schedule fields ,when it...

Yes, it is a question.

I need to show in my report,overlapping appointments - appointments books on break/lucn etc time

it is my tables

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[appointment_line](

[appointment_line_id] [bigint] NOT...

Hi all

Thank you guys,but I solved the problem,was too tired yesterday

thanks,i try

problem is that i have sometimes both numbers are positive like 150 and 100

and in that case i should have 150-100 =50 not 150 + 100 =250

you know what ,that exact my problem.I think that it shouldn't be in that way,but it what i have now in the db and i can not changed,just have to...

sure

I have charge =-52.50

and payment =100 ishould get balance =47.5,but now I am getting -152.5

or I have charge =100 and payment = -200 I should get balance =...

Thanks ,

it was very helpfull

problem is i can not give the user play with a file,i mean i can,but user should be able pull up the report by himself and what ever he want,daly,monthly,weekly

look it is not acceptable for me, i know everything about bcp,but reqt to retrieve all list of customer from web,from report

Thank you so much i'll try that

too sad,

Thanks

my server is not crashing and i need to show list of all active cleints.

I have @group parameter,when some group choose report working fine,but for "All' it give an error