Generally your application will use one particular account (either Windows or SQL) that has the permissions on SQL Server that you need it to have. That's not an account...

Please provide enough detail for people to be able to help you without guessing what you're talking about. Start with table definitions and go from there.

Create an account for SQL access for your Windows application. Use that account in your application. Don't give any information about that account to your users.

Can you give an example of the output you want versus an example of the output you're getting? (It's not possible for me to run the code that you've...

Obviously a lot of choices are made on the basis of personal experience and strengths.

That being said, personally I would use IIS and set up an https site and build...

This would return the position of the first space found, 0 if no spaces are found:

DECLARE @vc_test VARCHAR(255) = 'dlfkal djksfak ldfj'

SELECT CHARINDEX(' ', @vc_test)

SSRS is a ton easier to manage if all your users are already being authenticated by Windows. If they are logging onto your corporate network already, I'm fairly sure...

You mean like this?

select [person],

case [type]

when 'e' then 'e'

else null end as type,

[number]

from table1 where [type] in ('a', 'b', 'c', 'd', 'e')

order by [person],[type]

declare @TestCols table(

RecNum int not null,

Col1 decimal(10,5) null,

Col2 decimal(10,5) null,

Col3 decimal(10,5) null,

Col4 decimal(10,5) null,

...

This may or may not be what you're looking for. (As has been pointed out, you've given very little information.)

SELECT A1.PASTDEALDATE,

A2.Account,

A1.AccountId,

A1.PROCEEDS,

A1.TOTALCOST,

A1.MKTDISC,

A1.UWFEE,

A1.WARRANTCOST,

A1.IMPACTCOST,...

And actually, using the +1 to correct the flaw GSquared pointed out negates the need to use the CEILING function since any non-null is going to be a number >=...

GSquared (4/12/2010)

I'm pretty sure, if one of the values is 0, that will return...

If you have an aversion for case statements you could also do

select isnull(CAST(ceiling(coalesce(Col1,Col2,Col3,Col4,Col5,Col6)) as bit), 0)

😛

Take a look at ROW_NUMBER in BoL. If you wanted to use a table variable or temp table you could do the same thing with an identity column but...

Are you wanting to delete any user record if that user has another record within 7 actual days or are you only wanting to do this if it's in the...