Summary query :

Select count(*)

From

Hi,

Did you try this option?

Select paginationquery.*, summary.*

From

(

Select count(*) as totrows

From

) as summary

Cross join

(

Select *

From

+

) paginationqry

.

This technique wasimplemented in our...

Hi Luis,

Another Approach for "Like" Search is to Use "DataLength" And "Replace" together, as shown below:

Begin

declare @lv_search_string varchar(100);

select @lv_search_string ='Parker'

SELECT * FROM dbo.LIKETest WHERE DATALENGTH(Name) <> DATALENGTH(REPLACE( NAME, @lv_search_string,...

Hi,

here is the solution....

create FUNCTION [dbo].[ufn_CheckvalidZIP] ( @pInput VARCHAR(1000) )

RETURNS BIT

BEGIN

--declare @pInput VARCHAR(1000);

-- set @pInput='abcd^'

declare @vValidLetters VARCHAR(1000), @pSearchChar CHAR(1)

set @vValidLetters= 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789 ';

DECLARE...

Keep the things as simple as they are!

yes,

I overlooked the original post. agreed. but, I stick to my guns ,as algorithm does not need to be changed.

Include parent tables in...

Y struggle with simple things?

Let us keep the things as simple as they are!

You include the Parent tables in the data-flow and even in control-flow, include if not exists...

Quite Simple,...