Topics
Started by
Posts
Last post
Dear All, Need help to build query ,Data in the below format Name Dept Punch Date Status Robin Purc…
6 replies
Hi, Is it possible to create a table name from 2 or more strings. A simple version of what I am try…
2 replies
Hello, I am trying to process 3 XML files into DB table using a TRY/CATCH in while loop. What I wa…
2 replies
Hi How to add column in specific position without using Enterprise manager.is it possible through s…
25 replies
Hi this is my DDL DROP TABLE [dbo].[Order] GO CREATE TABLE [dbo].[Order]( [OrderID] [int] NOT NULL…
2 replies
How would I convert this query to use a JOIN in the subquery: SELECT ProcDate , MAX(b.DayKey) Day…
8 replies
Hi, I have a requirement like,every month we will have a release, we collect the code from the TFS …
1 replies
Hello, i want to drop all the non cluster indexes on a table. i do not know the names of the indexe…
2 replies
Hey all, I have a rather complicated report using a stored procedure that uses the; SELECT @vals = …
6 replies
Hi all, How can I find the character position of the first instance of the character [ in a text st…
5 replies
Could someone please share some information and some links on writing stored procedures for the cal…
3 replies
My TSQL skill/knowledge level: Newbie (please go easy) I'm trying to put together a report. I wor…
5 replies
Hi, I have a problem. In my databse I have the following numbers available: 101 104 105 110 11…
24 replies
I want to write fetch data through stored procedure where we have to join two table. for example in…
3 replies
Anyone know how to get the disk space usage of a table by row? Example: I have table A with 1 milli…
1 replies
Viewing 15 topics - 211 through 225 (of 17,082 total)
You must be logged in to create new topics.