Topics
Started by
Posts
Last post
I have 3 Tables, one for Company, one for Contact and one for Phone Numbers. Each Company can have…
2 replies
Hello Experts, I have the following querie using case then statement for one of my fields as it fol…
2 replies
Hey all, Given the following: CREATE TABLE #Transfer ( ID INT IDENTITY PRIMARY KEY, OldKey INT, …
2 replies
I assigned to prepare SP API for vendor, but I concern about script and DB security. I have to prov…
1 replies
i want the entry for adding 2 value but i want show in the third cloumn all result with null value!…
11 replies
Hi All, How to get Current Instance Name of SQL Server from T-SQL (i.e. from Query window)?…
14 replies
Hello, We have one complex procedure which returns top 100 recent records ,it was taking too much …
1 replies
Hi, I have to write a trigger on my table to prevent data delete and also to log what is tried to …
4 replies
Just wondering, if I construct a SQL query in a Stored Proc, and pass record selection criteria int…
2 replies
I'm trying to come up with a fairly simple way to query three different columns in one table such t…
6 replies
Hello, I am working on a project that requires XML in a format that I have not worked with before. …
2 replies
TABLE tblProduct ProductId int Productname varchar(20) TABLE tblQuantityP QuantityPId Quantity int …
1 replies
I need some help with a query that involves changing the joins when a field is a certain value. Th…
1 replies
Hi All Can someone help me how to select the row with min(E_DATE+E_Time) for each PATIID from the b…
5 replies
Hello, I need help writing a stored procedure that will take a parameter in as @hostName VARCHAR(10…
7 replies
Viewing 15 topics - 781 through 795 (of 12,234 total)
You must be logged in to create new topics.