Topics
Started by
Posts
Last post
I see this syntax in Jeff M’s work and others all over the Internet. select CAST(RAND(CHECKSUM(NEWI…
15 replies
I'm looking at a poor performing stored proc and I see a "where not exists in (select...)", So I re…
6 replies
Hello everyone, I have a stored proc I am using for an SSRS application. It uses dynamic sql; what…
3 replies
I have the following three columns along with the data in table1 col1 col2 col3 Order1 AA …
5 replies
This is my table and data, CREATE TABLE [dbo].[paymentTrnx]( [idx] [int] IDENTITY(1,1) NOT NULL, …
5 replies
This is the table named zakatType with some data CREATE TABLE [dbo].[zakatType]( [idx] [int] IDEN…
1 replies
Hi i have a DB in SQL Server 2008. and i wants to store file in DB. how can i create filestream for…
1 replies
Hello there! I'm having a bit of an issue with a project I'm working on presently. Originally, I w…
1 replies
Hi Guys, I need urgent help.I am calling Store Procedure from my C# Code and inside the SP, I am ca…
6 replies
Dear All I need to insert and update a table. One column of the table needs to conform to a format …
3 replies
Hello, I'm reviewing a stored procedure that contains tons of linked server queries so I need some …
2 replies
I have a stored procedure on a SQL Server 2008 database. The stored procedure is very simple, just …
4 replies
WITH C AS ( SELECT [TSR_REP_NAME] AS 'REP_NAME',* FROM [dbo].[QLOGIC_SPIFF_PAYOUT] UNION SELECT [E…
8 replies
Hi , I know this could be simple but i am not getting it. Could anybody please help me with his. Co…
5 replies
Hello, I am trying to find a way to lock rows of data used in a SELECT query from being read by ano…
11 replies
Viewing 15 topics - 1,546 through 1,560 (of 10,647 total)
You must be logged in to create new topics.