I have been trying to do this for a while now to get this and, and while I have done this befor…
1 month, 3 weeks ago
By: itmasterw 60042
I have a giant table 'A' with an identity key and also a foreign key that references t…
By: Phil Parkin
I would like to parse XML data which is in table.
Declare @abc table
( id varchar(20),
By: Eddie Wuerch
I have a requirement to convert a date value like '7th March 2020' to '2020-03-07'.
By: Jeff Moden
Below is the sample data
create table temp (userid int , rid varchar(10), value varchar(100))
I would like to update TASK_NXT_RUN_DT column based on the script in column 2 dynamically. I have…
2 months ago
I have a Stored Procedure that selects one record from a table.
I want to select one row …
I have a project that requires to display a list of patients within a specific period of dates but …
Hope everyone is keeping safe from covid-19.
I need to find which particular procedure is givin…
2 months, 1 week ago
I have the following query:
Select mx.vserie, mx.vfolio
from data1 mx
inner join data2 my…
I currently have query that gives me the results i needs BUT i am needing to add a new table/column…
By: Jonathan AC Roberts
I am trying to concatenate values into one string value and what i have so far is progress, but I w…
2 months, 2 weeks ago
By: gvoshol 73146
Need a quick query help. From sysaltfiles , I want to extract the characters excluding the …
2 months, 3 weeks ago
I have a number of parameters (see below ) that come into a Stored procedure. In the applicatio…
By: Jeffrey Williams
Msg 8120, Level 16, State 1, Line 2
Column 'TimeReporting.dbo.TimeData.ID' is invalid in the select…
3 months ago
Viewing 15 topics - 16 through 30 (of 4,822 total)
You must be logged in to create new topics.