Viewing 15 posts - 1 through 15 (of 33 total)
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...
August 27, 2015 at 9:36 am
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...
August 4, 2011 at 12:40 pm
Thanks Suresh. Will only the changes to schema be replicated or will the entire schema be copied over (as in initial snapshot)?
June 11, 2010 at 5:18 am
Thanks for the help. I could go with regex.
June 3, 2008 at 1:42 pm
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...
January 17, 2008 at 9:39 am
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,...
October 2, 2007 at 9:46 am
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,...
October 2, 2007 at 8:49 am
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...
September 27, 2007 at 10:42 am
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) -...
September 13, 2007 at 12:13 pm
Thanks much David. This indeed is a very good one.
September 13, 2007 at 11:05 am
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.
September 13, 2007 at 10:25 am
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)....
September 13, 2007 at 8:49 am
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...
August 27, 2007 at 2:27 pm
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...
August 24, 2007 at 12:30 pm
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
...
August 24, 2007 at 12:17 pm
Viewing 15 posts - 1 through 15 (of 33 total)