Viewing 15 posts - 571 through 585 (of 1,229 total)
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
amy26 (2/17/2016)
February 18, 2016 at 2:04 pm
Jeff Moden (2/16/2016)
trvlbabie (2/16/2016)
I'm new to this so I wasn't sure - appreciate that you were so patient and helpful...not.You must like pork chops. 🙂
The following will help. http://bfy.tw/4IPS
I...
February 18, 2016 at 1:42 pm
Viewing 15 posts - 571 through 585 (of 1,229 total)