They are not in the same network ( 2 different offices - one hosting the product and database and other the customer using the product) and they cannot be linked...

If you just want to check for null, you can use the following:

Select * from TableNameWhere Firstname = ISNULL(@Firstname, FirstName)

and Surname = IsNull(@Surname, SurName) and EyeColor = ISNULL(@EyeColor, EyeColor)

Hope this...

Thanks Suresh. Will only the changes to schema be replicated or will the entire schema be copied over (as in initial snapshot)?

Thanks for the help. I could go with regex.

Here is the table DDL. It does have other columns in addition to these

CREATE TABLE delivered_service

(

delivered_service_id int IDENTITY(1,1) NOT NULL,

release_note_ind char(1) NOT NULL DEFAULT ('F'),

CONSTRAINT delivered_service_pk PRIMARY KEY CLUSTERED

(

delivered_service_id...

Since you wanted it specific to each student, the query doesn't return any result (since you don't have any student related information). If you have a separate table for students,...

Here is the first shot at the queries. There could be effeicient ways of doing this as well.

Query 1:

--------

select y.ted_st_id,

x.te_gr_id,...

You can use inner join instead of left join if both ParentNodeId and ChildNodeId are non-nullable

select

pr.parentprodnodeid,

pr.childprodnodeid,

po.prodnodeid as [Parent Node],

co.prodnodeid as [Child Node],

pc.sysclassname as [Parent Class],

cc.sysclassname...

I followed David's logic to get the following

declare @a datetime

set @a = '10/31/2006'

select

case when day (@a) day(dateadd(month, 6, @a)) then

dateadd(day, day(@a) -...

Thanks much David. This indeed is a very good one.

Thanks much for the input David. This is only for month addition and I guess there is no built-in T-SQL function that I could use for this.

David,

I tried the formula that you have given in Excel and it always returns the last day of the 3rd month which is not the equivalent of dateadd(month, 3, date)....

All,

Thanks a lot for the info. It would be great if you could post information like number of sections; number of questions in each section; time constraint, if any for...

Hi all,

can anyone explain more about simulations? Do they expect us to get each click correct or is it just required to perform what is required irrespective of how many...

David,

You can use the following query :

selecta.fkid,

max(a.item)item,

max(a.atime)Atime

from#test a

inner join (select

fkid,

max(atime) Atime

from #test

group by fkid

...