Topics
Started by
Posts
Last post
HI All, My query is like below: declare @id numeric(17,2) = '123.456' select @id Output : 123.46 Ex…
6 replies
Hello, I have an SQL query that is working - see below. I would like to have this query cloned belo…
4 replies
I have accidentally deleted a record which originally looked like this: But now looks like …
3 replies
I have a stored procedure that is returning a set of data from a table and then is populating a sum…
5 replies
How can I turn this query to report back single line for different 'TEST" values. each one of the .…
18 replies
I have a table with multiple rows for a "Shelf Location" with the same date. example shelf 0095 has…
3 replies
My goal is to replace the numbers 1-9 in a column with a different number. For this example the num…
38 replies
I am getting this for a simple SQL statement: [Execute SQL Task] Error: Executing the query "" fail…
2 replies
I have a table structure such that each record has a lookback to a previous record. In my below ex…
7 replies
Hello, I would like to ask, where can I check which versions if SQL Management Studio is installed …
4 replies
Hello Community. I have the following code CREATE TABLE "circuits" ( "circuitId" int(11) N…
4 replies
I'm working on a script to generate DDL statements. I have a variable declared as a VARCHAR(MAX) wh…
23 replies
I need help to write the T-SQL with scenario that if room got multiple room_cd and flagged with M a…
4 replies
Hi, I have a job that rebuilds indexes after a refresh of a replicated report DB. The issue is some…
1 replies
Hi Team, I am retrieving files and file created date and file modified date from table based on the…
8 replies
Viewing 15 topics - 496 through 510 (of 3,091 total)
You must be logged in to create new topics.