Topics
Started by
Posts
Last post
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
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
Hi, I have some sample data such as: AB123 Text Text Text Text Text Text AB456 Text Text CD789 Te…
1 replies
Hi I am receiving the following error while trying to query a .csv file using OpenRowset. I've tri…
4 replies
I have a table with a field of varchar(15) and its content is like: 111000101010100 where each digi…
5 replies
Viewing 15 topics - 2,296 through 2,310 (of 10,635 total)
You must be logged in to create new topics.