Viewing 15 posts - 226 through 240 (of 1,244 total)
September 26, 2018 at 1:18 pm
September 25, 2018 at 3:26 pm
Here's a little test harness you can use for testing...USE tempdb;
GO
CREATE TABLE dbo.LookUpValues (
id INT NOT NULL
CONSTRAINT pk_LKV PRIMARY KEY CLUSTERED,
value_desc...
September 25, 2018 at 3:24 pm
If you convert the URL to XML and squint really hard, you actually can get a working hyperlink in SSMS... Sort of...
SELECT CONVERT(XML, 'https://www.sqlservercentral.com/Forums/1997095/Table-with-hyperlink')
This...
September 25, 2018 at 9:51 am
September 25, 2018 at 9:41 am
You will need to set up the HashValue column to use two parameters. The...
September 24, 2018 at 8:52 pm
I used a slightly different approach. The problem with the previous approach is that it...
September 21, 2018 at 3:24 pm
Something along these lines perhaps...
CREATE TABLE dbo.scs_plan_code_parameters (
plan_id CHAR(1) NOT NULL,
min_price_range MONEY NOT NULL,
max_price_range MONEY NOT NULL,
cdeductible_amount MONEY NOT NULL
CONSTRAINT df_scsplancodeparameters_cdeductibleamount
September 21, 2018 at 2:10 pm
My suggestion would be to create a "Time Zone Abbreviations" table and then create an inline table valued function to sit on top of that...
Something like the following...
September 21, 2018 at 12:23 pm
Another easy option is to build the report in SSRS. The use the SSRS report schedulrer to automatically execute the report at a specified time and save it out to...
September 21, 2018 at 7:49 am
September 17, 2018 at 7:11 pm
September 17, 2018 at 6:53 pm
September 17, 2018 at 2:55 pm
Viewing 15 posts - 226 through 240 (of 1,244 total)