Viewing 15 posts - 10,081 through 10,095 (of 26,489 total)
SQLKnowItAll (8/15/2012)
And this?
SELECT DISTINCT so.nameFROM sys.objects SO (NOLOCK)
INNER JOIN sys.sql_modules SC (NOLOCK) on SO.object_Id = SC.object_id
AND SO.Type = 'V'--P for stored procs
AND SC.definition LIKE '%textSearch%'
ORDER BY SO.Name
If I remember correctly,...
August 15, 2012 at 2:16 pm
cljolly (8/15/2012)
August 15, 2012 at 1:56 pm
wooricom (8/15/2012)
I guess nvarchar value maybe warranty field and try to write...
August 15, 2012 at 1:47 pm
sqlserver12345 (8/15/2012)
This is my current data:
ID role unit ...
August 15, 2012 at 12:52 pm
CELKO (8/15/2012)
Probably to encourage quicker adoption of new technology. ;-)[/quote]
In part, but I write code in comments that can be used later. I usually have 2-3 versions ...
August 15, 2012 at 12:14 pm
Okay, I think we have now beaten the dead horse enough. My exposure to SSRS is helping people writing the reports to get the data sets they need, I...
August 15, 2012 at 12:07 pm
Canazei65 (8/15/2012)
I have 3 parameters in my report:
FinancialYr in this text format: '2011/12', '2012/13' etc
FromDate in Date format (UK dd/mm/yyyy)
ToDate in Date format (UK dd/mm/yyyy)
I have been trying all day...
August 15, 2012 at 12:01 pm
SQLKnowItAll (8/15/2012)
First, I don't see anything in the post to indeicate that this is an SSRS report passing parameters to a SQL query (stored procedure or what ever).
Not to beat...
August 15, 2012 at 11:39 am
SQLKnowItAll (8/15/2012)
Matt Miller (#4) (8/15/2012)
Lynn Pettis (8/14/2012)
rVadim (8/14/2012)
August 15, 2012 at 11:01 am
I have had c# training, but never had the opportunity to put it to use. Starting in high school I learned BASIC, COBOL, ALGOL, Focal, FORTRAN. Moving on...
August 15, 2012 at 10:47 am
mitzyturbo (8/15/2012)
I raised a similar thread on this some time ago and have a new problem with doing a restore of a number of databases using powershell. The script...
August 15, 2012 at 10:39 am
SQLRNNR (8/15/2012)
Evil Kraig F (8/14/2012)
Lynn Pettis (8/14/2012)
I really, really, REALLY want to ask some of these people if they even know how to think.
Right now Lynn I'm just very glad...
August 15, 2012 at 10:37 am
Cadavre (8/15/2012)
CELKO (8/15/2012)
WITH Corrected_Tests (device_id, test_value,...
August 15, 2012 at 9:41 am
CELKO (8/15/2012)
August 15, 2012 at 9:27 am
seidensc (8/14/2012)
To recap we have...
August 15, 2012 at 8:14 am
Viewing 15 posts - 10,081 through 10,095 (of 26,489 total)