lokeshvij (7/24/2012)

---

My Friend, point here is that SQL Optimizer will not be able to use an index if the query is sargable. It will literally try to evaluate and match...

Hi and welcome to SSC. It seems you have gotten some good suggestions at finding a solution. You may be wondering why nobody responded with some sql for you. That...

http://msdn.microsoft.com/en-us/library/ms189292.aspx

Don't forget what I said in your other thread about SARGability of your query....

Just because it was written that way originally does not mean it...

I agree 100% with Chris. The easiest way to prevent sql injection in this is...

There are a couple of issue with this code. First is nonSARGable. You are doing date conversion functions in your where clause so you will be stuck with index scans.

Something...

This sounds a job for SSIS. No sql script is going to be very efficient at doing that sort of thing.

Here is one of thousands of places to get started....

raghuldrag (7/24/2012)

---

in that same procedure i want to the column of

prev_colsing_bal =(

...

I think you should take a look at this article. http://www.sqlservercentral.com/articles/T-SQL/71550/%5B/url%5D

It seems to be exactly what you are looking for.

seshu2all (7/23/2012)

---

Thanks, Sean.

From MSDN, what i could see is to grant permissions to all the views & functions separately. So, your query would help me generating a batch to execute...

Jan Van der Eecken (7/23/2012)

---

@ Sean

surely you meant

declare @MyTest int = 436

select * from Tally where N < @MyTest

select * from Tally where @MyTest > N --identical but makes me...

If you want some help you have to help us. Please provide enough information to give someone a chance at answering. We don't have ddl, sample data, desired output or...

To add to Capn's response, the following script can be tweaked to generate the sql you need.

declare @login VARCHAR(30) = 'UserID'

SELECT 'Grant View Definition ON ' + schema_name(schema_id) + '.'...

We don't even know what the question is yet. You talk about making 1 table into 5. We don't...

weston_086 (7/23/2012)

---

I have two inputs “address” and “net” . I may have to convert these two inputs into binary form. And then apply logic “AND” function....