Topics
Started by
Posts
Last post
Hi All... I have a question regarding calling SP with optional parameters... I have created a SP wi…
7 replies
Is there a central location where all the @@ variables are described? What I am hoping for is a var…
3 replies
Hi , I need the store procedure which i need to get the comma seperator values result in different…
11 replies
I have the following report I need to generate . I am new to SSRS. Number of Stores with Ju…
4 replies
Hello all, I have a query I am working on where an orders table has a version column for each line…
7 replies
Hi there, In SQL2000 I used to use the following in my SELECT statement - andlen ([Initials]) &g…
3 replies
I have a SQL 2008 R2 proc which compiles & executes fine. It receives input variables to exec…
17 replies
select dateformat from sys.syslanguages where name = @@LANGUAGE --mdy select getdate() --'2013-11-1…
3 replies
Hi -- Create an Employee table. CREATE TABLE dbo.MyEmployees ( EmployeeID smallint NOT NULL, Fir…
8 replies
Hi All, I am trying to execute the following query in SQL SERVER 2012. SELECT * FROM OPENROWSET ('S…
1 replies
Hi there, I am currently looking at someone else code and am getting an error when I try and run t…
3 replies
I have a question, my table have following data: userID, startTime, EndTime ————————————— 101, 04/1…
10 replies
Is there a more concise way than something like this? or name like 'aaa%' or name like 'bbb%' or …
12 replies
Hi, I found the below code that will bring back "some" of the attributes of any file in the selecte…
23 replies
Hello Is it possible to build an udf that accepts 3 parameters(@a,@b, @c) and, if @a is null (bui…
2 replies
Viewing 15 topics - 4,531 through 4,545 (of 4,984 total)
You must be logged in to create new topics.