Topics
Started by
Posts
Last post
So I have a table with a list of many values but for this conversation the only column that matters…
3 replies
Hi All, I want to convert a trigger I wrote in Oracle SQL to T-SQL. Below is the Oracle trigger cr…
1 replies
Hi All, I need to calculate age in years, months and days format between two dates (DateFrom and Da…
2 replies
Hi Experts I have a requirement to convert the normal procedure to Dynamic sql could you please hel…
29 replies
So, I've a product price table. It can have multiple records for the date range depending on how cu…
10 replies
Does anyone have a better solution for this? I would think I have to be overlooking something. I n…
43 replies
Hi, I have an xml file ,which contains multiple namespaces and are having difficulty shredding it t…
4 replies
I need to pull a few lines of data from my company's ms sql server 2012 and put it into a text file…
1 replies
In my recent interview, they asked me this question: "What is the difference between Left Outer joi…
9 replies
Say I have a value in a table = "brkXa" I need a select statement that will replace the capital X w…
6 replies
Here's the scenario CREATE TABLE #Test ( ColumnName varchar(100), Category VARCHAR(10), …
3 replies
I have a flat file of data where the row order is important but no field in the file can be used to…
7 replies
Hi. The following procedure is used to generate update stored procedures for a database that has in…
4 replies
I have inherited a DB, and need to make some changes for a search proc. This app and DB are still i…
16 replies
I have this query: SELECT Student, Question, Answer, AnswerId AS Selected, isCorrect FROM student…
5 replies
Viewing 15 topics - 2,161 through 2,175 (of 4,984 total)
You must be logged in to create new topics.