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.
http://www.sqlservercentral.com/Forums/FindPost1758249.aspx
----------------------------------------------------
February 3, 2016 at 2:37 pm
Viewing 15 posts - 586 through 600 (of 1,241 total)