-- =============================================

-- Author: Parackson

-- Create date: 9/3/2008

-- The following will return the number of sundays in a given month depending on the incoming date value

-- =============================================

CREATE FUNCTION dbo.CountSundaysInMonth(@inDate AS...

You stated that a new contruct was added to the SP.... Try removing it and then re-running the sp.... It sounds as your issues started once that line...

To me... This makes no sense.. "and (colTwo = @num2 or @num2 = 0)"

I do not know why you are doing the second or.... "or @num2 = 0"

I...

Your data provided does not match the table specifications.... Plus the query you provided continually failed due to bad syntax...

I have played with your query to at...

This answers the simple part of your question... You can use this to insert data to differnt tables if you'd like... Just change #YourDesiredTable# Also please read...

Looks like it... Between can do integer, date, varchar and there are more that I did not put down here....

Stupid question here, but are you saving currency amounts as...

SELECT

*

FROM

#YourTableName

WHERE

id BETWEEN 20 AND 30

I got this one wrong, and then when to my analyzer to figure something out.....

SELECT CAST(MIN_ACTIVE_ROWVERSION() AS FLOAT)

If you run this you get the error of Explicit conversion from data...

Are you trying to receive multiple resultsets....

RowID ...

With a little DB design you should not have to do this table....

FYI... my ID is parackson my rank on this site is Grasshopper

This answers your question but I don't quite understand why you are doing this.... (No table name provided so created table "DayOfWeekDates")

--SET START OF WEEK TO BE MONDAY (SUNDAY...

Trust me I fully understand what you are saying... I am in the wrong place and am just biding my time till I get somewhere else.... Boss is...

yes the last number is a punch type but not necessary a start or end.... Sometimes you will only have a Shift Start(300) and a Shift End(303).. Sometimes...

I know its not exactly using free-text but have you thought about the following

SELECT

*

FROM

Cars WITH (NOLOCK)

WHERE

Make = COALESCE(Make, @inMake)

AND Model = COALESCE(Model, @inModel)

Just tried it and not quite working right...

190167672008-08-17 01:30:00.0002008-08-17 09:30:00.000

190167672008-08-17 09:30:00.0002008-08-18 02:30:31.000

190167672008-08-18 02:30:31.0002008-08-18 09:00:00.000

190167672008-08-18 09:00:00.0002008-08-19 02:30:00.000

190167672008-08-19 02:30:00.0002008-08-19 10:30:00.000

190167672008-08-19 10:30:00.0002008-08-20 01:30:00.000

190167672008-08-20 01:30:00.0002008-08-20 10:00:21.000

190167672008-08-20 10:00:21.0002008-08-21 02:30:00.000

Unfortunetly I think this goes back to...