Hi,

Based on my assumption that you are having access to Microsoft SQL Server Management Studio, you can follow the options:

step 1: From object browser, right click on your database and...

Hi,

You could try (in case you need from a single query) like this:

SELECT IIF(COUNT(1)=0, 'Not Found', MAX(SSN)) 
FROM
(
SELECT
SSN FROM Table1 WHERE SSN = '401-202004-4000140'
UNION ALL
SELECT 
SSN FROM...

Hi,

Does this serve your purpose?

;WITH TestString(Test) AS
(SELECT 'J-JIM VERIFICATION FOR XX0055' AS Test UNION ALL
 SELECT 'J-JIM VERIFICATION FOR XX0044' UNION ALL
 SELECT 'J-JIM VERIFICATION FOR XX0033'...

Hi,

Can you try:

declare @string varchar(1024)

set @string = 'Total # of bytes : 128270200832 (119.46GB)'

SELECT SUBSTRING(SUBSTRING(@string, CHARINDEX(':', @string) + 1, LEN(@string))    
, 1
,CHARINDEX('(', SUBSTRING(@string, CHARINDEX(':',...

Hi,

I believe you need to download SSDT (SQL Server Data Tools) for this purpose.

https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15

Thanks,

Debasis

Hi,

I am little confused on UserProfileId being used as primary key in both the tables [Application_User].Profile and [Application_User].Login. In my opinion, it should be used as primary key in either...

Hi,

Yes, a .bacpac file can be used as a true backup for azure SQL database.

Thanks.

Hi,

Does this help?

IF OBJECT_ID(N'usp_InsertData', N'P') IS NOT NULL
DROP PROCEDURE usp_InsertData
GO

CREATE PROCEDURE usp_InsertData
AS
BEGIN
    SELECT * INTO #Test
FROM
(
SELECT 1 AS TestData UNION ALL
SELECT 2 AS TestData...

• This reply was modified 5 years, 5 months ago by  debasis.yours.

Hi,

Instead of using DEFAULT constraint, this is probably a better scenario for computed column.

Hi,

If I get your query correctly (you want the combined result of two or more check box conditions), you need to put OR condition in stead of AND...

Hi,

Can you please try like:

DECLARE @var VARCHAR(100) = 'Cosmetic bag 62x190 - Aton Cream R8241112T str98'

SELECT @var,
PATINDEX('%R[0-9]%[ABCEGHUT]%',@var),
SUBSTRING(@var,PATINDEX('%R[0-9]%[ABCEGHUT]%',@var), LEN(SUBSTRING(@var,PATINDEX('%R[0-9]%[ABCEGHUT]%', @var),LEN(@var)))-PATINDEX('% %',REVERSE(@var)))

Hi,

Does this help?

SELECT datefield FROM Table1 WHERE DateField BETWEEN DATEADD(MONTH, 1, CAST(CAST(MONTH(GETDATE()) AS VARCHAR) + '-01-' + CAST(YEAR(GETDATE()) AS VARCHAR) AS DATETIME)) AND...

Hi,

Does this help?

;WITH MinDate(DateValue)AS
(SELECT MIN(NextServ) AS MinDate FROM #lab UNION
SELECT MIN(MotDate) FROM #lab)
SELECT MIN(DateValue) FROM MinDate


I fear that may not be possible as the format that you gave is not valid as you can check below:

DECLARE @TestJson VARCHAR(MAX) = '{
...

Hi Tommy,

If you can modify the query (along with the JSON) like below, it might help:

DECLARE @MyJson VARCHAR(MAX) = '{
"api": {
...