Not a really solid solution but you could alias your tables with a lot shorter name. For example, PERS_SVCMBR_TBL a

then your select would lose around 14-15 characters per line.

Not the...

I think you are wanting to elminate rows that only contain spaces?

simply add where [Field] ''

SQL treats multiple spaces in a field as an empty string. Alternately you could...

You are going to need to use a sum() function to get the total. It is impossible to tell from your post what column you want to total. The basic...

Since all the data is ultimately converted to string when exporting you should be to do something like this.

isnull(cast([YourFieldHere] as varchar(max)), '')

That way all your null values will just be...

try something like this:

select left(@a, 15 - charindex(' ', reverse(@a)))

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...