Viewing 15 posts - 586 through 600 (of 1,246 total)
They both need to be listed in the database 5 times each based on the specified value of 'BreedListed' that is = 5
Why not both be 7, or three? What...
----------------------------------------------------
February 24, 2016 at 5:01 pm
bwinchester (2/14/2016)
----------------------------------------------------
February 24, 2016 at 11:55 am
From MSDN >
sys.objects
Contains a row for each user-defined, schema-scoped object that is created within a database, including natively compiled scalar user-defined function.
Notice it says "within a database."
Further,
sys.all_objects
Shows the UNION of...
----------------------------------------------------
February 24, 2016 at 11:42 am
We cannot use extra columns in file.
Maybe the person or persons that made this decision and decided to put you as the implementer should take on the task themselves.
If...
----------------------------------------------------
February 24, 2016 at 11:16 am
ChrisM@Work (2/18/2016)
Nikku (2/18/2016)
I have two tables t1 & t2 which contains the same records. t1 is for bank1 & t2 is for bank2
i.e t1
accno name balance
001000 a...
----------------------------------------------------
February 23, 2016 at 1:55 pm
Jeff Moden (2/22/2016)
MMartin1 (2/22/2016)
Are there industry standard documentation that specifically addresses the correct way to handle this?
The only one I know is that you must do requirements gathering from your...
----------------------------------------------------
February 23, 2016 at 11:16 am
I would point you to Jeff Moden post and see his link on how to post code problems. It would help us to better help you if you read through...
----------------------------------------------------
February 22, 2016 at 7:30 pm
You can also check with IT that there is no obscure group policy that prohibits these connections. Though more likely I would see that the service is running on the...
----------------------------------------------------
February 22, 2016 at 7:24 pm
Are there industry standard documentation that specifically addresses the correct way to handle this?
The only one I know is that you must do requirements gathering from your team/client on how...
----------------------------------------------------
February 22, 2016 at 7:19 pm
Here is what I came up with
if object_id('#temp2') is not null
drop table #temp2;
create table #temp2 (rowNum tinyint, timein int)
insert into #temp2
select 1, '0800' union all...
----------------------------------------------------
February 22, 2016 at 7:06 pm
cast(replace(left(cast((timein/100) as varchar(5)),2),'.','') as int) as hour_ini
If you are doing timein/100 , isnt the timein column already in integer format? It seems you are converting from integer to string and...
----------------------------------------------------
February 22, 2016 at 6:56 pm
updateadmin
set [add]= CASE WHEN uname = 'jain' THEN 1 ELSE [add] END
,[ADD] = CASE WHEN uname='baiju' THEN 1 ELSE [edit] END
whereuname IN ('jain', 'baiju')
This only gets the unames...
----------------------------------------------------
February 22, 2016 at 6:35 pm
example 1
application have to get data
procedure in application with timer with parameter will select 1row from Table1
Why only select one row? Why table1 only? I still dont understand the full...
----------------------------------------------------
February 22, 2016 at 6:17 pm
Does this return anything that looks like what you may want ?
select t1.[StockCode], t1.[SalesOrder], t1.[SalesOrderLine], t1.[LotNumber], t1.[Customer],
t2.[ShipDate]
--from table t1
from (select [StockCode], [SalesOrder], [SalesOrderLine], [LotNumber], [Customer]
from
where...
----------------------------------------------------
February 18, 2016 at 2:45 pm
spin (2/17/2016)
perhaps i should have given my final expectations...
i have 2 tables which i'm trying to join. I know the lot exists under the conditions in the...
----------------------------------------------------
February 18, 2016 at 2:39 pm
Viewing 15 posts - 586 through 600 (of 1,246 total)