Viewing 15 posts - 586 through 600 (of 1,241 total)
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
mona_vahab (2/16/2016)
Hello,I have the same question but the problem is in my case the login and logout time is not indicated. Could you please kindly help me with that.
Hi and...
February 17, 2016 at 6:01 pm
The problem with assigning an auto-incrementing id as the primary key is that it does nothing. Imagine a data entry typist accidentally leaning on the keyboard for a while, causing...
February 4, 2016 at 6:11 pm
Perhaps this might help get you started.
February 3, 2016 at 2:37 pm
Viewing 15 posts - 586 through 600 (of 1,241 total)