Topics
Started by
Posts
Last post
I want to select records based on a parameter. Parameter is 0 or 1. When parameter is 1 I want to…
4 replies
I wrote this trigger to check in the orders table whether the the row being inserted has made a suc…
3 replies
Hi is there any another way i can rewrite this below query. I was joining 3 coloumns from #temp5 wi…
4 replies
I'm trying to think of the best way to show breakouts of a particular column with a sum total follo…
9 replies
Im trying to generate all distinct number combinations from a stablished set of numbers. This can't…
4 replies
Hai Friends; I need the following Structure of table ; i have to cr…
2 replies
Can anybody point me in the right direction, I am using replace on a nvarchar(max) field but the re…
9 replies
Hi all, I am looking for some assistance in imroving the performance of a table valued function I h…
5 replies
I have two tables TASK_MANAGER and TASK_ACCESS_USERS I am geting data from this table for desboard …
1 replies
Hi, I need to find a way to stop users from modify tables (db objects) from the backend. What i mea…
10 replies
Hi Look at these SELECT statements. 1. SELECT CAST(1.67574 AS DECIMAL(38,10)) A, CAST(10000 AS DE…
4 replies
I have two tables TABLE 1:STUDENTS STUDIDSTUDNAME UA001Roberto GILL UA002Jack De Nero UA003Stev…
2 replies
HI All, I am trying to convert rows to columns using Pivot function. Here is my case SELECT Month(a…
1 replies
Hello, I've got a little problem when getting results from a .csv file, only because of spaces befo…
5 replies
I have a table in the following format IF OBJECT_ID(N'tempdb..#DriveInfo') IS NULL BEGIN CREATE TA…
7 replies
Viewing 15 topics - 10,216 through 10,230 (of 10,635 total)
You must be logged in to create new topics.