It's because when you do math in the select it implicitly convert the result to the lowest datatype. In this example 1 and 17439 are both integers so the result...

You should be careful about just checking OBJECT_ID. You may have more than one object in the sys.objects table with that name. Take a look at http://msdn.microsoft.com/en-us/library/ms190324(SQL.90).aspx to see a...

Something like the following should do it:

declare @SearchChar char(1)

set @SearchChar = ' '

declare @Name varchar(50)

set @Name = 'Jamie''s Car'

select left(@Name, charindex(@SearchChar, @Name) - 1)

Me too. I ran this in my head and came up with what I thought would be correct. but since that answer was...

For me a long weekend means two very important things. First of all I have a VERY large smoker that gets fired up over this holiday weekend most years. I...

Happy to help. thanks for letting me know that worked for you. 😉

Yeah. Either way it is deleting #tempTable where there is not a match in cte_Claims.

See if this is getting you closer.

--this should now return a list of client_Ids that have claims in the period you want to exclude

;with cte_claims as(

select t.Client_Id

from #tempTable t

join tbl_Claims_master...

so you need to exlude records that do not have a claim at any point during the 4 months prior to the current one?

What exactly are you trying to do? Also in the select that you posted you have "where and ...". You left out the conditional. If you can explain your requirements...

Probably not the answer you want to hear but my suggestion would be to use a development language that was intended to create a UI instead of a DBMS that...

Instead of trying to change the query you can change the procedure declaration. Something like

create procedure MyProc

(

@First int = -1,

@Second = -1,

@Third = -1

)

as begin

select * from employee where empid...

It sounds like one of the servers language is something other than english and you are trying use @@Datefirst to return the first day consistently across all servers.

You will likely...

if you are going to pull them from a spreadsheet you should look at the concatenation function. you could use this to create your insert statement before you bring it...

look up @@DATEFIRST on BOL.