Topics
Started by
Posts
Last post
I'm looking at some other developer's code in stored procedures. I see she used distinct in the sel…
4 replies
Hi Team, create table xxx (UserName (varchar(256),not null) DBName (varchar(256),not null) Instance…
1 replies
Hi I am generating a HTML to send it as mail using the "sp_send_dbmail" following is my query SELEC…
1 replies
create table #t1(id int,name varchar(20)) create table #t1details(did int,id int,num varchar(10)) i…
5 replies
Is there any way to compare 3 values in a SQL statement? What I currently have is this: DECLARE @a…
31 replies
I tried to read and understand some other person created a stored procedure, in the join subquery, …
12 replies
Perform rate calculation with immediate next record from table My Temp table #Temp23 has following …
8 replies
Hi I have admin privelege on windows server but not able to connect to sql server instance using SS…
9 replies
Originally I had this curosr desgined to do this by individual and it worked fine, but then they al…
6 replies
Hi, i am trying to read a XML file using select statement. The sample has only one row by i could h…
7 replies
declare @table table ( PK int, Parent int, Level int, Codeint ) insert into @table select1…
4 replies
I have a key that is added to every single transaction in the system (similar to this: [SUBSTRING(R…
7 replies
Hello, I know this is undocumented and will happily accept any alternatives....but am trying to do …
3 replies
Hi! I'm creating a non clustered index on a table with images and i want to include an 'image' colu…
3 replies
Hi All If it needs to be in other forum, please let me know. I have situation that I have non-clus…
10 replies
Viewing 15 topics - 7,696 through 7,710 (of 10,647 total)
You must be logged in to create new topics.