Viewing 15 posts - 946 through 960 (of 2,458 total)
bismsit.29 (3/3/2016)
I want to assign one unique id to each row in a table and the range is from 1 to 99999. there will be a flag for active...
-- Itzik Ben-Gan 2001
March 3, 2016 at 5:36 pm
Take a look at sp_whoisactive by Adam Machanic.
-- Itzik Ben-Gan 2001
March 3, 2016 at 4:33 pm
You can run CLRs compiled and under .Net framework 2.0 on a SQL 2014 instance.
-- Itzik Ben-Gan 2001
March 3, 2016 at 4:31 pm
Building on Amos' solution... Note that you don't need "ELSE NULL" in a CASE statement. Returning NULL is the default behavior when an ELSE is not specified.
DECLARE @table1 TABLE...
-- Itzik Ben-Gan 2001
March 3, 2016 at 2:59 pm
Without handling it in the main report I think you're out of luck. You can't have drop-down parameters for sub-reports.
-- Itzik Ben-Gan 2001
March 3, 2016 at 2:49 pm
If you are using SQL Serve and wanted to handle the string manipulation inside a dataset you could do something like this:
-- your data
DECLARE @strings TABLE (s varchar(100));
INSERT @strings VALUES('PT=45.7=02/07/2002'),...
-- Itzik Ben-Gan 2001
March 3, 2016 at 2:04 pm
raven066 (3/3/2016)
Recently i was thinking about Oracle, beacuse right now I'm MS SQL DBA/DEVELOPER.
Some people said that oracle is future, and i'm little bit confused.
Can Senior members in...
-- Itzik Ben-Gan 2001
March 3, 2016 at 11:41 am
SQLRNNR (3/2/2016)
Alan.B (3/1/2016)
Ed Wagner (3/1/2016)
Alan.B (3/1/2016)
jasona.work (3/1/2016)
Hmm, using DD makes it seem so far away, lets try...
-- Itzik Ben-Gan 2001
March 2, 2016 at 12:13 pm
Sean Lange (3/2/2016)
Steve Jones - SSC Editor (3/2/2016)
Alan.B (3/1/2016)
Ed Wagner (3/1/2016)
Alan.B (3/1/2016)
jasona.work (3/1/2016)
Hmm, using DD makes it...
-- Itzik Ben-Gan 2001
March 2, 2016 at 12:00 pm
Ed Wagner (3/1/2016)
Alan.B (3/1/2016)
jasona.work (3/1/2016)
Hmm, using DD makes it seem so far away, lets try WEEK...
That's a...
-- Itzik Ben-Gan 2001
March 1, 2016 at 8:56 pm
jasona.work (3/1/2016)
Hmm, using DD makes it seem so far away, lets try WEEK...
That's a little better...
How about...
-- Itzik Ben-Gan 2001
March 1, 2016 at 7:52 pm
If you go into SSMS, Server/Instance properties that's where you can set the minimum and maximum memory settings. If the minimum memory setting is ~89% of your memory that would...
-- Itzik Ben-Gan 2001
March 1, 2016 at 5:36 pm
Stix83 (3/1/2016)
select a.Owner_Id,
b.Name as KPI,
B.Record_Type,
B.Resource_Id,
C.Display_Name,
count(A.Owner_Id) as Max
from amgr_appointments A
right outer join AMGR_Resources B on A.Owner_Id = b.Resource_Id
right outer JOIN ADMN_User_Details AS C ON A.Creator_Id=C.User_Id
where b.Resource_Id in ('R25B2864CB6', 'R2691D72523', 'R25B2868972','R25B2868EE0','R39D1B39765',...
-- Itzik Ben-Gan 2001
March 1, 2016 at 12:00 pm
Brandie Tarvin (3/1/2016)
-- Itzik Ben-Gan 2001
March 1, 2016 at 11:46 am
I don't get what MTD is or exactly what you are trying to do.
If you are looking for a default parameter value of the first day of the month and...
-- Itzik Ben-Gan 2001
March 1, 2016 at 10:18 am
Viewing 15 posts - 946 through 960 (of 2,458 total)