Viewing 15 posts - 586 through 600 (of 1,248 total)
TeraByteMe (2/24/2016)
I started the job almost...
----------------------------------------------------
February 25, 2016 at 11:22 am
sharonsql2013 (2/23/2016)
Jan 2016 (2016-01-31 23:59:59.000)
, Dec 2015
and Nov. 2015
Need to be dynamic as it will change with...
----------------------------------------------------
February 24, 2016 at 5:21 pm
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
Viewing 15 posts - 586 through 600 (of 1,248 total)