Viewing 15 posts - 946 through 960 (of 2,462 total)
bismsit.29 (3/3/2016)
Thank you very much for replying back so early.
Its sort of a business requirement that's why i want to reuse them also this value can hold till 99999...
-- Itzik Ben-Gan 2001
March 7, 2016 at 2:51 pm
This link should help get you started:
https://msdn.microsoft.com/en-us/library/ms188282.aspx
If you post some ddl and sample data we can demonstrate on that.
-- Itzik Ben-Gan 2001
March 4, 2016 at 8:46 am
ip7915 (3/4/2016)
The CLR implementation found in the assembly Microsoft.MasterDataServices.DataQuality, can be used in SQL and it is about 300 times faster..
Yep. And if you have DQS setup it's already available...
-- Itzik Ben-Gan 2001
March 4, 2016 at 8:41 am
Duplicate thread. Direct any esponses to http://www.sqlservercentral.com/Forums/Topic1766578-3412-1.aspx
-- Itzik Ben-Gan 2001
March 3, 2016 at 5:40 pm
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
Viewing 15 posts - 946 through 960 (of 2,462 total)