Topics
Started by
Posts
Last post
I have a query that brings in a result from a table that I have to display as a negative, so I use …
11 replies
I am using SQL 2008 R2 I have declared Declare @SQLQuery Varchar(max) Set @SQLQuery = = (' A V…
6 replies
Hi All, I am a junior dba not a developer. So I'm just trying to get use to write code in T-SQL. A…
6 replies
Hi, I have three tables EmpIDs,EmpRoles and LatestRoles. I need to write a select Query to get role…
5 replies
Hi, My sample data is as below. plan type A change from plan type B from Plan type C Insurance plan…
3 replies
By: abhas
Thanks. I would appreciate any feedback.
7 replies
I've run into a brain teaser (at least to me) and I'm hoping for some forum help. Simply put, I'm t…
8 replies
How do you take a string and search for the first "-" and then drop everything from the start to, a…
5 replies
Hi All, I have a problem. I create a new user who will have a read only permission on TestDB. I wan…
1 replies
We want to not show line 1,3,5 for a specific order number #23565. We still want to see those orde…
5 replies
I need to add the Job Interval and Time to the following script: SELECT DISTINCT 'CYP_BI' AS Ser…
8 replies
Hi I am trying to insert new records into the target table, if no records exist in the source table…
8 replies
If I do a BEGIN TRAN I need to do either a ROLLBACK TRAN or a COMMIT TRAN. How do I now if there is…
3 replies
Hi, I want to compare ONLY 1 Column values from 2 tables having more than 4.9 million records. Ther…
7 replies
I have a view something like: Create VIEW SomeView AS SELECT * from Retail.dbo.Employees But now si…
16 replies
By: serg-52
Viewing 15 topics - 2,296 through 2,310 (of 10,647 total)
You must be logged in to create new topics.