Topics
Started by
Posts
Last post
Hello everyone, I'm stumped right now. Here is the deal, I need to replicate data from one table t…
19 replies
--Table CREATE TABLE #PUR_HIS1 ( SL_NUM INT, VENDOR_CODE CHAR(18), VENDOR_DESC VARCHAR(55), PO_NO …
3 replies
Please can someone help me.... I have a query which query the min and max of time in and out...the …
11 replies
I have the SQL, listed below, what I would like to do is to get the fractions down to two places (0…
5 replies
how to insert image in sql server using sql query
1 replies
Does anyone know if it is possible to call SQL Server's Statement parser (syntax checking) via T-SQ…
18 replies
What I have is a simple table (in SQL 2005) that provides input to a mapping program. It has four c…
11 replies
Hi i am trying to use select distinct with order by case but getting an error like "ORDER BY i…
7 replies
I had used 5 queries and union their result then appllied order by clause .but order by doesn't wor…
1 replies
Hi, I am trying to get an xml blob into a var from dynamic sql. However, whenever I run this: DECL…
3 replies
Hi, I have been checking all over for this solution and I know the follow: Server SQL will not refe…
3 replies
Does anyone know if there is a function [like getdate()] that you can use to get the Job's instance…
1 replies
Hi all, I have the following construct: select name, value from ( select name, value from view1 …
6 replies
Hi all, I'm running into an issue calculating yield. ;with totalcount as ( select cast(count(sn) as…
5 replies
I'm trying to run a simple dynamic sql statment but am receiving the error below. Do I have to cre…
4 replies
Viewing 15 topics - 871 through 885 (of 12,234 total)
You must be logged in to create new topics.
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy